Hi,

Is this a bug of the SQL MP? even the SQL server function is removed on the client server, rename and restart the health service of the SCOM agent.

The SQL still remain discovered and show healthy in SCOM. It is causing the the inventory list is not accurate.

Hi!

On a server that was running SQL 2008 you could check if one of the following reg key is still existing:

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\100\Machines
HKLM\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\100\Machines

If that is the case, the SQL has not been fully uninstalled. If really ALL components have been uninstalled you could rename/delete this key.

If you'd like to be on the safe side, you could override the "SQL Server 2008 DB Insallation Discovery Source" discovery rule and disable it for the specific computer.

Basically the same applies to other versions of SQL.

Cheers,
Patrick

Hi,

In addition, after disabling the discovery, you may run powershell command Remove-DisabledMonitoringObject

It removes all monitoring objects for which discovery is disabled.

More details about the command:

https://technet.microsoft.com/en-us/library/gg132269.aspx

Regards,

Yan Li

By default, SCOM cannot automatic delete discovered object even through its role removed from the agent machine. You should
1) disable the discovery on that agent
2) run powershell cmdlet Remove-DisabledMonitoringObject

Roger