Warning: substr() expects parameter 1 to be string, array given in /home/byty/public_html/wp-content/plugins/wordbooker/wordbooker.php on line 1520

Clean Ghost Orphaned entries in SCOM console

In case that you have Server or Objects that do not report correctly in SCOM you can check the SQL table  BaseManagedEntity.

You can check same table in case you want to delete Agents from the database directly or to the agents that somhow got Stuck ( they are not in Pending any longer but they are detected like Windows Computers in the state Not Monitored).

To do this

1) Check the values of the column IsDeleted  from the  table BaseManagedEntity by using the Query:

select * from BaseManagedEntity where FullName like ‘%FQDN of your computer%’

2) Set the value IsDeleted  for the objects to 1.

UPDATE dbo.[BaseManagedEntity] SET IsDeleted = 1 where FullName like ‘%FQDN of your computer%’

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Leave a Reply