How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ?

Question

How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ?
I would like to write a query to get which CU is installed on my sql servers managed with Azure Arc.
I don't find the exact product version. For instance, 15.0.4375.4

Answer 1

Hello Jean-Marie Roger,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that you would like to know how you can get the SQL server cumulative update version installed for Azure Arc Enabled Servers.

To streamlines compliance and update management by combining direct SQL metadata extraction with Azure’s centralized querying tools.

Start by verifying the installed cumulative update (CU) for Azure Arc-managed SQL Server instances, execute a SQL query to retrieve version details. The following script uses built-in functions to extract key metadata:

SELECT 
    SERVERPROPERTY('ProductVersion') AS ProductVersion,  -- Returns version (e.g., 15.0.4375.4)
    SERVERPROPERTY('ProductLevel') AS ProductLevel,      -- Indicates release phase (RTM, CU, SP)
    SERVERPROPERTY('Edition') AS Edition,                -- Shows edition (Standard, Enterprise, etc.)
    SERVERPROPERTY('EngineEdition') AS EngineEdition;    -- Specifies engine type (Azure, on-premises)

The ProductVersion value maps to specific CU releases. For instance, version 15.0.4375.4 corresponds to SQL Server 2019 CU16 - https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/update?view=sql-server-ver16

For environments with multiple SQL Servers, use Azure Resource Graph Explorer to centralize version tracking. The Kusto query below lists instances and their versions:

resources
| where type == "microsoft.sql/servers"                 -- Filters Azure SQL resources
| project name, properties.version                      -- Displays name and version

NOTE: Adjust the type of filter based on your Azure Arc configuration. For Arc-enabled servers, you can review - https://learn.microsoft.com/en-us/azure/azure-arc/servers/manage-sql-server-instance) to ensure accurate resource type syntax.

I hope this is helpful! Do not hesitate to let me know if you have any other questions or clarifications.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.

Answer 2

Hi Jean-Marie Roger

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/update?view=sql-server-ver16

If you have any further queries, do let us know.

---

If the answer is helpful, please and "Upvote it".