SRM reports showing incomplete assets

Document ID : KB000116309
Last Modified Date : 28/09/2018
Show Technical Document Details
Issue:
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.
Environment:
Spectrum 10.2.2
Resolution:
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.

Resolution:
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".