SCOM

Unable to deleted Agentless Monitored Devices

1. Try running PS CMD Remove-DisabledMonitoringObject
2. Try deleting the server the serves as the proxy. You can then re-add the device and the agentless server will disappear.
(http://opsmgrunleashed.wordpress.com/2007/06/04/unable-to-delete-agentless-systems/)

3. Edit the OpsDB…last resort! The fields in RED vary based on your situation…do not cut/paste and run with those values.
1. Run this to determine the computer’s BaseManagedEntity
SELECT *
FROM [CCC_OpsMgrDB].[dbo].[BaseManagedEntity]
where path = '[server FQDN]'

2. Using the BaseManagedEntityID from the previous query, run this:
SELECT *
FROM [opsdb].[dbo].[TypedManagedEntity]
where basemanagedentityid = '8051416D-B303-BE6A-1A67-64E4A2381AD9'

3. Use TypeManagedEntityID learned from the previous query to see how many rows exist.
select *
from [OpsDB].[dbo].[DiscoverySourceToTypedManagedEntity]
where TypedManagedEntityID ='8051416D-B303-BE6A-1A67-64E4A2381AD9'

4. Delete the rows using the TypeManagedEntityID
delete from [OpsDB].[dbo].[DiscoverySourceToTypedManagedEntity]
where TypedManagedEntityID ='8051416D-B303-BE6A-1A67-64E4A2381AD9'

5. Confirm rows were deleted
select *
from [OpsDB].[dbo].[DiscoverySourceToTypedManagedEntity]
where TypedManagedEntityID ='8051416D-B303-BE6A-1A67-64E4A2381AD9'

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s