How can we help you today? How can we help you today?

Using a SSMS Registered Server script for Monitored Servers

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

Comments

1 comment

Sort by
  • 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


    Alex B
    0

Add comment

Please sign in to leave a comment.