Detailed instructions for use are in the User's Guide.
[. . . ] novdocx (en) 7 January 2010
AUTHORIZED DOCUMENTATION
Reference
ZENworks® 10 Configuration Management SP3 Inventory Database Tables
10. 3
March 30, 2010
Novell®
www. novell. com
ZENworks 10 Configuration Management Services 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. [. . . ] FK_Comp_ProductAlias: ProductAlias references NC_Product. ProductOID Indexes: 1. IDX_Comp_ProdAlias: ProductAlias
2. 8 NC_CPU Table
The NC_CPU table contains CPU inventory data.
Column Key Type Null Description
ComponentOID Speed VendorIdentifier CPUIDType CPUIDFamily CPUIDModel CPUIDStepping IsMMX L1CacheSize Is64Bit CoreCount
PK, FK
binary(16) Float nvarchar(12) smallint smallint smallint smallint smallint smallint tinyint tinyint
No
An internal ID number used as a primary key. The CPU stepping result.
No
1 (TRUE) if the MMX flag features flags; else 0. 1 if a 64-bit processor, else 0 Number of cores in the CPU count, initially 1
Inventory Data Tables
19
novdocx (en) 7 January 2010
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 Description IOMap IRQs DMAs Memory WorkstationOID
PK
binary(16) nvarchar(64) nvarchar(64) nvarchar(64) nvarchar(64) nvarchar(64)
No
An internal ID number used as a primary key. Data about memory.
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 DriveNumber IsSmartWarning LogicalDrives RawTotalSpace InterfaceType
PK, FK
binary(16) smallint smallint nvarchar(32) Float smallint
No
An internal ID number used as a primary key. Represents the order of disks in the device.
No
1 (TRUE) if SMART warning is supported; else 0. The total disk capacity.
No
The interface type: 0=Unknown, 1=IDE, 2=SCSI, 3=USB, 4=FireWire.
20
ZENworks 10 Configuration Management Services Reference
novdocx (en) 7 January 2010
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 FileDate FileSize FileName SubDirectory Extension FileScanCategory VICompanyName VIProductName VIProductVersion VILanguage VIFileVersion StartupCount
PK
binary(16) datetime numeric(19, 2) nvarchar(64) nvarchar(255) nvarchar(32) smallint nvarchar(64) nvarchar(80) nvarchar(32) nvarchar(16) nvarchar(32) int
No
An internal ID number used as a primary key. 0=None, 1=System, 2=Ancillary, 3=Other Version resource block company name. The ID that connects to the workstation where this file was discovered.
TotalRuntimeSeconds TotalActiveSeconds WorkstationOID FK
int int binary(16)
Inventory Data Tables
21
novdocx (en) 7 January 2010
2. 12 NC_Floppy Table
The NC_Floppy table includes data about floppy drives.
Column Key Type Null Description
ComponentOID Capacity DriveLetter
PK, FK
binary(16) Float nvarchar(64)
No
An internal ID number used as a primary key. 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).
Column Key Type Null Description
ComponentOID RegistryKey Description DateInstalled
PK, FK
binary(16) nvarchar(256) nvarchar(128) nvarchar(20)
No
An internal ID number used as a primary key. 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 IPAddress SubnetMask LANAdapterOID
PK
binary(16) nvarchar(40) nvarchar(40
No
Internal ID number used as a primary key. IP Subnet Mask associated with a particular LAN card.
FK
binary(16)
No
LAN Adapter this IP entry is associated to.
22
ZENworks 10 Configuration Management Services Reference
novdocx (en) 7 January 2010
2. 15 NC_Keyboard Table
The NC_Keyboard table contains inventory data about keyboards.
Column Key Type Null Description
ComponentOID InterfaceType
PK, FK
binary(16) smallint
No
An internal ID number used as a primary key. 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.
Column Key Type Null Description
ComponentOID LANAddress
PK, FK
binary(16) nvarchar(12)
No
An internal ID number used as a primary key. 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 LDAPImportTaskUID
PK, FK FK
binary(16) binary(16)
No
An internal ID number used as a primary key. The LDAP properties associated with this mapping.
invClassType invFieldType isMatch LDAPProperty
nvarchar(8) nvarchar(256) tinyint nvarchar(255)
Inventory Data Tables
23
novdocx (en) 7 January 2010
2. 18 NC_LDAPImportTask Table
The NC_LDAPImportTask table contains information about LDAP import tasks. .
Column Key Type Null Description
ZUID LdapServer LdapPort
PK, FK
binary(16) nvarchar(128) nvarchar(8)
No
An internal ID number used as a primary key. 1 if an SSL connection is to be used when connecting to the LDAP server, else 0. The LDAP context for this task.
LdapBaseDn
nvarchar(256)
UseSSL
tinyint
LdapSearchFilter
nvarchar(255)
PersistCredentials
tinyint
HasCredentials
tinyint
CredentialServerUID LastCredentialUpdate RunningStatus
FK
binary(16) datetime nvarchar(32)
LdapSourceName LastStartTime LastFinishTime
nvarchar(128) datetime datetime
LdapContexts
ntext
24
ZENworks 10 Configuration Management Services Reference
novdocx (en) 7 January 2010
Column
Key
Type
Null
Description
LdapServerCert
ntext
The certificate used to connect to the LDAP server. The credentials of the LDAP directory.
Packet
ntext
2. 19 NC_LogicalDrive Table
The NC_LogicalDrive table contains inventory data about logical drives.
Column Key Type Null Description
ComponentOID DriveNumber DriveLetter AvailableSpace TotalSpace LogicalNumber IsRemote FileSystem
PK, FK
binary(16) smallint nvarchar(64) Float Float smallint smallint smallint
No
An internal ID number used as a primary key. The sequential number of this drive on the disk.
No
1 (TRUE) if the drive is networked; else 0. 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. The UNC path of the drive.
VolumeLabel VolumeSerialNumber UNCPath
nvarchar(64) nvarchar(32) nvarchar(100)
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
novdocx (en) 7 January 2010
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. The socket designator for the module.
ModuleSize Speed SocketDesignator FormFactor Parity ECC
smallint smallint nvarchar(24) smallint smallint smallint No No No
The physical configuration: 0=unknown, 1=SIMM, 2=DIMM. [. . . ] See "Notes" below.
Inventory Data Tables
35
novdocx (en) 7 January 2010
Column
Key
Type
Null
Description
ThermalState CoverRemoved Fingerprint
smallint DateTime Varbinary(255)
The thermal state. 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 1 2 3 4 5 6 7 8 9 10 11 12 Out of Range Other Unknown Desktop Low Profile Desktop Pizza Box Mini Tower Tower Portable Laptop Notebook Hand Held Docking Station 13 14 15 16 17 18 19 20 21 22 23 24 All in One Sub Notebook Space-saving Lunch Box Main Server Chassis Expansion Chassis SubChassis Bus Expansion Chassis Peripheral Chassis RAID chassis Rack Mount Chassis Sealed-case PC
ThermalState can have one of the following values:
0 1 2 3 4 5 6 Out of range Other Unknown Safe Warning Critical Non-recoverable
36
ZENworks 10 Configuration Management Services Reference
novdocx (en) 7 January 2010
2. 35 NC_SystemBoard Table
The NC_SystemBoard table contains inventory data about system boards.
Column Key Type Null Description
ComponentOID Revision Bus1type
PK, FK
binary(16) nvarchar(32) smallint
No
An internal ID number used as a primary key. The first bus type: 0=unknown, 1=ISA, 2=PCI, 3=MCA, 4=EISA, 5=PCMCIA, 6=VL. [. . . ]