turbot/azure_insights

Query: sql_server_firewall_rule

Usage

powerpipe query azure_insights.query.sql_server_firewall_rule

Steampipe Tables

SQL

select
r ->> 'name' as "Name",
r -> 'properties' ->> 'endIpAddress' as "End IP Address",
r -> 'properties' ->> 'startIpAddress' as "Start IP Address"
from
azure_sql_server,
jsonb_array_elements(firewall_rules) as r
where
lower(id) = $1;

Dashboards

The query is used in the dashboards: