turbot/azure_insights

Query: mssql_elasticpool_for_sql_database

Usage

powerpipe query azure_insights.query.mssql_elasticpool_for_sql_database

SQL

select
lower(p.id) as mssql_elasticpool_id
from
azure_sql_database as db
left join azure_mssql_elasticpool as p on lower(p.name) = lower(db.elastic_pool_name)
where
db.resource_group = p.resource_group
and db.subscription_id = p.subscription_id
and p.id is not null
and lower(db.id) = $1;