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

Document ID : KB000004279
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.