Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Orphaned systems in SCOM 2007 R2 monitoring window

Posted on 2011-03-17
2
Medium Priority
?
4,540 Views
Last Modified: 2012-05-11
I have a number of obsolete servers that were removed from our network before I had a chance to uninstall the SCOM agent via the SCOM console.  I have deleted these machines from within the Administration/Agent Managed window, however they remain within the Monitoring/Computers window with a greyed-out critical state.  I've searched for a way to remove these ophaned objects, but so far nothing has worked.  I do seem to recall having read an article that indicated that this may happen if there are unclosed alerts or events that reference the machine object.  However, I have can't find any open alerts or events for these machines.  Anyone know how to get rid of these pesky dead machines from SCOM?
0
Comment
Question by:UrHuckleberry
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
ssiimmppllee earned 2000 total points
ID: 35158406
You will need to remove the objects from the Database. This is fairly easy to do. Here are the steps that i use when i have this issue.

System Center Operations Manager 2007 stores all "entities" it "manages" in the BaseManagedEntity table in the Operational database (named "OperationsManager", by default). This is the place where we will be manually telling SCOM that this computer does not exist anymore. There's a column called "IsDeleted" that stores if the agent was removed.


1. Connect to the SCOM SQL server and open SQL Management studio
2. Right click on OperationsManager database and select new query
3. Run the following query in the right window  to see the status of ALL computers in SCOM
 

SELECT * FROM dbo.[BasemanagedEntity] where FullName Like '%Windows.Computer%'


4. To see the status of a specific computer in SCOM (replace the text "fqdn" with the server name)

SELECT * FROM dbo.[BasemanagedEntity] where FullName Like '%Windows.Computer%' and Name Like '%FQDN.of.my.computer%'
 

 
5. In the results scroll to the right to find the "IsDeleted" column. 0(Zero) means the database does not know the computer has been deleted. If it is zero then we will run the next command to change it to 1 (one)

replace the text "fqdn" with the server name


UPDATE dbo.[BasemanagedEntity] SET IsDeleted = 1 where FullName Like '%Windows.Computer%' and Name Like '%FQDN.of.my.computer%'

 
 

Going back to the Operations Console to the Monitoring & Computer section, shows us that the computer does not show in the list already. It will still take some time before it really gets deleted in the database, but visually you are already set. (Do note that the machine and its child objects like disk and CPU are still there in the Data Warehouse. This will stay there until that expired there also; which is 360 days by default).

 

0
 

Author Closing Comment

by:UrHuckleberry
ID: 35159032
Worked like a charm!  Thank you very much for sharing that with me!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question