UIM-Spectrum integration: Spectrum does not show all the devices managed by UIM

Article Id: 4279

Status: Published

Updated On: 14-02-2018 08:08

Legacy Id: TEC000005140

Products:

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) , NIMSOFT PROBES

Issue/Introduction:

When CA Spectrum is integrated with CA UIM not all devices are visible into CA Spectrum.

Environment:

Any CA UIM or Spectrum Version

Resolution:

With CA Spectrum 9.4.0 release and above, CA Spectrum will only pull and model CA UIM entities of type “Host”. When integration with UIM is enabled in CA Spectrum, the table from which data is returned is the CM_COMPUTER_SYSTEM table. Each row in this table has a field called “dedicated”- which specifies the type of entity that the row represents. Only the rows with “dedicated” field as “Host” will be reported to CA Spectrum.

For verifying, the following query can be executed on the SQL server of the CA UIM

select * from CM_COMPUTER_SYSTEM where dedicated = 'host'

If the entry is not "host" then it will not be populated in CA Spectrum.