SRM reports showing incomplete assets
search cancel

SRM reports showing incomplete assets

book

Article ID: 116309

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

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