SystemCenter

All about System Center Articles and Tutorials

Find Monitored Object ID in Operations Manager

Posted by on Mar 23, 2017 in PowerShell, SCOM, SCOM 2012, SCOM 2016, SQL

Find Monitored Object ID in Operations Manager

There are scenarios wherein SCOM Administrators need to find out the GUID of monitored object in Operations Manager.

One recent example, we had around hundred objects to which we wanted to add in a specific group in Operations Manager however manual process would be a hectic and time consuming task. So, we decided to modify the Explicit Group Membership using PowerShell which need GUID of the monitored object.

It’s not possible to get the GUID of monitored object using SCOM console so below are the three methods through which we can fetch this information:

1: Using Operations Manager PowerShell.

2: Using SQL Query (Query the OperationsManagerDW).

3: Using SCSM Entity Explorer.

So, let’s start…

Using Operations Manager PowerShell

1: Open Operations Manager Shell on Management Server.

2: Run below cmdlet:

Get-SCOMMonitoringObject -DisplayName “COMPUTER FQDN” | select name,id

EXAMPLE: Get-SCOMMonitoringObject -DisplayName “SCMVPAGENT.test.com” | select name,id

You can run below cmdlet to check the GUID of all the objects under Microsoft Windows Computer class:

Get-SCOMClass -Name `Microsoft.Windows.Computer’ | Get-SCOMClassInstance | select name, id

If you have large number of objects being monitored, the cmdlet will take a good amount of time to display the result. Will not advise to run this, better to use SQL Query in this scenario.

Using SQL Query

Below query needs to be executed on OperationsManagerDW database:

SELECT [ManagedEntityGuid] as ObjectGUID
,[DisplayName] as ObjectName
FROM [OperationsManagerDW].[dbo].[vManagedEntity]
WHERE [FullName] LIKE ‘Microsoft.Windows.Computer:%’

The query will show you the list of all managed Microsoft Windows computers object GUID.

If you want the list of specific objects, you may run below query:

SELECT [ManagedEntityGuid] as ObjectGUID
,[DisplayName] as ObjectName
FROM [OperationsManagerDW].[dbo].[vManagedEntity]
WHERE [FullName] LIKE ‘Microsoft.Windows.Computer:%’
and DisplayName in (‘COMPUTER1 FQDN’,’COMPUTER2 FQDN’)

EXAMPLE:

SELECT [ManagedEntityGuid] as ObjectGUID
,[DisplayName] as ObjectName
FROM [OperationsManagerDW].[dbo].[vManagedEntity]
WHERE [FullName] LIKE ‘Microsoft.Windows.Computer:%’
and DisplayName in (‘SCMVPAGENT1.test.com’,’SCMVPSEP21.test.com’)

If you want to get both Health Service Watcher (Agent) and Microsoft Windows Computer object, use below query:

SELECT [ManagedEntityGuid] as ObjectGUID
,[DisplayName] as ObjectName
FROM [OperationsManagerDW].[dbo].[vManagedEntity]
WHERE ([FullName] LIKE ‘Microsoft.Windows.Computer:%’ or FullName LIKE ‘Microsoft.SystemCenter.HealthServiceWatcher:Microsoft.SystemCenter.AgentWatchersGroup;%’)
and DisplayName in (‘SCMVPAGENT1.test.com’,’SCMVPSEP21.test.com’)

Using SCSM Entity Explorer

SCSM Entity Explorer is a free tool for System Center Service Manager (SCSM) administrators to help them browse and get information about the classes and objects stored in the SCSM database however it works perfectly fine with Operations Manager as well.

The tool is developed by Dieter Gasser and can be downloaded from TechNet Gallery here: Download SCSM Entity Explorer

Please download and give 5-star rating, you will surely like this tool.

After downloading the SCSM Entity Explorer tool from TechNet Gallery follow below:

1: Login on to SCOM Management Server and place the SCSM Explorer Tool on desktop.

2: Right click SCSMEntityExplorer.exe and select Run as administrator.

3: Provide SCOM Management Server FQDN under SCSM Management Server box and click Connect.

4: Select Display name under Show types as option.

5: Type windows server under Search box and click binocular icon.

6: Click on Objects tab, you will be able to see all the monitored objects (Display Name) with GUID.

You can also copy the details and past in Excel.

Hope this helps.

Submit a Comment

Your email address will not be published. Required fields are marked *