How to check if Azure SQL Managed Instances are enrolled (or not) on November 2022 Feature Wave?

[luisaranda]

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.