You might remember I wrote about this many years ago, on how to exclude discovery and monitoring of Express editions of SQL using the “ExcludeList” property of the SQL discovery:
That was cool…. but really did not go as far as we needed it to. Excluding SQL Engine discoveries by Instance Name was great, but didn’t work if we had SQL Express editions out there using MSSQLSERVER as their instance name. We could not include that, as that would cause all our “real” production default instances to disappear.
It is very common that we will discover SQL Express editions by default, however, these are often unwanted to be monitored in production environments:
Well, finally, this is solved in the SQL MP 220.127.116.11 (Version Agnostic). This MP adds a new override-able property to the DB Engine discovery, for excluding by EDITION name!
Supported values (comma separated) are: Enterprise, Standard, Web, Developer, Express
It does not appear to be case sensitive.
Another new update, on the ability to Exclude discovery by INSTANCE NAME – we now have Wildcard capability. Previously we could filter our discovery by explicit name, but now we support wildcards!
So now we can exclude monitoring of SQL instances by VERSION, EDITION, and INSTANCE NAME.
See my other SQL MP How-To posts: