Command Shell Examples
Useful SQL Queries
Manually removing computers by editing the database - Jonathan Almquist on Operations Manager - Site Home - TechNet Blogs

Manually removing computers by editing the database

Manually removing computers by editing the database

  • Comments 1
  • Likes

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.

Comments
  • Hello Jonathan.

    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!

    social.technet.microsoft.com/.../a879007f-9512-453b-8ee4-45fce4a6338f