DX Unified Infrastructure Management

Hello team,

     Where vmware probe strores de Cluster attribute of a host? I already searched on cm_computer_system, cm_computer_system_att, and the cm_configuration_item_attribute tables an didn't found

Thanks

Probably in CM_DEVICE_ATTRIBUTE.

Use the cs_id from CM_COMPUTER_SYSTEM to query CM_DEVICE, and from CM_DEVICE use the dev_id to query CM_DEVICE_ATTRIBUTE.

I tried but with no lucky.

I take a look on the vmware probe configuration on the monitor and it display the cluster configuration as :

Resources:
<Host IP >.Cluster

Key:

"ESC:HOST:<Vcenter IP>:4c4c4544-0036-3010-8030-c8c04f4d3232"."Cluster"

but looking on the cm_configuration_item table a cant find the cluster resouce

The USM queries the CM_CONFIGURATION_ITEM.ci_name to display the Cluster value

What version of UMP are you running?

my version.txt :

Version      = 8.4.2
Build Label  = UMP_842_GA
Build Date   = August 04, 2016 05:17:55 PM -0600
Build Number = 142338

Found it, I make the following query :

SELECT ca_uim.cm_configuration_item.ci_name,
     ca_uim.cm_computer_system.ip,
     ca_uim.cm_computer_system.dedicated
FROM ca_uim.cm_relationship_ci_cs
     INNER JOIN ca_uim.cm_configuration_item ON
      ca_uim.cm_relationship_ci_cs.source_id = ca_uim.cm_configuration_item.ci_id
     INNER JOIN ca_uim.cm_computer_system ON
      ca_uim.cm_relationship_ci_cs.target_id = ca_uim.cm_computer_system.cs_id
WHERE
      ca_uim.cm_configuration_item.ci_type = '1'
      AND ca_uim.cm_computer_system.dedicated = 'HostSystem'