Slow Inventory Reporting

  • 3154027
  • 07-Dec-2007
  • 30-Apr-2012

Environment


Novell ZENworks 7 Desktop Management Support Pack 1 - ZDM7 SP1 Inventory
Sybase Database

Situation

When running a"Data Export" from the Inventory menu in ConsoleOne it will take an extremely long time to complete.The report for 10 machines would take over an hour to run.

Resolution

Using a database client (ie: Squirrel SQL) run these scripts against the database.
alter table zenworks.t$InstalledProduct DELETE PRIMARY KEY;
alter table zenworks.t$InstalledProduct ADD PRIMARY KEY(id$);
create index i$CompSys on zenworks.t$InstalledProduct(ComputerSystem);
commit;

Feedback service temporarily unavailable. For content questions or problems, please contact Support.