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