There are some servers where I have change the Alert Configuration from the default template, I.E. unticking the "CLR Enabled" so that it no-longer alerts for this condition. Is there a way to find all servers that have had these changes made?
Not currently, at least not without customization to build your own alert template reports.
Alert template reports are planned for a future release to help manage application of templates and audit status of what instances have modified templates.
There's not a way to perform this kind of comparison within the desktop application itself. You can, however, query the SQL DM repository database to find out which metrics aren't set to the settings that you'd expect. There are going to be three tables in the repository database that you are going to be interested in.
Using the "CLR Enabled" metric as an example, I can query MetricInfo and see that it has a metric ID of 49. Using that info alone, I can then use the following query to list the instances that have this particular metric disabled.SELECT MSS.InstanceName FROM MetricThresholds AS MT JOIN MonitoredSQLServers AS MSS ON MT.SQLServerID=MSS.SQLServerIDWHERE MT.Metric=49 AND MT.Enabled=0
I hope that helps!
Thanks for this. It is a great start. I'll take a look on Monday.
Sorry not to have responded sooner - I didn't get an alert to say there had been a response (I think I normally do)