turbot/azure_insights

Query: app_service_web_app_by_network_traffic_protocol

Usage

powerpipe query azure_insights.query.app_service_web_app_by_network_traffic_protocol

SQL

select
protocol,
count(*)
from (
select
case when https_only::boolean then 'HTTPS' else 'HTTP' end as protocol
from
azure_app_service_web_app
) as wa
group by
protocol
order by
protocol;

Dashboards

The query is used in the dashboards: