This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .
Recently, we have received a few questions from customers on how they can check if all the Azure SQL Managed Instances on a subscription have been enrolled in the November 2022 Feature Wave.
Resource graph query to the rescue!
Running this query is quite easy from the Azure portal. Follow the instructions on this article to understand how to run Kusto queries against resource graph.
Use the query below.
resources
| where type =~ "microsoft.sql/virtualclusters"
| extend parsed_properties = parse_json(properties)
| extend version = tostring(parsed_properties.version)
| extend NovemberFeatureWave2022Enabled = iif(['version'] == '2.0','Yes','No')
| extend childResources = tostring(parsed_properties.childResources)
| mv-expand childResource = parse_json(childResources)
| extend subscriptionId = tostring(split(childResource, "/")[2])
| extend resourceGroup = tostring(split(childResource, "/")[4])
| extend managedInstance = tostring(split(childResource, "/")[-1])
| project subscriptionId, resourceGroup, managedInstance, VirtualCluster=name, NovemberFeatureWave2022Enabled
| order by ['subscriptionId'], resourceGroup, VirtualCluster, managedInstance
The output will show you at the subscription level if the instances have been enrolled or not.
