SQL Managed Instance - get SQL version?

Question

I'm wanting to query SQL Managed Instances in my Azure estate to see which are eligible/using the November 2022 feature wave.

Ideally i want to do this using Azure Resource Graph. So far i have this KQL... and i'm not finding the right metadata. Any help???

resources
| where type == "microsoft.sql/managedinstances"
| where location contains "europe"
| project id, name, sku.tier, sku.capacity, properties.zoneRedundant, properties.storageAccountType, properties.storageSizeInGB, SubnetName=split(properties.subnetId,'/')[-1], properties.subnetId

Answer 1

Hello @AirGordon

Connect vis SSMS (SQL Server Management Studio) and run the classic commands SELECT @@VERSION

--Please don't forget to **upvote** and **Accept Answer** if the reply is helpful--