Skip to content

Instantly share code, notes, and snippets.

@pacodelacruz
Created November 23, 2021 11:19
Show Gist options
  • Save pacodelacruz/e9946bf3669c0c62445c936c7b467523 to your computer and use it in GitHub Desktop.
Save pacodelacruz/e9946bf3669c0c62445c936c7b467523 to your computer and use it in GitHub Desktop.
traces
| where operation_Name == "FlowRunLastJob"
| extend resource = parse_json(tostring(parse_json(tostring(customDimensions.prop__properties)).resource))
| project timestamp
, LogicApp = tostring(cloud_RoleName)
, Workflow = tostring(resource.workflowName)
, WorkflowStatus = tostring(customDimensions.prop__status)
| where WorkflowStatus == "Failed"
| summarize Count = count()
by bin(timestamp, 1d)
, Workflow
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment