Is there a way to incorporated a list of Servers from a .regsrvr file into the Monitored Instances in SQL Monitor?
Comments
1 comment
-
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
Add comment
Please sign in to leave a comment.