Slow Inventory Reporting

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


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


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.


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);