turbot/azure_insights

Query: network_public_association

Usage

powerpipe query azure_insights.query.network_public_association

Steampipe Tables

SQL

select
'Association' as label,
case
when ip_configuration_id is not null then 'Associated'
else 'Not Associated'
end as value,
case
when ip_configuration_id is not null then 'ok'
else 'alert'
end as type
from
azure_public_ip
where
lower(id) = $1;

Dashboards

The query is used in the dashboards: