turbot/azure_insights

Query: app_service_web_app_ip_security_restrictions

Usage

powerpipe query azure_insights.query.app_service_web_app_ip_security_restrictions

SQL

select
r ->> 'name' as "Name",
r ->> 'priority' as "Priority",
r ->> 'ipAddress' as "IP Address",
r ->> 'action' as "Action",
r ->> 'description' as "Description"
from
azure_app_service_web_app,
jsonb_array_elements(configuration -> 'properties' -> 'ipSecurityRestrictions') as r
where
lower(id) = $1;

Dashboards

The query is used in the dashboards: