We are changing our account for connecting to the servers from DM from a SQL Server account to a Windows AD account, and need to do this for ~180 servers. Is there a way to change these accounts in bulk, or will we have to reset the user manually for all servers?
I would suggest using the SQLdm PowerShell snap-in if you want to update the settings for several monitored instances quickly. There's some information about the PowerShell snap-in at http://wiki.idera.com/display/SQLDM/PowerShell+Cmdlets+for+SQL+Diagnostic+Manager.You'd probably want to use the Set-SQLdmMonitoredInstance cmdlet since it allows you to update settings for the monitored SQL Server(s). I previously wrote a blog post about using the snap-in to register several instances for monitoring. You could use that post as a guide for updating multiple instances.
Powered by IDERA