Forum Topic

Thanks for your participation and contribution.


Back to Log Analytics

List of Databases without Elastic Pool through Azure Graph Explorer

Post a reply
380 views
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.