Cool Solutions

Editing the ZLM Database to Change Custom Targets



May 17, 2007 2:20 pm





ENVIRONMENT: ZENworks Linux Management 7.x

PROBLEM: In ZLM 7.x default platform targets cannot be disabled, but slow down certain operations significantly, even if completely unused.

Also after an upgrade from ZLM 7.0 to ZLM 7.2, SLES/SLED custom targets remain to be “custom defined”, even though SLES/SLED are now standard target platforms. This tip shows how to edit the ZLM database to change the above settings that are not accessible through the UI.

SOLUTION: You’ll need a Windows PC and MS Access or something similar:

  1. Get the postgressl ODBC driver from
  2. In Windows, define a DSN that points to the database “zenworks” on your ZLM server. As username specify “zenadmin”, take the password from /etc/opt/novell/zenworks/secret
  3. Connect to the DB (e.g. using MS Access) and edit columns “enabled” and/or “userdefined” in table “public.os_targets” according to your needs.
  4. Open ZCC – Configuration – Platform and verify the new settings

If you have any questions you may contact Lothar at

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.

Categories: Uncategorized


Disclaimer: This content is not supported by Micro Focus. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.