IT Analytics reports that use data from Asset Management's Software Product list do not update

Article:TECH197245  |  Created: 2012-09-25  |  Updated: 2014-05-29  |  Article URL http://www.symantec.com/docs/TECH197245
Article Type
Technical Solution


Issue



When using any IT Analytics report that uses data from Asset Management's Software Product list, the reports do not update or show any data.


Environment



Asset Management 7.1 SP2.


Cause



Defect, Etracks 2681897, 2969044 and 2997770.

The InvHist_SoftwareProduct_InstallationInfo and/or InvHist_SoftwareProduct_ComplianceInfo tables are not populating. This results in related IT Analytics reports being not updated or empty.


Solution



This issue will be resolved in a future version of Asset Management / IT Analytics.

A workaround is to run one the attached SQL scripts before processing the affected IT Analytics cubes. These must always ran before the cubes are processed, not just once. These scripts will populate the two affected history tables, enabling IT Analytics to process and then report on their data successfully.

The attached SQL scripts are internally linked to this article. Please contact Symantec Technical Support to obtain a copy of these and for assistance implementing them.




Article URL http://www.symantec.com/docs/TECH197245


Terms of use for this information are found in Legal Notices