turbot/azure_insights

Query: app_service_web_app_offline_count

Usage

powerpipe query azure_insights.query.app_service_web_app_offline_count

SQL

select
count(*) as value,
'Offline' as label,
case
when count(*) = 0 then 'ok'
else 'alert'
end as type
from
azure_app_service_web_app
where
not enabled;

Dashboards

The query is used in the dashboards: