turbot/azure_insights

Query: sql_server_input

Usage

powerpipe query azure_insights.query.sql_server_input

SQL

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

Dashboards

The query is used in the dashboards: