Hi experts,
I have added 50 server names into a node named PROD in registered servers. The name appear in the left-side panel and I can run queries against them. There are few duplicates i would like to clean up, even though the dups don't appear in the panel.
When I run this, it doesn't return any rows.
SELECT *
FROM [msdb].[dbo].[sysmanagement_shared_registered_servers]
0 rows
Which table contains the registered servers?
Thanks