Skip to content

Instantly share code, notes, and snippets.

@pacodelacruz

pacodelacruz/logic-app-failed-trigger-count-app-insights.kql

Created November 23, 2021 11:21
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/7e340f3fcb0f9fc0d6744db4c8392ad6 to your computer and use it in GitHub Desktop.
Save pacodelacruz/7e340f3fcb0f9fc0d6744db4c8392ad6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
logic-app-failed-trigger-count-app-insights.kql
traces
| where customDimensions.EventName == "WorkflowTriggerEnd"
| where customDimensions.prop__status == "Failed"
| extend resource = parse_json(tostring(parse_json(tostring(customDimensions.prop__properties)).resource))
| project timestamp
, LogicApp = tostring(cloud_RoleName)
, Workflow = tostring(resource.workflowName)
| summarize Count = count()
by bin(timestamp, 1d),
Workflow
| render barchart
| sort by timestamp desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment