• Thanks for the article!

    There is a small typo in the following query

    SELECT a.[name] AS 'Logical Name',

    , a.[server_name] AS 'Server Name'

    , b.[name] AS 'Group Name'

    , a.[description]

    FROM [msdb].[dbo].[sysmanagement_shared_registered_servers] a

    JOIN [msdb].[dbo].[sysmanagement_shared_server_groups] b

    ON a.[server_group_id] = b.[server_group_id]

    ORDER BY b.[name] ASC, a.[server_name] ASC

    The comma at the end of SELECT a.[name] AS 'Logical Name', is too much. 🙂

    Question: This is for SQL Server 2008 and newer only?