I am looking for an answer for our problem:
We use SCOM 2007 R2. Under Monitoring/Windows Computers, I see some old computer names, what are unavailable long time ago. So no way to start them - most case find them is not possible also - and I want to remove them from this view.
The official solution for this remove problem, is go Administration menu, and delete the affected computers shown under Agent Managed or Agentless Managed submenus.
My problem is, that our effected computers are not listed at all under any submenu in Administration.
I was unable to find a proper answer into this problem. I had find a script a few month ago, what was able to delete the affected computers from the Monitoring/Windows Computers list, but this "solution" worked only till the restart of the Management Server.
So, what SQL command or other thing should I do/run, to solve this?