Novell ZENWORKS 10 CONFIGURATION MANAGEMENT SP3 - NETWORK DISCOVERY DATABASE... User manual

Novell®
www.novell.com
novdocx (en) 7 January 2010
AUTHORIZED DOCUMENTATION
ZENworks 10 Configuration Management Services Reference
ZENworks ® 10 Configuration Management SP3
Inventory Database Tables
10.3
March 30, 2010
Reference

novdocx (en) 7 January 2010
Legal Notices
Novell, Inc., makes no representations or warranties with respect to the contents or use of this documentation, and
specifically disclaims any express or implied warranties of merchantability or fitness for any particular purpose.
Further, Novell, Inc., reserves the right to revise this publication and to make changes to its content, at any time,
without obligation to notify any person or entity of such revisions or changes.
Further, Novell, Inc., makes no representations or warranties with respect to any software, and specifically disclaims
any express or implied warranties of merchantability or fitness for any particular purpose. Further, Novell, Inc.,
reserves the right to make changes to any and all parts of Novell software, at any time, without any obligation to
notify any person or entity of such changes.
Any products or technical information provided under this Agreement may be subject to U.S. export controls and the
trade laws of other countries. You agree to comply with all export control regulations and to obtain any required
licenses or classification to export, re-export or import deliverables. You agree not to export or re-export to entities on
the current U.S. export exclusion lists or to any embargoed or terrorist countries as specified in the U.S. export laws.
You agree to not use deliverables for prohibited nuclear, missile, or chemical biological weaponry end uses. See the
Novell International Trade Services Web page (http://www.novell.com/info/exports/) for more information on
exporting Novell software. Novell assumes no responsibility for your failure to obtain any necessary export
approvals.
Copyright © 2008-2010 Novell, Inc. All rights reserved. No part of this publication may be reproduced, photocopied,
stored on a retrieval system, or transmitted without the express written consent of the publisher.
Novell, Inc.
404 Wyman Street, Suite 500
Waltham, MA 02451
U.S.A.
www.novell.com
Online Documentation: To access the latest online documentation for this and other Novell products, see
the Novell Documentation Web page (http://www.novell.com/documentation).

novdocx (en) 7 January 2010
Novell Trademarks
For Novell trademarks, see the Novell Trademark and Service Mark list (http://www.novell.com/company/legal/
trademarks/tmlist.html).
Third-Party Materials
All third-party trademarks are the property of their respective owners.

4ZENworks 10 Configuration Management Services Reference
novdocx (en) 7 January 2010

Contents 5
Contents
novdocx (en) 7 January 2010
About This Guide 7
1 Understanding ZENworks Inventory Database Tables 9
2 Inventory Data Tables 11
2.1 NC_ADF Table. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
2.2 NC_BIOS Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
2.3 NC_Category Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
2.4 NC_CDROM Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
2.5 NC_ChoiceListItem Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
2.6 NC_CompChanges Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
2.7 NC_Component Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
2.8 NC_CPU Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
2.9 NC_DeviceRes Table. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
2.10 NC_Disk Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
2.11 NC_FileScanData Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
2.12 NC_Floppy Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
2.13 NC_HotFix Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
2.14 NC_IPAddress Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
2.15 NC_Keyboard Table. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
2.16 NC_LANAdapter Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
2.17 NC_LDAPImportMappings Table. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
2.18 NC_LDAPImportTask Table. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
2.19 NC_LogicalDrive Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
2.20 NC_MemoryModule Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
2.21 NC_Modem Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
2.22 NC_Monitor Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
2.23 NC_Mouse Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
2.24 NC_NetworkDriver Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
2.25 NC_OperatingSystem Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
2.26 NC_ParallelPort Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
2.27 NC_Printer Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
2.28 NC_Product Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
2.29 NC_ProductCategory Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
2.30 NC_PRU Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
2.31 NC_RemovableMedia Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
2.32 NC_SerialPort Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
2.33 NC_Software Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
2.34 NC_System Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
2.35 NC_SystemBoard Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
2.36 NC_User Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
2.37 NC_VideoAdapter Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
2.38 NC_VirtualMachine Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
2.39 NC_Workstation Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
2.40 NC_WkstnChanges Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
2.41 NC_WkstnReconcileData Table. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45

6ZENworks 10 Configuration Management Services Reference
novdocx (en) 7 January 2010

About This Guide 7
novdocx (en) 7 January 2010
About This Guide
This Novell ZENworks 10 Configuration Management Inventory Database Tables Reference
includes information to help you create custom reports and integrate data with the ZENworks®
Configuration Management database. The information in this guide is organized as follows:
Chapter 1, “Understanding ZENworks Inventory Database Tables,” on page 9
Chapter 2, “Inventory Data Tables,” on page 11
Notice
Details about the ZENworks database schema are provided for reference purposes. The schema
generally changes in each release of the product and any integration done at the database level may
be impacted by these changes.
Audience
This guide is intended for Novell®ZENworks database administrators.
Feedback
We want to hear your comments and suggestions about this manual and the other documentation
included with this product. Please use the User Comments feature at the bottom of each page of the
online documentation, or go to the Novell Documentation Feedback site (http://www.novell.com/
documentation/feedback.html) and enter your comments there.
Additional Documentation
ZENworks 10 Configuration Management Services is supported by other documentation (in both
PDF and HTML formats) that you can use to learn about and implement the product. For additional
documentation, see the ZENworks 10 Configuration Management SP3 documentation (http://
www.novell.com/documentation/zcm10/index.html).
Documentation Conventions
In Novell documentation, a greater-than symbol (>) is used to separate actions within a step and
items in a cross-reference path.
A trademark symbol (®, TM, etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party
trademark.
When a single pathname can be written with a backslash for some platforms or a forward slash for
other platforms, the pathname is presented with a backslash. Users of platforms that require a
forward slash, such as Linux*, should use forward slashes as required by your software.

8ZENworks 10 Configuration Management Services Reference
novdocx (en) 7 January 2010

Understanding ZENworks Inventory Database Tables
1
9
novdocx (en) 7 January 2010
1
Understanding ZENworks
Inventory Database Tables
This section provides information about the ZENworks inventory database tables for advanced users
who may need information about their contents.
How to Use Database Table Definitions
This information is for advanced users who need to understand the structure of the ZENworks
inventory database. For example, some users may want to create their own custom reports with
Crystal Reports.
This section is purely informational; its contents should not be used to change the database in any
way. In particular,
Never edit data in the inventory database directly.
Never change the structure of the database tables.
Either action would compromise the integrity of the database severely.
IMPORTANT: If you edit the inventory database directly or alter the database tables in any way,
you will forfeit your right to receive any technical support from Novell related to the altered
database.
Table Description Format
The description of each database table includes the following information for the columns in the
table:
The column name.
The key (if any): PK is a primary key; FK is a foreign key.
The data type. Note that some data types have different names in Microsoft SQL Server,
Microsoft SQL Express, and Oracle.
The following data types may be found in the ZENworks Inventory database.
A float is an 8-byte floating point number.
This data type is called a float(126) in Oracle.
A tiny <INT-6> is a 1-byte integer from 0 to 28 -1, or 0 to 255.
This data type is called a tinyint in both Microsoft SQL Server and Microsoft SQL Express and
is called a number(5) in Oracle.
A short <INT2> is a 2-byte integer from -32,768 to 32,767.
This data type is called a smallint in both Microsoft SQL Server and Microsoft SQL Express
and is called a number(10,0) in Oracle.
A long <INT4> is a 4-byte integer from -2,147,483,648 to 2,147,483,647.

10 ZENworks 10 Configuration Management Services Reference
novdocx (en) 7 January 2010
This data type is called an int in both Microsoft SQL Server and Microsoft SQL Express and is
called a number(30,0) in Oracle.
A binary(n) is an array of bytes, nbytes in length.
This data type is called a raw in Oracle.
A varbinary(n) is a variable length array of bytes, with a maximum length of n.
A GUID is equivalent to Uniqueidentifier in Microsoft SQL Server 7.0, 2000, and Microsoft
SQL Express. In Oracle, it is a raw(18).
A char(n) is a character string of length n.
A nvarchar(n) is a variable length character string, with a maximum length of n.
This data type is called a varchar2 in Oracle.
Text is character data greater than 255 characters, stored in linked lists of 2 KB data pages.
Numeric(p,s) is numeric data with fixed precision (p) and scale (s). The storage is based on the
precision.
This data type is called a number in Oracle.
A DateTime is the date and time.
This data type is called a date in Oracle.
The status of nulls. A "No" in the Null column indicates that a null is not allowed; the absence
of a "No" means a null is allowed.
A description of the column.