What are the GUIDs in Unix Computer Database Column Names indicates in Microsoft System Center Operations Manager?

Question

We are using SQL database queries to fetch the Windows Computers and Unix Computers data from the Microsoft SCOM(System Center Operations Manager).

But for the Unix Computers database table we have columns as below containing different guid as a suffix for each column name.

• NetworkName_11111111_2222_3333_4444_555555555555
• PhysicalProcessors_22222222_3333_1111_4444_555555555555
• Architecture_66666666_8888_1111_5555_444444444444
• IPAddress_<some-guid>
• LogicalProcessors_<some-guid> etc.

So, What do the GUIDs in these column names indicate?

And Are these column names unique to different instances of SCOM?

Answer 1

Hi,

The GUIDs in the Unix Computer database column names in SCOM are used to uniquely identify different instances of the same attribute across various management packs. This ensures that there are no conflicts or overlaps when different management packs define attributes with the same name. Each GUID is associated with a specific management pack, and it helps in distinguishing between attributes that might otherwise have identical names.

For example, NetworkName_11111111_2222_3333_4444_555555555555 and NetworkName_66666666_8888_1111_5555_444444444444 might represent the same attribute (NetworkName) but are defined in different management packs, hence the different GUIDs.

These column names are unique to different instances of SCOM because the GUIDs are generated based on the specific management pack and attribute definitions within each instance. This means that even if two SCOM instances have the same attribute names, the GUIDs will ensure that the column names remain unique.

Answer 2

Hi Nirali,

Are you going to get the linux/unix agent list? If so, you can use the below query:

SELECT TOP (1000) [BaseManagedEntityId] 
      ,[BaseManagedEntityInternalId] 
      ,[BaseManagedTypeId] 
      ,[FullName] 
      ,[Path] 
      ,[Name] 
      ,[DisplayName] 
      ,[TopLevelHostEntityId] 
      ,[IsDeleted] 
      ,[LastModified] 
      ,[OverrideTimestamp] 
      ,[TimeAdded] 
      ,[LastModifiedBy] 
  FROM [OperationsManager].[dbo].[BaseManagedEntity] 
where FullName like '%unix.heartbeat%'

or we can use the powershell cmdlet:

get-scxagent

Regards,

Alex Zhu