SRM reports showing incomplete assets
Article ID: 116309
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.
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)
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".
Feedback
Yes
No
Powered by
