Monitoring Logic App Connections with Serverless360

We have a feature in Serverless360 which allows you to monitor things via Azure Resource Graph. In this video I will use the feature to show how I can monitor the health of my Logic App connections.

The query I used is below for the dashboard

Resources
| where type =~ 'MICROSOFT.WEB/connections'
| extend overallStatus = tostring(parse_json(properties).overallStatus)
| extend displayName = tostring(parse_json(properties).displayName)
| project name, displayName, id, overallStatus
| summarize count() by overallStatus

And below for the monitoring query which will give a count of broken connectors which can then be queried to trigger warnings and errors

Resources
| where type =~ 'MICROSOFT.WEB/connections'
| extend overallStatus = tostring(parse_json(properties).overallStatus)
| extend displayName = tostring(parse_json(properties).displayName)
| where overallStatus != 'Connected'
and overallStatus != 'Ready'
| project name, displayName, id, overallStatus
| summarize count()