Skip to content

Instantly share code, notes, and snippets.

@pacodelacruz

pacodelacruz/ErrorCount.txt

Created February 11, 2021 04:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pacodelacruz/3fddcdc66a28c2a8b5717f74df8c5771 to your computer and use it in GitHub Desktop.
Save pacodelacruz/3fddcdc66a28c2a8b5717f74df8c5771 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ErrorCount.txt
// Error Count grouped by InterfaceId and trace event type (EventName)
traces
| sort by timestamp desc
| where customDimensions.prop__Status == "Failed"
| where customDimensions.EventName != ""
| where tostring(customDimensions.prop__InterfaceId) != ""
| project EventName = tostring(customDimensions.EventName)
, InterfaceId = tostring(customDimensions.prop__InterfaceId)
| summarize Count = count(EventName)
by InterfaceId
, EventName
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment