Skip to content

Instantly share code, notes, and snippets.

@pacodelacruz
Last active November 25, 2021 10:54
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/a100dbd100d9dd772b476cf6a4e3172d to your computer and use it in GitHub Desktop.
Save pacodelacruz/a100dbd100d9dd772b476cf6a4e3172d to your computer and use it in GitHub Desktop.
// Logic App instances with workflow run id, client tracking id, and workflow final status.
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)
, WorkflowRunId = tostring(customDimensions.prop__flowRunSequenceId)
, ClientTrackingId = tostring(customDimensions.prop__clientTrackingId)
, WorkflowStatus = customDimensions.prop__status
| sort by timestamp desc
//| where LogicApp contains ""
//| where Workflow contains ""
//| where ClientTrackingId contains ""
//| where WorkflowStatus == "Succeeded"
//| where WorkflowStatus == "Failed"
//| where WorkflowStatus == "Cancelled"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment