SRM reports showing incomplete assets
search cancel

SRM reports showing incomplete assets


Article ID: 116309


Updated On:


CA Spectrum


When you run asset reports the number of devices are not correct.

For example when you run an asset report on model class router jasper shows 2214.
But in OneClick you can see 3235 and also when you execute the following query in the reporting DB:
mysql> select count(*) from model where model_class=3;
| count(*) |
| 3235 |
1 row in set (0.00 sec)

We have no security enabled.


Spectrum 10.2.2


New created patch "Spectrum_10.02.02.PTF_10.2.238" was provided.

Symptom :
The Asset Group report having data mismatch with current_all_assets report.

Duplicate model names in the customer environment causing the issue and made the changes to group models using model_key rather than model_name in the reporting query.

(DE383576, 01177490)

Additional Information

Please contact CA Support if you have the same issue on Spectrum 10.2.2 to receiveĀ "Spectrum_10.02.02.PTF_10.2.238".