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


Article ID: 4279


Updated On:


DX Infrastructure Management NIMSOFT PROBES


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


Any CA UIM or Spectrum Version


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.