Using a SSMS Registered Server script for Monitored Servers

Miles

Is there a way to incorporated a list of Servers from a .regsrvr file into the Monitored Instances in SQL Monitor?

Alex B

Hi @Miles

There isn't a specific functionality to import from the SSMS registered servers, but you may be able to get a list of servers using PowerShell (e.g. like https://stackoverflow.com/questions/9322777/getting-a-list-of-registered-servers-thru-powershell-to-csv) and then modify that to match the import format seen in the "Import servers from CSV" example:

Type,Group,Server,SqlUsername,SqlPassword
<span>AzureSqlServer,"1 - Production","my-azure-db.database.windows.net","my_username","my_s3cur3_p4ssw0rd"</span>

And then use that example to import the servers.

Kind regards,
Alex