We received an important reminder today from the product group about manually editing the database, and I wanted to stress the importance of this on their behalf. The SCOM community and our customers need to know that doing so without the direct guidance and support of Microsoft is not supported, and may cause database corruption.
Specifically, they referred to removing computers and other objects by updating IsDeleted=0. This will subtly corrupt the database and cause significant problems in the long term, which may ultimately result in rebuilding the management group with a clean database.
The only supported method to manually remove stuck, stale or otherwise undesired computers and objects is to find the discovery that added it, create an override to disable the discovery for that object and then run the Remove-DisabledMonitoringObject cmdlet using the Operations Manager Shell.
I do not moderate this blog anymore. If you have a question regarding this post, send me a message.
I am stuck removing discovery for Virtual Machines that where discovered by VMM R2 Management packs!
I simply cannot find the correct object discovery to override. Also please see my forum post if you have the time! Thank you very much!