User manual NOVELL ZENWORKS 10 CONFIGURATION MANAGEMENT SP3 10.3 REFERENCE

[. . . ] 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. [. . . ]