How to browse ZENworks Configuration Management database

  • 7001842
  • 10-Mar-2009
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management Database

Situation

Troubleshooting ZCM
Browsing Sybase database

Resolution

IMPORTANT:  Do not edit the database unless specifically advised to do so by Novell.

Browse the embedded Sybase DB using dbisql at the ZCM server console:
  • Linux:  /opt/novell/zenworks/share/sybase/bin32s/dbisql
  • Windows:  C:\Program Files\Novell\ZENworks\share\ASA\win32\dbisql.exe
  1. Select the database under the database tab (use find to select the zone and leave the other boxes empty)
  2. Enter the database's username and password; if this was auto-assigned use zman dgc to find out what they are (enter the ZCM credentials when prompted)
  3. To see the various tables names use <F7> or SELECT name FROM dbo.sysobjects as a query
e.g.  Enter select * from zDevice in the SQL Statements box and press the play button to list all the devices

To browse Oracle and MS SQL databases, contact the appropriate DBA.

Additional Information

Sometimes it may be necessary to browse the ZCM database for diagnostic or troubleshooting purposes.  This document explains how.

Notes:
  • ZCM tables are prefixed with z
  • ZUID is the ZCM equivalent of a GUID (Globally Unique ID)