Forum Topic

Thanks for your participation and contribution.


Back to Log Analytics

List of Databases without Elastic Pool through Azure Graph Explorer

i90runner1
i90runner1

List of Databases without Elastic Pool through Azure Graph Explorer

Reference : https://docs.microsoft.com/en-us/azure/governance/resource-graph/samples/advanced?tabs=azure-cli

Resources
| where type =~ 'microsoft.sql/servers/databases'
| project databaseId = id, databaseName = name, ServiceObjective =tolower(tostring(properties.currentServiceObjectiveName)),
  elasticPoolId = tolower(tostring(properties.elasticPoolId))
| where ServiceObjective <>"elasticpool" 
| where databaseName <>"master" 

Last updated

1-1 of 1

Reply to this discussion

You cannot edit posts or make replies: You should be logged in before you can post.