Troubleshoot using Kusto¶

Kusto Extra MetaData is stored in property bag CustomDimentions, ClientEvents, CustomEvent and TraceEvent

SQL

ClientEvents
| where Timestamp > todatetime("2019-04-01 20:31:02Z") and Timestamp < todatetime("2019-04-01 20:51:02Z")
| where Name == "GenericErrorDialog"
| extend cd = parsejson(CustomDimentions) 
| where cd.errorCode contains "GenericGetCompanyInfo" or cd.errorMessage contains "Undefined"
| where cd.rootActivity == ""

SQL

TraceEvent
| where ActivityType contains "HcmAttEOL"

SQL

ClientEvents
| where RootActivityId == "" 
// If there is no output then we can get it from TraceEvent

SQL

TraceEvent
| where RootActivityId = ""

SQL

TraceEvent
| where SessionId == ""
| project TIMESTAMP, RootActivityId, ActivityType, ActivityVector, TraceLevel, TraceMessage

SQL

TraceEvent
| where RootActivityId == ""
| project TIMESTAMP, Application, ActivityType, ActivityVector, TraceLevel, TraceMessage

With Local timestamp and sorting 👍

SQL

TraceEvent
| where  TraceLevel == "Error"
| where  ActivityType == "HcmASHandleChangeMessage"
| extend LocalTime = TIMESTAMP - 7h // UTC -> PST
| project format_datetime(LocalTime, 'yy-MM-dd [hh:mm:ss tt]'), format_datetime(TIMESTAMP, 'yy-MM-dd [hh:mm:ss tt]'),Tenant,ActivityType,ActivityVector,TraceLevel, TraceMessage
| sort by TIMESTAMP

ActivityVector provide the sequence of execution for Async calls so it's helpful on building the call stack during investigation

Tip

Text Only

:bulb: Notes
```markdown
* Leverage TraceEvent not just ClientEvents using raid/session id etc
* Leverage activity vector, activity type, application, service
* Use custom dimensions when needed
* Use status app for environment details, tenant details, user information
* Use tsg/wiki - all possible exception are there so search for it
* xrm exceptions - there is an amazing wiki - use that (xrm is on top of CDS)
* Play with product to understand how something should work
* Big picture - don't focus on just one issue what is reported - offer example
* repro - last thing to do 
```

Tip

Text Only

Apps 💡
```markdown
* Go1Adapter.sln
* XRMSolutions.sln
* TalentEngagementServiceApp.sln (Attract Service)
* SchedulingServiceApp.sln (Schedular for scheduling interviews and stuff)
* OfferManagementService.sln
* JobPostingServiceApp.sln
* OnboardingServiceApp.sln
* ProvisioningServiceApp.sln
* FlightingServiceApp.sln
* All services are in D365
```

Onboarding¶

Resources/links¶

Apps¶

Onboard Offer Attract

Tools¶

Repo Data Explorer web

Kusto Environments¶

Connection: https://dynamicshcmint.kusto.windows.net Connection: https://dynamicshcmint.kusto.windows.net

Troubleshoot using Kusto¶

Onboarding¶

Resources/links¶

Apps¶

Tools¶

Kusto Environments¶

Documents¶

TODO¶

Kusto Environment¶

ICM Query¶

Attract¶