turbot/azure_insights

Query: app_service_web_app_input

Usage

powerpipe query azure_insights.query.app_service_web_app_input

SQL

select
wa.title as label,
lower(wa.id) as value,
json_build_object(
'subscription', s.display_name,
'resource_group', wa.resource_group,
'region', wa.region
) as tags
from
azure_app_service_web_app as wa,
azure_subscription as s
where
lower(wa.subscription_id) = lower(s.subscription_id)
order by
wa.title;