Novell ZENWORKS 10 CONFIGURATION MANAGEMENT SP3 10.3, ZENworks 10 Configuration Management SP3 Reference Manual
Page 1
Novell®
www.novell.com
AUTHORIZED DOCUMENTATION
Reference
ZENworks® 10 Configuration Management SP3
Inventory Database Tables
novdocx (en) 7 January 2010
10.3
March 30, 2010
ZENworks 10 Configuration Management Services Reference
Page 2
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.
novdocx (en) 7 January 2010
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).
Page 3
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.
novdocx (en) 7 January 2010
Page 4
novdocx (en) 7 January 2010
4 ZENworks 10 Configuration Management Services Reference
Page 5
Contents
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
novdocx (en) 7 January 2010
Contents 5
Page 6
novdocx (en) 7 January 2010
6 ZENworks 10 Configuration Management Services Reference
Page 7
About This Guide
novdocx (en) 7 January 2010
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
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.
®
ZENworks database administrators.
®
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 (
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.
, TM, etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party
About This Guide 7
Page 8
novdocx (en) 7 January 2010
8 ZENworks 10 Configuration Management Services Reference
Page 9
1
Understanding ZENworks
novdocx (en) 7 January 2010
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.
1
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.
Understanding ZENworks Inventory Database Tables
9
Page 10
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, n bytes 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.
novdocx (en) 7 January 2010
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.
10 ZENworks 10 Configuration Management Services Reference
Page 11
2
Inventory Data Tables
The inventory data tables contain all the available data about a workstation, including hardware and
software data, demographic data, and FNI data.
Section 2.1, “NC_ADF Table,” on page 12
Section 2.2, “NC_BIOS Table,” on page 13
Section 2.3, “NC_Category Table,” on page 14
Section 2.4, “NC_CDROM Table,” on page 14
Section 2.5, “NC_ChoiceListItem Table,” on page 15
Section 2.6, “NC_CompChanges Table,” on page 16
Section 2.7, “NC_Component Table,” on page 17
Section 2.8, “NC_CPU Table,” on page 19
Section 2.9, “NC_DeviceRes Table,” on page 20
Section 2.10, “NC_Disk Table,” on page 20
novdocx (en) 7 January 2010
2
Section 2.11, “NC_FileScanData Table,” on page 21
Section 2.12, “NC_Floppy Table,” on page 22
Section 2.13, “NC_HotFix Table,” on page 22
Section 2.14, “NC_IPAddress Table,” on page 22
Section 2.15, “NC_Keyboard Table,” on page 23
Section 2.16, “NC_LANAdapter Table,” on page 23
Section 2.17, “NC_LDAPImportMappings Table,” on page 23
Section 2.18, “NC_LDAPImportTask Table,” on page 24
Section 2.19, “NC_LogicalDrive Table,” on page 25
Section 2.20, “NC_MemoryModule Table,” on page 25
Section 2.21, “NC_Modem Table,” on page 26
Section 2.22, “NC_Monitor Table,” on page 26
Section 2.23, “NC_Mouse Table,” on page 27
Section 2.24, “NC_NetworkDriver Table,” on page 27
Section 2.25, “NC_OperatingSystem Table,” on page 28
Section 2.26, “NC_ParallelPort Table,” on page 28
Section 2.27, “NC_Printer Table,” on page 28
Section 2.28, “NC_Product Table,” on page 29
Section 2.29, “NC_ProductCategory Table,” on page 33
Section 2.30, “NC_PRU Table,” on page 34
Section 2.31, “NC_RemovableMedia Table,” on page 34
Section 2.32, “NC_SerialPort Table,” on page 34
Section 2.33, “NC_Software Table,” on page 35
Inventory Data Tables
11
Page 12
Section 2.34, “NC_System Table,” on page 35
Section 2.35, “NC_SystemBoard Table,” on page 37
Section 2.36, “NC_User Table,” on page 37
Section 2.37, “NC_VideoAdapter Table,” on page 39
Section 2.38, “NC_VirtualMachine Table,” on page 40
Section 2.39, “NC_Workstation Table,” on page 40
Section 2.40, “NC_WkstnChanges Table,” on page 44
Section 2.41, “NC_WkstnReconcileData Table,” on page 45
2.1 NC_ADF Table
The NC_ADF Table contains reference data about administrator-defined fields.
Column Key Type Null Description
ADFOID PK numeric(19,0) identity No Internal ID number used
as a primary key.
novdocx (en) 7 January 2010
TableName nvarchar(32) No Table to which the ADF
is associated.
InternalName nvarchar(8) No Database column name,
this is the internal
representation.
Label nvarchar(32) No Displayed field label
DataType smallint Data type used when
querying. Possible data
types include:
0 Character
1 Integer
2 Decimal
3 Date
InUse tinyint No TRUE(1) = indicates the
field is already in use.
DefaultValue nvarchar(255) Default value.
IsDisplay smallint TRUE(1)= display the
field, FALSE to hide it.
IsEditable smallint TRUE(1)=field is
editable, FALSE if
ReadOnly.
ControlType smallint Edit, mask, list, combo,
EditMask nvarchar(64) Data entry editing mask.
12 ZENworks 10 Configuration Management Services Reference
check, button, etc.
Page 13
Column Key Type Null Description
AutoFill smallint Indicates when to fill in a
field with the default
value.
IsStoreMask smallint TRUE(1)=store mask
template with data.
IsRequired smallint TRUE(1)=User must fill
field in with data.
IsUnique smallint TRUE(1)=Value must be
unique.
MaxLength smallint Maximum field length
(number of characters).
DateLastModified datetime The date the record was
last modified.
novdocx (en) 7 January 2010
2.2 NC_BIOS Table
The NC_BIOS table contains inventory data about BIOS components.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number
used as a primary key.
Version nvarchar(64) The BIOS version.
ReleaseDate nvarchar(9) The ROM release date.
DMICompVersion nvarchar(6) The DMI (SM) BIOS
version.
IsAPMSupport smallint No 1 (TRUE) if it supports
the Advanced Power
Management
specification; else 0.
IsACPICompatible smallint No 1 (TRUE) if it supports
the Advanced
Configuration and
Power Interface; else 0.
FamilyCode nvarchar(32) The BIOS family.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
Inventory Data Tables 13
Page 14
2.3 NC_Category Table
The NC_Category table tracks product categories.
Column Key Type Null Description
CategoryOID PK binary(16) No An internal ID number used as a
primary key.
CategoryName nvarchar(32) No The name of the product
category.
CategoryType smallint No The product type to which the
category belongs. See "Note"
below.
IsTally smallint No 1 (TRUE) if the category was
defined by Novell; else 0.
IsDeleted DateTime The date and time the record
was deleted; else null.
novdocx (en) 7 January 2010
NOTE: The CategoryType can be one of the following:
1 BIOS 17 Printer
2 CPU 18 BUS Adapter
3 CD/DVD Drive 19 Serial Port
4 DMI 20 Sound Card
5 Diskette Drive 21 Software
6 Hard Disk 22 System
7 Keyboard 23 System Board
8 LAN Adapter 24 Video Adapter
9 Memory Module Socket 25 Removable Media Drive
10 Modem 26 Other
11 Monitor 29 Hot Fix
12 Mouse 30 USB Port
13 Network Driver 31 Docking Station
14 Operating System
15 Parallel Port
16 Partition
2.4 NC_CDROM Table
The NC_CDROM table contains inventory data about CD-ROM components.
14 ZENworks 10 Configuration Management Services Reference
Page 15
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID
number used as a
primary key.
InterfaceType smallint No The interface type:
0=Unknown,
1=IDE, 2=SCSI,
3=USB,
4=FireWire.
DriveLetter nvarchar(64) Yes A letter assigned to
the drive
DeviceType smallint Yes Drive type
(capabilities)
Device Type
novdocx (en) 7 January 2010
0 Unknown 7 CDR/DVD -R
1 CD Reader 8 CDR/DVD -RW
2 DVD ROM 9 CDR/DVD +R
3 CDR 10 CDR/DVD +RW
4 CD Read/Write 11 CDR/DVD +/-R
5 CD DVD 12 CDR/DVD +/-RW
6DVD RAM
FK references:
FK_CDROM_CompOID: ComponentOID references NC_Component.ComponentOID
2.5 NC_ChoiceListItem Table
The NC_ChoiceListItem table contains information for choice list items.
Column Key Type Null Description
ChoiceListItemOID PK binary(16) No Internal ID number
used as a primary
key.
ChoiceText nvarchar(100) The name the
administrator
assigns to the
column; for
example,
workstation color.
Inventory Data Tables 15
Page 16
Column Key Type Null Description
ADFOID FK numeric(19,0) No Refers to the adf to
which this value
belongs.
2.6 NC_CompChanges Table
The NC_CompChanges contains information about hardware and software changes.
Column Key Type Null Description
CompChangesOID PK binary(16) No Internal ID number used as
primary key.
TypeOfChange smallint No Created, field value edited,
deleted, etc. The complete list
with codes is:
0 Created
novdocx (en) 7 January 2010
1 Edited
2 Deleted
3 Moved
4 Retired
SourceOfChange smallint No Collector, Collection Server, Mgr,
etc. The complete list with codes
is:
0 Collector
1 Field Editor
2 Collection Server
3 Manager
4 Admin Server
5 Web Console
FieldId int Field ID from the data model.
FieldLabel nvarchar(50) Field name label from the data
model.
Value1 nvarchar(255) Old value that was changed.
Value2 nvarchar(255) New value.
CreateDate datetime Date that the change was
PrevWkstnOID binary(16) Workstation with which the
ComponentOID FK binary(16) No Reference to the component
16 ZENworks 10 Configuration Management Services Reference
captured by the collector.
component was associated.
changed.
Page 17
2.7 NC_Component Table
The NC_Component table contains information about hardware and software components.
Column Key Type Null Description
ComponentOID PK binary(16) No An internal ID number used as a
primary key.
WorkstationOID FK binary(16) No The workstation with which the
component is associated.
ProductOID FK binary(16) No The product as identified by the
Collector.
ProductAlias FK binary(16) No The product as edited by the user.
ProductType smallint No The product type. See "Notes" in
"NC_Product Table."
Collector smallint The list is:
novdocx (en) 7 January 2010
0 Win32
1 OS/2
2 DOS
3 UNIX
4 Palm OS
5 OS X
Source smallint The source of the component:
0 Novell Defined
1 Collector
2 Field Editor
3 ZENworks Control Center
4 Translator/Migrator
5 Palm Translator
6 UNIX Translator
7 OS X Translator
SerialNumber nvarchar(38) The serial number as discovered
by the Collector.
AssetTag nvarchar(38) The asset tag as discovered by the
Collector.
SerialNumberAlias nvarchar(38) The serial number as provided by
the user.
AssetTagAlias nvarchar(38) The asset tag as provided by the
ModelNumber nvarchar(32) The model number.
CreateDate DateTime No The date the component was first
DateLastModified DateTime No The date the component was last
user.
discovered.
changed.
Inventory Data Tables 17
Page 18
Column Key Type Null Description
IsDeleted DateTime The date and time the record was
deleted; else null.
ExcludedNonColl Tinyint Yes 0
ADF0 nvarchar(256) Description of "Administrator
Defined Field 0"
ADF1 nvarchar(256) Description of "Administrator
Defined Field 1"
ADF2 nvarchar(64) Description of "Administrator
Defined Field 2"
ADF3 nvarchar(64) Description of "Administrator
Defined Field 3"
ADF4 nvarchar(64) Description of "Administrator
Defined Field 4"
ADF5 nvarchar(64) Description of "Administrator
Defined Field 5"
novdocx (en) 7 January 2010
ADF6 nvarchar(64) Description of "Administrator
Defined Field 6"
ADF7 nvarchar(64) Description of "Administrator
Defined Field 7"
ADF8 nvarchar(64) Description of "Administrator
Defined Field 8"
ADF9 nvarchar(64) Description of "Administrator
Defined Field 9"
ADF10 nvarchar(64) Description of "Administrator
Defined Field 10"
ADF11 nvarchar(64) Description of "Administrator
Defined Field 11"
ADF12 nvarchar(64) Description of "Administrator
Defined Field 12"
ADF13 nvarchar(64) Description of "Administrator
Defined Field 13"
ADF14 nvarchar(64) Description of "Administrator
Defined Field 14"
ADF15 nvarchar(64) Description of "Administrator
Defined Field 15"
ADF16 nvarchar(64) Description of "Administrator
ADF17 nvarchar(64) Description of "Administrator
ADF18 nvarchar(64) Description of "Administrator
18 ZENworks 10 Configuration Management Services Reference
Defined Field 16"
Defined Field 17"
Defined Field 18"
Page 19
Column Key Type Null Description
ADF19 nvarchar(64) Description of "Administrator
Defined Field 19"
IsRetired DateTime The date and time the record was
retired; else null.
Notes
1. ProductType: See note 1 within NC_Product Table
FK references:
1. FK_Comp_WkstnOID: WorkstationOID references NC_Workstation.WorkstationOID
2. FK_Comp_ProductOID: ProductOID references NC_Product.ProductOID
3. FK_Comp_ProductAlias: ProductAlias references NC_Product.ProductOID
Indexes:
1. IDX_Comp_WkstnOID: WorkstationOID (nonclustered)
2. IDX_Comp_ProdOID: ProductOID
novdocx (en) 7 January 2010
3. IDX_Comp_ProdAlias: ProductAlias
2.8 NC_CPU Table
The NC_CPU table contains CPU inventory data.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number
used as a primary key.
Speed Float The CPU speed in MHz.
VendorIdentifier nvarchar(12) The manufacturer of the
CPU.
CPUIDType smallint The CPU type.
CPUIDFamily smallint The CPU family.
CPUIDModel smallint The CPU model.
CPUIDStepping smallint The CPU stepping result.
IsMMX smallint No 1 (TRUE) if the MMX flag
features flags; else 0.
L1CacheSize smallint The size of the L1 cache.
Is64Bit tinyint 1 if a 64-bit processor, else
CoreCount tinyint Number of cores in the
0
CPU count, initially 1
Inventory Data Tables 19
Page 20
Column Key Type Null Description
IsHyperThreaded tinyint 1 if the processor is
hyperthreaded, else 0
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.9 NC_DeviceRes Table
The NC_DeviceRes table includes information about a device’s I/O map, IRQ, DMA, or memory.
Column Key Type Null Description
DeviceResOID PK binary(16) No An internal ID number used as a
primary key.
Description nvarchar(64) The name of the device.
novdocx (en) 7 January 2010
IOMap nvarchar(64) The I/O map.
IRQs nvarchar(64) The IRQ.
DMAs nvarchar(64) The DMA data.
Memory nvarchar(64) Data about memory.
WorkstationOID FK binary(16) No The workstation ID.
NOTE: The WorkstationOID foreign key references the WorkstationOID primary key column of
the NC_Workstation table.
2.10 NC_Disk Table
The NC_Disk table contains data about disk components.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as a
primary key.
DriveNumber smallint Represents the order of disks in
the device.
IsSmartWarning smallint No 1 (TRUE) if SMART warning is
LogicalDrives nvarchar(32) A list of logical drives on this disk.
RawTotalSpace Float The total disk capacity.
InterfaceType smallint No The interface type: 0=Unknown,
20 ZENworks 10 Configuration Management Services Reference
supported; else 0.
1=IDE, 2=SCSI, 3=USB,
4=FireWire.
Page 21
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.11 NC_FileScanData Table
The NC_FileScanData table contains information about files not associated with recognized
products.
Column Key Type Null Description
FileScanDataOID PK binary(16) No An internal ID number used as a
primary key.
FileDate datetime The date the file was first
discovered.
FileSize numeric(19,2) The size of the file.
FileName nvarchar(64) The file name.
novdocx (en) 7 January 2010
SubDirectory nvarchar(255) The folder in which the file
resides.
Extension nvarchar(32) The three-character file
extension.
FileScanCategory smallint 0=None, 1=System, 2=Ancillary,
3=Other
VICompanyName nvarchar(64) Version resource block company
name.
VIProductName nvarchar(80) Version resource block product
name.
VIProductVersion nvarchar(32) Version resource block product
version.
VILanguage nvarchar(16) Version resource block language.
VIFileVersion nvarchar(32) Version resource block file
version.
StartupCount int The number of times the
application file has been
launched.
TotalRuntimeSeconds int The total number of seconds the
file has been open.
TotalActiveSeconds int The total number of seconds the
WorkstationOID FK binary(16) The ID that connects to the
file was active.
workstation where this file was
discovered.
Inventory Data Tables 21
Page 22
2.12 NC_Floppy Table
The NC_Floppy table includes data about floppy drives.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as a
primary key.
Capacity Float The storage capacity of the drive.
DriveLetter nvarchar(64) The drive letter.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.13 NC_HotFix Table
The NC_HotFix table contains inventory data about hot fixes (patches).
novdocx (en) 7 January 2010
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used
as a primary key.
RegistryKey nvarchar(256) The registry key used to
identify the hot fix.
Description nvarchar(128) The description of the hot fix.
DateInstalled nvarchar(20) The date the hot fix was
installed.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.14 NC_IPAddress Table
The NC_IPAddress table contains information about IP addresses associated with LAN adaptors.
Column Key Type Null Description
IPAddressOID PK binary(16) No Internal ID number used as a
primary key.
IPAddress nvarchar(40) IP address associated with a
SubnetMask nvarchar(40 IP Subnet Mask associated with
LANAdapterOID FK binary(16) No LAN Adapter this IP entry is
22 ZENworks 10 Configuration Management Services Reference
particular LAN card.
a particular LAN card.
associated to.
Page 23
2.15 NC_Keyboard Table
The NC_Keyboard table contains inventory data about keyboards.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as a
primary key.
InterfaceType smallint The interface type: 0=Unknown,
1=PS/2, 2=USB.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.16 NC_LANAdapter Table
The NC_LANAdapter table contains inventory data about LAN adapters.
novdocx (en) 7 January 2010
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as
a primary key.
LANAddress nvarchar(12) The 48-bit Ethernet address
associated with this card.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.17 NC_LDAPImportMappings Table
The LDAPImportMappings table contains LDAP mapping information.
Column Key Type Null Description
ZUID PK, FK binary(16) No An internal ID number
used as a primary key.
LDAPImportTaskUID FK binary(16) ID providing linkage to
the task table record that
uses this mapping.
invClassType nvarchar(8) The class type.
invFieldType nvarchar(256) The field type.
isMatch tinyint 1 if the record is
LDAPProperty nvarchar(255) The LDAP properties
matched, else 0.
associated with this
mapping.
Inventory Data Tables 23
Page 24
2.18 NC_LDAPImportTask Table
The NC_LDAPImportTask table contains information about LDAP import tasks..
Column Key Type Null Description
ZUID PK, FK binary(16) No An internal ID number
used as a primary key.
LdapServer nvarchar(128) The name of the LDAP
server.
LdapPort nvarchar(8) The port used to
connect to the LDAP
server.
LdapBaseDn nvarchar(256) The base DN used when
searching the LDAP
server.
UseSSL tinyint 1 if an SSL connection is
to be used when
connecting to the LDAP
server, else 0.
novdocx (en) 7 January 2010
LdapSearchFilter nvarchar(255) The search filter that is
used when searching
the LDAP server.
PersistCredentials tinyint 1 if credentials are
saved for future task
execution, else 0.
HasCredentials tinyint 1 if credentials are
available for this task,
else 0.
CredentialServerUID FK binary(16) ID used to identify the
credential server.
LastCredentialUpdate datetime Date when credentials
were last updated.
RunningStatus nvarchar(32) The current status of the
running LDAP import
task.
LdapSourceName nvarchar(128) The LDAP source name
for this import task.
LastStartTime datetime The last time the import
task was started.
LastFinishTime datetime The completion time for
the last time this task
ran.
LdapContexts ntext The LDAP context for
24 ZENworks 10 Configuration Management Services Reference
this task.
Page 25
Column Key Type Null Description
LdapServerCert ntext The certificate used to
connect to the LDAP
server.
Packet ntext The credentials of the
LDAP directory.
2.19 NC_LogicalDrive Table
The NC_LogicalDrive table contains inventory data about logical drives.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as a
primary key.
DriveNumber smallint The number of the drive.
DriveLetter nvarchar(64) The drive letter (without a
colon).
novdocx (en) 7 January 2010
AvailableSpace Float The free space on this drive.
TotalSpace Float The total space on this drive.
LogicalNumber smallint The sequential number of this
drive on the disk.
IsRemote smallint No 1 (TRUE) if the drive is
networked; else 0.
FileSystem smallint The file system: 0=Unknown,
1=FAT, 2=FAT 32, 3=NTFS,
4=HPFS, 5=NetWare, 6=Xenix,
7=Linux, 8=UNIX, 9=AIX,
10=Mac, 11=Hidden.
VolumeLabel nvarchar(64) The volume name of the drive.
VolumeSerialNumber nvarchar(32) The serial number of the drive.
UNCPath nvarchar(100) The UNC path of the drive.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.20 NC_MemoryModule Table
The NC_MemoryModule table contains inventory data about memory.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as
a primary key.
Inventory Data Tables 25
Page 26
Column Key Type Null Description
MemoryType smallint No The type of memory: 0=Other,
1=Unknown, 2=Standard,
3=Fast page mode, 4=EDO,
5=Burst EDO, 6=SDRAM,
7=CDRAM, 8=3DRAM,
9=SGRAM, 10=RDRAM,
11=DDR, 12=DDR2, 13=DDR2
FB DIMM.
ModuleSize smallint The size of the module in MB.
Speed smallint Access time in nanoseconds.
SocketDesignator nvarchar(24) The socket designator for the
module.
FormFactor smallint No The physical configuration:
0=unknown, 1=SIMM, 2=DIMM.
Parity smallint No 1 (TRUE) if the parity bit is
present; else 0.
novdocx (en) 7 January 2010
ECC smallint No 1 (TRUE) if error checking and
correction is present; else 0.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.21 NC_Modem Table
The NC_Modem table contains inventory data about modems.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as a
primary key.
Speed int The maximum speed of the
modem in bps.
ComPort nvarchar(4) The communications port to
which the modem is attached.
ModemType smallint No The modem type: 0=Unknown,
1=External, 2=Internal, 3=PC
Card.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.22 NC_Monitor Table
The NC_Monitor table contains inventory data about monitors.
26 ZENworks 10 Configuration Management Services Reference
Page 27
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as
a primary key.
EISAManufacturer nvarchar(64) The manufacturer’s name.
VESAProduct nvarchar(64) The product name.
YearManufactured smallint The year of manufacture.
WeekManufactured smallint The week (1-52) of
manufacture.
DiagonalSize Float The calculated diagonal size.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
novdocx (en) 7 January 2010
2.23 NC_Mouse Table
The NC_Mouse table contains inventory data about mice.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as a
primary key.
InterfaceType smallint The interface type: 0=Unknown,
1=PS/2, 2=InPort, 3=Bus,
4=USB, 5=USB.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.24 NC_NetworkDriver Table
The NC_NetworkDriver table contains inventory data about network drivers.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as a
primary key.
FileVersion nvarchar(32) The file version.
Filename nvarchar(16) The file name.
Description nvarchar(80) The driver description.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
Inventory Data Tables 27
Page 28
2.25 NC_OperatingSystem Table
The NC_OperatingSystem table contains inventory data about operating systems.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as a
primary key.
OSInternalVersion nvarchar(8) Internal version string for the
operating system.
ServicePack nvarchar(8) The service pack string.
BootDriveLetter nvarchar(1) The drive from which the
operating system started (without
a colon).
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
novdocx (en) 7 January 2010
2.26 NC_ParallelPort Table
The NC_ParallelPort table contains inventory data about parallel ports.
Column Key Type Null Description
ComponentOID PK, FK binary No An internal ID number used as a
primary key.
LogicalName nvarchar(64) The name of the port, for
example, LPT1.
IsEPP smallint No 1 (TRUE) if EPP is supported;
else 0.
IsECP smallint No 1 (TRUE) if ECP is supported;
else 0.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.27 NC_Printer Table
The NC_Printer table contains inventory data about printers.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as
IsRemote smallint No 1 (TRUE) if it’s a network
28 ZENworks 10 Configuration Management Services Reference
a primary key.
printer; else 0.
Page 29
Column Key Type Null Description
UNCPath nvarchar(255) The UNC path of the printer.
Port nvarchar(6) The port to which the printer is
assigned, for example, LPT1.
DriverName nvarchar(64) The printer driver name.
WindowsName nvarchar(64) The Windows name of the
printer.
IPAddress nvarchar(40) The IP address for the printer, if
it is available.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.28 NC_Product Table
novdocx (en) 7 January 2010
The NC_Product table contains product information.
Column Key Type Null Description
ProductOID PK binary(16) No An internal ID number used as
a primary key.
Code int The product’s unique ID where
0 as the leading digit
represents hardware and 1
represents software.
ProductType smallint No The product type. See
"Notes"below.
ProductCategoryOID FK binary(16) Product classification
information.
Manufacturer nvarchar(35) The manufacturer’s name.
Product nvarchar(100) The product name.
Model nvarchar(25) The model of the product.
Source smallint No How the product was created:
0=Novell Defined
1= Collection
2=Field Editor
3 = ZENworks Control Center
4=Translator/Migrator
5=Palm Translator
6=UNIX Translator
7=OS X Translator.
Inventory Data Tables 29
Page 30
Column Key Type Null Description
SWPlatform smallint The platform under which a
software product runs. See
"Notes" below.
NotInUse smallint No 1 (TRUE) if the product is a
local product that has been
reconciled into another
product; else 0.
Classification smallint No The classification of a product:
0=hardware, 1=software.
Platform smallint No The platform. See "Notes"
below.
Language smallint No The language. See "Notes"
below.
IsCodeValid smallint No 1 (TRUE) if the code is valid;
else 0.
novdocx (en) 7 January 2010
IsMerged smallint No 1 (TRUE) if the local product
has been merged into the
product KB files; else 0.
DistributionModel smallint How the product is sold:
0 = Unknown
1 = Commercial
2 = Freeware
3 = Shareware
4 = Open Source
5 = Multiple
6 = Public Domain
LicenseProductType smallint The type of license that is
associated with the software:
0 = Unknown
1 = Full
2 = Eval
3 = OEM
4 = Multiple
5 = Network
CurrentManufacturer nvarchar(35)
CreateDate DateTime The time and date the product
DateLastModified DateTime The time and date the product
IsDeleted DateTime The date and time the record
30 ZENworks 10 Configuration Management Services Reference
was created.
was last modified by a
ZENworks Asset Management
User.
was deleted;else null.
Page 31
Column Key Type Null Description
ADF0 nvarchar(256) Description of "Administrator
Defined Field 0"
ADF1 nvarchar(256) Description of "Administrator
Defined Field 1"
ADF2 nvarchar(64) Description of "Administrator
Defined Field 2"
ADF3 nvarchar(64) Description of "Administrator
Defined Field 3"
ADF4 nvarchar(64) Description of "Administrator
Defined Field 4"
ADF5 nvarchar(64) Description of "Administrator
Defined Field 5"
ADF6 nvarchar(64) Description of "Administrator
Defined Field 6"
novdocx (en) 7 January 2010
ADF7 nvarchar(64) Description of "Administrator
Defined Field 7"
ADF8 nvarchar(64) Description of "Administrator
Defined Field 8"
ADF9 nvarchar(64) Description of "Administrator
Defined Field 9"
ADF10 nvarchar(64) Description of "Administrator
Defined Field 10"
ADF11 nvarchar(64) Description of "Administrator
Defined Field 11"
ADF12 nvarchar(64) Description of "Administrator
Defined Field 12"
ADF13 nvarchar(64) Description of "Administrator
Defined Field 13"
ADF14 nvarchar(64) Description of "Administrator
Defined Field 14"
ADF15 nvarchar(64) Description of "Administrator
Defined Field 15"
ADF16 nvarchar(64) Description of "Administrator
Defined Field 16"
ADF17 nvarchar(64) Description of "Administrator
ADF18 nvarchar(64) Description of "Administrator
ADF19 nvarchar(64) Description of "Administrator
Defined Field 17"
Defined Field 18"
Defined Field 19"
Inventory Data Tables 31
Page 32
Notes
The ProductType can be one of the following:
1 BIOS 16 Partition
2 CPU 17 Printer
3 CD-ROM 18 Bus Adapter
4 DMI 19 Serial Port
5 Floppy 20 Sound Card
6 Hard Disk 21 Software
7 Keyboard 22 System
8 LAN Adapter 23 System Board
9 Memory Module 24 Video Adapter
10 Modem 25 Removable Media
novdocx (en) 7 January 2010
11 Monitor 26 Other
12 Mouse 29 Hot Fix
13 Network Driver 30 USB Port
14 Current Operating System 31 Docking Station
15 Parallel port
SWPlatform and Platform can have one of the following values:
0DOS
1 Windows 3.x
2 Windows 95
3 Windows 98
4 Windows 32-bit
5 Windows NT
6 Windows 9x
7OS/2
8 Unassigned
9Palm OS
10 Windows 2000
11 Windows XP
12 UNIX
13 OS X
32 ZENworks 10 Configuration Management Services Reference
Page 33
14 Windows Vista
Language can have one of the following values:
1 Afrikaans 15 Hungarian
2 Arabic 16 International
3 Chinese 17 Italian
4 Simple Chinese 18 Japanese
5 Traditional Chinese 19 Korean
6 Danish 20 Norwegian
7 Dutch 21 Polish
8 English (U.K.) 22 Portuguese
9 English (U.S.) 23 Brazilian Portuguese
10 Finnish 24 Russian
novdocx (en) 7 January 2010
11 French 25 Spanish
12 German 26 Swedish
13 Greek 27 Turkish
14 Hebrew
The ProductCategoryOID foreign key references the ProductCategoryOID primary key column
of the NC_ProductCategory table.
ProductType + Manufacturer + Product + Model + Source + Language + IsDeleted has a
unique constraint named UQ_Product_Names.
2.29 NC_ProductCategory Table
The NC_ProductCategory table contains information about product subcategories.
Column Key Type Null Description
ProductCategoryOID PK binary(16) No An internal ID number used
as a primary key.
ProductCategoryName nvarchar(32) No The name of the product
subcategory.
CategoryOID FK binary(16) No Product category
IsTally smallint No 1 if this is a product
IsDeleted DateTime The date and time the
information.
category defined by Novell;
0 if it is user-defined.
record was deleted; else
null.
Inventory Data Tables 33
Page 34
NOTE: The CategoryOID foreign key references the CategoryOID primary key column of the
NC_Category table.
2.30 NC_PRU Table
The NC_PRU table contains information about product recognition updates.
Column Key Type Null Description
PRUOID PK binary(16) No Internal ID number used as
the primary key.
KBVersion nvarchar(48) Version number of the KB
files created.
PRUVersion nvarchar(48) Version number of the PRU
updated.
PRUNumber smallint Number of the last PRU.
novdocx (en) 7 January 2010
PRULabel nvarchar(16) Label of the last PRU.
PRUDate datetime Date of last PRU.
PRU image PRU stored directly in the
database as a Blob.
LMPRUVersion nvarchar(48) Version number of the
License Management
PRU.
2.31 NC_RemovableMedia Table
The NC_RemovableMedia table contains inventory data about removable media drives.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID
number used as a
primary key.
InterfaceType smallint The inteface type:
0=Unknown,
1=IDE, 2=SCSI,
3=USB,
4=FireWire.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.32 NC_SerialPort Table
The NC_SerialPort table contains inventory data about serial ports.
34 ZENworks 10 Configuration Management Services Reference
Page 35
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as
a primary key.
LogicalName nvarchar(4) The name of the port, for
example, COM1.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.33 NC_Software Table
The NC_Software table contains inventory data about software.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used
as a primary key.
novdocx (en) 7 January 2010
Path nvarchar(255) The path to the folder where
the software resides.
AdditionalInfo nvarchar(200) Additional information about
the software, for example,
the date of a virus definition.
ParentSuiteOID binary(16) Yes Link from a suite component
to the parent suite product.
Notes
FK references:
1. FK_SW_CompOID: ComponentOID references NC_Component.ComponentOID
2. FK_SW_ParentSuiteOID: ParentSuiteOID references NC_Software.ComponentOID
Indexes:
IDX_SW_ParentSuiteOID: ParentSuiteOID
2.34 NC_System Table
The NC_System table contains inventory data about systems.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as
ChassisType smallint The type of chassis. See
a primary key.
"Notes" below.
Inventory Data Tables 35
Page 36
Column Key Type Null Description
ThermalState smallint The thermal state. See "Notes"
below.
CoverRemoved DateTime The CPU cover has been
removed.
Fingerprint Varbinary(255) The fingerprint used to identify
the system.
Notes
The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
The ChassisType can have one of the following values:
0 Out of Range 13 All in One
1 Other 14 Sub Notebook
novdocx (en) 7 January 2010
2 Unknown 15 Space-saving
3 Desktop 16 Lunch Box
4 Low Profile Desktop 17 Main Server Chassis
5 Pizza Box 18 Expansion Chassis
6 Mini Tower 19 SubChassis
7 Tower 20 Bus Expansion Chassis
8 Portable 21 Peripheral Chassis
9 Laptop 22 RAID chassis
10 Notebook 23 Rack Mount Chassis
11 Hand Held 24 Sealed-case PC
12 Docking Station
ThermalState can have one of the following values:
0 Out of range
1 Other
2 Unknown
3Safe
4 Warning
5Critical
6 Non-recoverable
36 ZENworks 10 Configuration Management Services Reference
Page 37
2.35 NC_SystemBoard Table
The NC_SystemBoard table contains inventory data about system boards.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID number used as a
primary key.
Revision nvarchar(32) The motherboard version.
Bus1type smallint The first bus type: 0=unknown,
1=ISA, 2=PCI, 3=MCA, 4=EISA,
5=PCMCIA, 6=VL.
Bus1slots smallint The number of slots for the first
bus.
Bus2type smallint The second bus type:
0=unknown, 1=ISA, 2=PCI,
3=MCA, 4=EISA, 5=PCMCIA,
6=VL.
novdocx (en) 7 January 2010
Bus2slots smallint The number of slots for the
second bus.
L2CacheSize smallint The size of the L2 cache.
L2CacheSpeed smallint The access time of the L2 cache
in nanoseconds.
L2CacheWritePolicy smallint The write policy of the L2 cache:
0=unknown, 1=write back,
2=write through, 3=write variable.
SystemBoardId nvarchar(64) The identification of the system
board.
MotherboardUID binary(16) The identification of the mother
board.
NOTE: The ComponentOID foreign key references the ComponentOID primary key column of the
NC_Component table.
2.36 NC_User Table
The NC_User table contains information about entered users.
Column Key Type Null Description
UserOID PK binary(16) No An internal ID number used as a
FirstName nvarchar(32) The user’s first name.
MiddleName nvarchar(32) The user’s middle name.
LastName nvarchar(32) The user’s last name.
primary key.
Inventory Data Tables 37
Page 38
Column Key Type Null Description
Phone nvarchar(32) The user’s telephone number.
Email nvarchar(100) The user’s e-mail address.
Phone2 nvarchar(32) The user’s second telephone
number.
Fax nvarchar(32) The user’s fax number.
IsDeleted DateTime The date and time the record was
deleted; else null.
ADF0 nvarchar(256) Description of "Administrator
Defined Field 0"
ADF1 nvarchar(256) Description of "Administrator
Defined Field 1"
ADF2 nvarchar(64) Description of "Administrator
Defined Field 2"
novdocx (en) 7 January 2010
ADF3 nvarchar(64) Description of "Administrator
Defined Field 3"
ADF4 nvarchar(64) Description of "Administrator
Defined Field 4"
ADF5 nvarchar(64) Description of "Administrator
Defined Field 5"
ADF6 nvarchar(64) Description of "Administrator
Defined Field 6"
ADF7 nvarchar(64) Description of "Administrator
Defined Field 7"
ADF8 nvarchar(64) Description of "Administrator
Defined Field 8"
ADF9 nvarchar(64) Description of "Administrator
Defined Field 9"
ADF10 nvarchar(64) Description of "Administrator
Defined Field 10"
ADF11 nvarchar(64) Description of "Administrator
Defined Field 11"
ADF12 nvarchar(64) Description of "Administrator
Defined Field 12"
ADF13 nvarchar(64) Description of "Administrator
ADF14 nvarchar(64) Description of "Administrator
ADF15 nvarchar(64) Description of "Administrator
38 ZENworks 10 Configuration Management Services Reference
Defined Field 13"
Defined Field 14"
Defined Field 15"
Page 39
Column Key Type Null Description
ADF16 nvarchar(64) Description of "Administrator
Defined Field 16"
ADF17 nvarchar(64) Description of "Administrator
Defined Field 17"
ADF18 nvarchar(64) Description of "Administrator
Defined Field 18"
ADF19 nvarchar(64) Description of "Administrator
Defined Field 19"
2.37 NC_VideoAdapter Table
The NC_VideoAdapter table contains inventory data about video adapters.
Column Key Type Null Description
ComponentOID PK, FK binary(16) No An internal ID
number used as a
primary key.
novdocx (en) 7 January 2010
MinRefreshRate smallint The minimum
refresh rate.
MaxRefreshRate smallint The maximum
refresh rate.
MemoryType smallint The memory type.
MemorySize int The memory size.
MinVertResolution smallint The minimum
vertical resolution.
MinHorizResolution smallint The minimum
horizontal
resolution.
MaxVertResolution smallint The maximum
vertical resolution.
MaxHorizResolutio
n
NumberBitsPerPix
el
PixelShaderMajorV
ersion
smallint The maximum
horizontal
resolution.
smallint The number of bits
per pixel.
smallint Major version for
the pixel shader.
PixelShaderMinorV
ersion
smallint Minor version for
the pixel shader.
Inventory Data Tables 39
Page 40
NOTE: FK references:
1. FK_VideoAdapt_CompOID: ComponentOID references NC_Component.ComponentOID
2.38 NC_VirtualMachine Table
Contains information about a virtual machines.
Column Name Key Datatype Null Description
VirtualMachineOID PK,FK binary(16) N internal ID number used as
primary key.
HostWorkstationOID binary(16) N identifies the workstation that
hosts this VM.
VMDisplayName nvarchar(100) The virtual machine display
name.
novdocx (en) 7 January 2010
VMGuestOS nvarchar(100) The virtual machine operating
system.
VMType tinyint N The virtual machine type.
VMEthernetAddress nvarchar(12) The virtual machine Ethernet
address.
VMUUID nvarchar(36) The virtual machine UID.
Notes:
VMType: 0=None, 1 = Unknown, 2 = VMware, 3 = VirtualPC
FK references:
FK_VirtualMachine_WkstnOID: HostWorkstationOID references
NC_Workstation.WorkstationOID
Indexes:
IDX_VirtualMachine_WkstnOID: HostWorkstationOID
Check constraints:
CK_VirtualMachine_VMType: VMType between 1 and 3 (inclusive)
2.39 NC_Workstation Table
The NC_Workstation table tracks workstation inventory data.
Column Key Type Null Description
WorkstationOID PK binary(16) No An internal ID number used as a
40 ZENworks 10 Configuration Management Services Reference
primary key.
Page 41
Column Key Type Null Description
ZenWorksAgentId binary (16) The identification for the
ZENworks Adaptive Agent
installed on this workstation.
UnManagedAgentId binary (16) The identification for an
unmanaged agent.
MachineName nvarchar(32) The machine name. See "Notes"
below.
InventoryType smallint No The type of inventory:
0=Workstation, 1=Server,
2=Stockroom, 3=Lost and Found,
4= Portable, 5=NetCensus,
6=Manually-entered Workstation,
7=Workstation Not Yet Scanned,
8=UNIX, 9=PDA.
LoginName nvarchar(32) The user’s logon name. See
"Notes" below.
novdocx (en) 7 January 2010
Site nvarchar(32) The site of the workstation.
Dept nvarchar(32) The department to which the
workstation belongs.
CostCenter nvarchar(32) The cost center to which the
workstation belongs.
Building nvarchar(32) The building in which the
workstation resides.
Floor nvarchar(10) The floor on which the workstation
resides.
Room nvarchar(32) The number of the room.
Phone nvarchar(32) The telephone number at the
workstation.
TotalMemory int The total system memory.
TotalHardDiskSpace Float The total space on the hard disk.
FreeHardDiskSpace Float The total free space on the hard
disk.
LastScanId binary(16)
LastSuccessfulScanDate DateTime The date and time of the last
successful scan of the workstation.
LastSuccessfulLoadDate DateTime The date and time of the last
LastUsageGatherDate DateTime Reserved for internal use.
LANAddress nvarchar(12) The LAN address from the LAN
successful load of inventory from
the workstation.
adapter.
Inventory Data Tables 41
Page 42
Column Key Type Null Description
IPAddress nvarchar(15) The IP address from the LAN
adapter.
SubnetMask nvarchar(15) The subnet mask from the LAN
adapter.
DefaultGateway nvarchar(15) The default gateway from the LAN
adapter.
WkstnDomain nvarchar(64) The workstation domain.
SerialNumber nvarchar(38) The serial number of the system
component.
AssetTag nvarchar(38) The asset tag of the system
component.
IsLeased smallint No 1 (TRUE) if the machine is leased;
else 0.
LeaseExpireDate DateTime Lease expiration date.
novdocx (en) 7 January 2010
LeaseContractId VarChar(20) The contract ID of the lease.
AccountId varbinary(16) The account identification.
CreateDate DateTime No The date and time the workstation
was added.
DateLastModified DateTime No The date and time the workstation
was last modified.
IsDeleted DateTime Used to record the date when a
workstation is marked as retired.
CPUSpeed float The CPU speed.
CPUProduct DateTime The product name of the CPU.
CPUCount smallint The number of CPUs in the
workstation.
SystemManufacturer nvarchar(35) The system manufacturer.
SystemProduct nvarchar(100) The system product name.
SystemModel nvarchar(25) The system model.
SystemChassis smallint The type of system chassis. See
the chassis type listing under the
NC_System table.
OSManufacturer nvarchar(35) The operating system
OSProduct nvarchar(100) The operating system product
OSModel nvarchar(25) The operating system model
42 ZENworks 10 Configuration Management Services Reference
manufacturer.
name.
number.
Page 43
Column Key Type Null Description
OSServicePack nvarchar(8) The operating system service pack
level.
OSBuild nvarchar(8) The operating system build
number.
ScannedSerialNumber nvarchar(38) The scanned serial number for the
workstation.
CalculatedPrimaryUser nvarchar(128) The calculated primary user from
an authoritative source.
ADF0 nvarchar(256) Description of "Administrator
Defined Field 0"
ADF1 nvarchar(256) Description of "Administrator
Defined Field 1"
ADF2 nvarchar(64) Description of "Administrator
Defined Field 2"
novdocx (en) 7 January 2010
ADF3 nvarchar(64) Description of "Administrator
Defined Field 3"
ADF4 nvarchar(64) Description of "Administrator
Defined Field 4"
ADF5 nvarchar(64) Description of "Administrator
Defined Field 5"
ADF6 nvarchar(64) Description of "Administrator
Defined Field 6"
ADF7 nvarchar(64) Description of "Administrator
Defined Field 7"
ADF8 nvarchar(64) Description of "Administrator
Defined Field 8"
ADF9 nvarchar(64) Description of "Administrator
Defined Field 9"
ADF10 nvarchar(64) Description of "Administrator
Defined Field 10"
ADF11 nvarchar(64) Description of "Administrator
Defined Field 11"
ADF12 nvarchar(64) Description of "Administrator
Defined Field 12"
ADF13 nvarchar(64) Description of "Administrator
ADF14 nvarchar(64) Description of "Administrator
ADF15 nvarchar(64) Description of "Administrator
Defined Field 13"
Defined Field 14"
Defined Field 15"
Inventory Data Tables 43
Page 44
Column Key Type Null Description
ADF16 nvarchar(64) Description of "Administrator
Defined Field 16"
ADF17 nvarchar(64) Description of "Administrator
Defined Field 17"
ADF18 nvarchar(64) Description of "Administrator
Defined Field 18"
ADF19 nvarchar(64) Description of "Administrator
Defined Field 19"
PrimaryUserOID FK1,l2 binary(16) ID to link in entered user
information from NC_User.
Notes
MachineName and LoginName are obtained from the network. If more than one network is
available, the order used is Windows network, NetWare, and NetBIOS.
The PrimaryUserOID foreign key references the UserOID primary key column of the NC_User
table.
novdocx (en) 7 January 2010
2.40 NC_WkstnChanges Table
The NC_Workstation table tracks workstation changes.
Column Key Type Null Description
WkstnChangesOID PK binary(16) No Internal ID number used as a
primary key.
TypeOfChange smallinit No 0 = Created
1 = Edited
2 = Deleted
3 = Moved
4 = Retired
SourceOfChange smallinit No 0 = Collector
1 = Field editor
2 = Collection server
3 = Managed
4 = Admin server
5 = Web Console
FieldId int Field ID from the data model.
FieldLabel nvarchar(50) Field name label from the data
model.
Value1 nvarchar(255) Old value that was changed.
Value2 nvarchar(255) New value.
CreateDate datetime No Date that the change was entered
44 ZENworks 10 Configuration Management Services Reference
in the database.
Page 45
Column Key Type Null Description
WorkstationOID FK binary(16) No Reference to the workstation
changed.
2.41 NC_WkstnReconcileData Table
The NC_WkstnReconcileData table contains data reconciliation data.
Column Key Type Null Description
WkstnReconcileDataOID PK binary(16) Internal ID number used as a
primary key.
ReconcileData nvarchar(38) Data upon which reconciliation is
based.
ReconcileType smallinit The type of reconciliation that is
performed.
IsNovell smallint 1 if this is a Novell-defined
product, else 0.
novdocx (en) 7 January 2010
InstanceVer int
Inventory Data Tables 45
Page 46
novdocx (en) 7 January 2010
46 ZENworks 10 Configuration Management Services Reference
Loading...