turbot/azure_insights

Query: parent_cosmosdb_restorable_database_account_for_cosmosdb_account

Usage

powerpipe query azure_insights.query.parent_cosmosdb_restorable_database_account_for_cosmosdb_account

SQL

select
lower(ra.id) as restorable_database_account_id
from
azure_cosmosdb_restorable_database_account ra,
azure_cosmosdb_account a
where
ra.id = a.restore_parameters ->> 'restoreSource'
and lower(a.id) = $1;