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. [. . . ] 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 number of times the application file has been launched. The total number of seconds the file has been open. The total number of seconds the file was active. 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 registry key used to identify the hot fix. 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 address associated with a particular LAN card. 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. ID providing linkage to the task table record that uses this mapping. 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. The port used to connect to the LDAP server. The base DN used when searching the LDAP server. 1 if an SSL connection is to be used when connecting to the LDAP server, else 0. The search filter that is used when searching the LDAP server. 1 if credentials are saved for future task execution, else 0. 1 if credentials are available for this task, else 0. ID used to identify the credential server. [. . . ] The building in which the workstation resides. The floor on which the workstation resides. The telephone number at the workstation. The total free space on the hard disk. UnManagedAgentId MachineName InventoryType binary (16) nvarchar(32) smallint LoginName Site Dept CostCenter Building Floor Room Phone TotalMemory TotalHardDiskSpace FreeHardDiskSpace LastScanId LastSuccessfulScanDate LastSuccessfulLoadDate nvarchar(32) nvarchar(32) nvarchar(32) nvarchar(32) nvarchar(32) nvarchar(10) nvarchar(32) nvarchar(32) int Float Float binary(16) DateTime DateTime The date and time of the last successful scan of the workstation. [. . . ]