Compliance report can take hours to complete

  • 7004831
  • 09-Nov-2009
  • 27-Apr-2012

Environment

Novell ZENworks 7.5 Asset Management - ZAM7.5

Situation

When running a compliance report from the WebConsole, it can sometimes take hours for the report to complete.

Resolution

Fixed in ZENworks Asset Management 7.5 Interim Release 20 or newer
Interim Releases can be scheduled to run automatically or can be downloaded manually at https://download.novell.com. The Interim releases can be set up within the ZAM Manager for the Task server to check the site on a scheduled basis, and download and apply them automatically. Please refer to the Help Section details of how to set up automatic downloads if desired.

Each interim release is cumulative. If Interim Release 20 is not available due to a newer interim release being placed on the website, be assured that the code needed is in the later release.

Additional Information

If the compliance reports are still slow after this fix, it may be due to a large amount of usage data in the database.

There presently is no way to just delete the usage history without deleting the workstation history itself. This has been submitted as an enahancement to the product. In the meantime, check the number of records by using the SQL Enterprise Manager and doing a sql query:

Select COUNT (*) from NC_SoftwareUsageHistory.

Those records can be deleted using the following sql query also:

delete from nc_softwareusagehistory

To add in a timeframe to keep a certain amount of usage history, use this query by modifying the date needed:

 
delete from nc_softwareusagehistory where usagedate < '2003-07-28 00:00:00.000'