SCOM: Disable discovery / Exclude Group of Servers from the Version-Agnostic SQL MP

Question

Hi,

We have successfully migrated one of our environments to the Version-Agnostic SQL Management Pack. Now, we have multiple SQL servers that have to be excluded from the management pack discovery. I am aware that the target for the “MSSQL on Windows: Discover SQL Server Database Engines (Local)” cannot be a Group of servers. In the MP guide description, Microsoft writes, that I have to create an override, which is pointing to every DB instance by name (this is crazy!). Is there another way to exclude those servers?

Best,

Deyan

Answer 1

You should be able to Override -> Enable -> False the MSSQL on Windows: Discover SQL Server Database Engines (Local) discovery for a group of Windows Computer objects, since that discovery is targeted at the MSSQL on Windows: Local Discovery Seed class which itself is hosted by the Windows Computer class.
Then run Remove-SCOMDisabledClassInstance to remove the DB Engines that were already discovered.

The Exclusion override is more designed for the case where you need to exclude a specifc instance from being discovered, not for when you need to entirely disable SQL discovery for a given server!