turbot/azure_insights

Query: network_load_balancer_input

Usage

powerpipe query azure_insights.query.network_load_balancer_input

SQL

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

Dashboards

The query is used in the dashboards: