Change Agents to Remotely Manageable

Scom agents that have been installed manually will register as not Remotely Manageable, you may have had issues deploying the agent via the push method from the console so have been forced to do a manual install.

IMPORTANT NOTE:- DO NOT do the following if you use AD Integration for the scom agents in your management group and DO NOT  do this to any monitored computers that are in a DMZ because they can’t be repaired from the console.

To see if an Agent is remotely manageable in your scom console, go to the Administration node, Agent Managed, and personalize the view by right clicking in the header area and adding the Remotely Manageable column by putting a tick in the box.

You can also run the following queries against your OperationsManager database:-

Below is the SQL query to see all agents that are not remotely manageable

select bme.DisplayName from MT_HealthService mths
INNER JOIN BaseManagedEntity bme on bme.BaseManagedEntityId = mths.BaseManagedEntityId
where IsManuallyInstalled = 1

Below is the SQL query that will change ALL your scom agents back to a remotely manageable state (remember the IMPORTANT NOTE above)

UPDATE MT_HealthService
SET IsManuallyInstalled=0
WHERE IsManuallyInstalled=1

If you want to set an individual agent back to remotely manageable state use the following query but replace the agentname.domain.com with the name of your agent and domain

UPDATE MT_HealthService SET IsManuallyInstalled=0 WHERE IsManuallyInstalled=1 AND BaseManagedEntityId IN (select BaseManagedEntityID from BaseManagedEntity where BaseManagedTypeId = ‘AB4C891F-3359-3FB6-0704-075FBFE36710’ AND DisplayName = ‘agentname.domain.com’)

 

 

 

 

 

 

 

 

 

 

Advertisements
This entry was posted in SCOM Agents and tagged , , , , , , , , , , , , . Bookmark the permalink.

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