turbot/azure_insights

Query: mssql_elasticpool_for_sql_server

Usage

powerpipe query azure_insights.query.mssql_elasticpool_for_sql_server

SQL

select
lower(p.id) as mssql_elasticpool_id
from
azure_mssql_elasticpool as p
left join azure_sql_server as s on lower(p.server_name) = lower(s.name)
where
s.resource_group = p.resource_group
and s.subscription_id = p.subscription_id
and lower(s.id) = $1
and s.subscription_id = split_part($1, '/', 3);