pacodelacruz
pacodelacruz
/ logic-apps-instances-log-analytics.kql
Created
November 25, 2021 11:02
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| AppTraces | |
| | where OperationName == "FlowRunLastJob" | |
| | extend resource = parse_json(tostring(parse_json(tostring(Properties.prop__properties)).resource)) | |
| | project TimeGenerated | |
| , LogicApp = tostring(AppRoleName) | |
| , Workflow = tostring(resource.workflowName) | |
| , WorkflowRunId = tostring(resource.runId) | |
| , ClientTrackingId = tostring(Properties.prop__clientTrackingId) | |
| , WorkflowStatus = tostring(Properties.prop__status) | |
| | sort by TimeGenerated desc |
pacodelacruz
/ logic-app-failed-trigger-details-app-insights.kql
Created
November 23, 2021 11:25
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| traces | |
| | where customDimensions.EventName == "WorkflowTriggerEnd" | |
| | where customDimensions.prop__status == "Failed" | |
| | sort by timestamp desc | |
| | extend properties = parse_json(tostring(customDimensions.prop__properties)) | |
| | extend resource = parse_json(tostring(parse_json(tostring(customDimensions.prop__properties)).resource)) | |
| | extend error = parse_json(tostring(customDimensions.prop__error)) | |
| | sort by timestamp desc | |
| | project timestamp | |
| , LogicApp = tostring(cloud_RoleName) |
pacodelacruz
/ logic-app-failed-trigger-count-app-insights.kql
Created
November 23, 2021 11:21
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
pacodelacruz
/ logic-app-failed-count-app-insights.kql
Created
November 23, 2021 11:19
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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) |
pacodelacruz
/ logic-app-failed-instances-app-insights.kql
Created
November 23, 2021 10:31
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| traces | |
| | where operation_Name == "FlowRunLastJob" | |
| | extend resource = parse_json(tostring(parse_json(tostring(customDimensions.prop__properties)).resource)) | |
| | extend error = parse_json(tostring(customDimensions.prop__error)) | |
| | project timestamp | |
| , LogicApp = tostring(cloud_RoleName) | |
| , Workflow = tostring(resource.workflowName) | |
| , WorkflowRunId = tostring(customDimensions.prop__flowRunSequenceId) | |
| , ClientTrackingId = tostring(customDimensions.prop__clientTrackingId) | |
| , WorkflowStatus = customDimensions.prop__status |
pacodelacruz
/ logic-app-tracked-properties-app-insights.kql
Created
November 22, 2021 10:32
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Logic App instances with workflow final status, workflow run id, client tracking id, and tracked properties. | |
| 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 |
pacodelacruz
/ logic-app-instances-app-insights.kql
Last active
November 25, 2021 10:54
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 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 |
pacodelacruz
/ user-updated-pub.json
Created
November 17, 2021 10:49
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "definition": { | |
| "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#", | |
| "actions": { | |
| "For_each_message_in_batch": { | |
| "actions": { | |
| "Parse_message": { | |
| "description": "Parse each individual record", | |
| "inputs": { | |
| "content": "@items('For_each_message_in_batch')", |
pacodelacruz
/ logic-apps-workflows-by-status-count-app-insights.kql
Created
September 11, 2021 11:53
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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) |
pacodelacruz
/ logic-apps-workflows-by-status-details-app-insights.kql
Last active
September 11, 2021 11:51
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| traces | |
| | where operation_Name == "FlowRunLastJob" | |
| | extend resource = parse_json(tostring(parse_json(tostring(customDimensions.prop__properties)).resource)) | |
| | extend error = parse_json(tostring(customDimensions.prop__error)) | |
| | project timestamp | |
| , LogicApp = tostring(cloud_RoleName) | |
| , Workflow = tostring(resource.workflowName) | |
| , WorkflowRunId = tostring(customDimensions.prop__flowRunSequenceId) | |
| , ClientTrackingId = tostring(customDimensions.prop__clientTrackingId) | |
| , WorkflowStatus = customDimensions.prop__status |
NewerOlder