Azure Course Labs
Lab Solution
There’s a sample workbook here, exported as a JSON template:
The relevant KQL queries are:
Show most recent timestamp by app instance, displaying time-ago in minutes
AppTraces
| summarize arg_max(TimeGenerated, AppRoleInstance) by AppRoleInstance
| project Instance=AppRoleInstance, LastSeen=datetime_diff('minute', now(), TimeGenerated)
Show count of failures by instance
AppTraces
| where Properties.EventType == "Fulfilment.Failed"
| summarize count() by AppRoleInstance
Show breakdown of queue size over time
AppMetrics
| where (Name == "QueueSize")
| summarize AvgQueueLength = avg(Sum) by bin(TimeGenerated, 10m)
You can import that into a new workbook:
- in edit mode click the Advanced editor icon which looks like this:
</> - copy and paste the template JSON into the advanced editor
Your workbook should load:
