turbot/azure_insights

Query: app_service_web_app_overview

Usage

powerpipe query azure_insights.query.app_service_web_app_overview

SQL

select
name as "Name",
default_site_hostname as "Default Site Hostname",
cloud_environment as "Cloud Environment",
case when enabled::boolean then 'Online' else 'Offline' end as "Status",
type as "Type",
region as "Region",
resource_group as "Resource Group",
subscription_id as "Subscription ID",
id as "ID"
from
azure_app_service_web_app
where
lower(id) = $1;

Dashboards

The query is used in the dashboards: