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

We’ve recently received several questions from customers about how to ensure that all Azure SQL Managed Instances in their subscription are registered. Feature Wave November 2022.

Solve your problems with Resource Graph Queries!

Running this query is very easy in the Azure Portal. Just follow these instructions: This article Learn how to run Kusto queries against a 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, "https://techcommunity.microsoft.com/")[2])
| extend resourceGroup = tostring(split(childResource, "https://techcommunity.microsoft.com/")[4])
| extend managedInstance = tostring(split(childResource, "https://techcommunity.microsoft.com/")[-1])
| project subscriptionId, resourceGroup, managedInstance, VirtualCluster=name, NovemberFeatureWave2022Enabled
| order by ['subscriptionId'], resourceGroup, VirtualCluster, managedInstance

The output shows whether the instance is registered at the subscription level.