Novell ZENWORKS 10 CONFIGURATION MANAGEMENT SP3 - NETWORK DISCOVERY DATABASE... Quick guide

NC_BIOS
PK,FK1 ComponentOID binary(16)
Version nvarchar(64)
ReleaseDate nvarchar(9)
DMICompVersion nva rchar(6)
IsAPMSupport smallint
IsACPICompatible smallint
FamilyCode nvarchar(32)
NC_CDROM
PK,FK1 ComponentOID binary(16)
InterfaceType smallint
DriveLetter nvarchar(64)
DeviceType smallint
NC_CPU
PK,FK1 ComponentOID binary(16)
Speed float
VendorIdentifier nvarchar(12)
CPUIDType smallint
CPUIDFamily smallint
CPUIDModel smallint
CPUIDStepping smallint
IsMMX smallint
L1CacheSize smallint
Is64Bit tinyint
CoreCount tinyint
IsHyperThreaded tinyint
NC_Component
PK ComponentOID binary(16)
DerivedClassId int
I5 SurrogateID binary(16)
I2 ProductType smallint
Collector smallint
I4 Source smallint
I3 SerialNumber nvarchar(38)
AssetTag nvarchar (38)
SerialNumberAlias nvarchar(38)
AssetTagAlias nvarchar(38)
ModelNumber nvarchar(32)
CreateDate datetime
DateLastModified datetime
I1 IsDeleted datetime
ExcludedNonColl tinyint
ADF0 nvarchar(256 )
ADF1 nvarchar(256 )
ADF2 nvarchar(64)
ADF3 nvarchar(64)
ADF4 nvarchar(64)
ADF5 nvarchar(64)
ADF6 nvarchar(64)
ADF7 nvarchar(64)
ADF8 nvarchar(64)
ADF9 nvarchar(64)
ADF10 nvarchar(64)
ADF11 nvarchar(64)
ADF12 nvarchar(64)
ADF13 nvarchar(64)
ADF14 nvarchar(64)
ADF15 nvarchar(64)
ADF16 nvarchar(64)
ADF17 nvarchar(64)
ADF18 nvarchar(64)
ADF19 nvarchar(64)
FK1,I8 ProductOID binary(16)
FK2,I7 ProductAl ias binary(16)
FK3,I6 WorkstationOID binary(16)
I9 IsRetired datetime
NC_Disk
PK,FK1 ComponentOID binary(16)
DriveNumber smallint
IsSmartWarning smallint
LogicalDrives nvarchar(1024)
RawTotalSpace float
InterfaceType smallint
NC_Floppy
PK,FK1 ComponentOID binary(16)
Capacity float
DriveLetter nvarchar(64)
NC_HotFix
PK,FK1 ComponentOID binary(16)
RegistryKey nva rchar(256)
Description nvarchar(128)
DateInstalled nvarchar(20)
NC_Keyboard
PK,FK1 ComponentOID binary(16)
InterfaceType smallint
NC_LANAdapter
PK,FK1 ComponentOID binary(16)
LANAddress nvarchar(12)
NC_LogicalDrive
PK,FK1 ComponentOID binary(16)
DriveNumber smallint
DriveLetter nvar char(64)
AvailableSpace float
TotalSpace float
LogicalNumber sm allint
IsRemote smallint
FileSystem small int
VolumeLabel nvarchar(64)
VolumeSerialNumber nvarchar(32)
UNCPath nvarchar (100)
NC_Product
PK ProductOID binary(16)
I2 Code int
ProductType smallint
I4 Manufacturer nvarchar(35)
I5 Product nvarchar(100)
Model nvarchar(25)
I6 Source smallint
SWPlatform smallint
NotInUse smallint
Classification smallint
Platform smallin t
Language smallint
IsCodeValid smallint
IsMerged smallint
DistributionModel smallint
LicenseProductType smallint
CurrentManufacturer nvarchar(35)
CreateDate datetime
DateLastModified datetime
I3 IsDeleted datetime
ADF0 nvarchar(256)
ADF1 nvarchar(256)
ADF2 nvarchar(64)
ADF3 nvarchar(64)
ADF4 nvarchar(64)
ADF5 nvarchar(64)
ADF6 nvarchar(64)
ADF7 nvarchar(64)
ADF8 nvarchar(64)
ADF9 nvarchar(64)
ADF10 nvarchar(64)
ADF11 nvarchar(64)
ADF12 nvarchar(64)
ADF13 nvarchar(64)
ADF14 nvarchar(64)
ADF15 nvarchar(64)
ADF16 nvarchar(64)
ADF17 nvarchar(64)
ADF18 nvarchar(64)
ADF19 nvarchar(64)
FK1,I1 ProductCategoryOID binary(16)
NC_ProductCategory
PK ProductCategor yOID binary(16)
I2 ProductCategoryName nvarchar(32)
IsTally smallint
IsDeleted datetime
FK1,I1 CategoryOID binary(16)
NC_Category
PK CategoryOID binary(16)
I1 CategoryName nvarchar(32)
CategoryType smallint
IsTally smallint
IsDeleted datetime
NC_Modem
PK,FK1 ComponentOID binary(16)
Speed int
ComPort nvarchar(4)
ModemType smallint
NC_Monitor
PK,FK1 ComponentOID binary(16)
EISAManufacturer nvarchar(64)
VESAProduct nvarchar(64)
YearManufactured smallint
WeekManufactured s mallint
DiagonalSize float
NC_OperatingSystem
PK,FK1 ComponentOID binary(16)
OSInternalVersion nvarchar(8)
ServicePack nvarc har(8)
BootDriveLetter nvarchar(1)
NC_NetworkDriver
PK,FK1 ComponentOID binary(16)
FileVersion nvarchar(32)
Filename nvarchar(16)
Description nvarchar(80)
NC_Mouse
PK,FK1 ComponentOID binary(16)
InterfaceType smallint
NC_RemovableMedia
PK,FK1 ComponentOID binary(16)
InterfaceType smallint
NC_Printer
PK,FK1 ComponentOID binary(16)
IsRemote smallint
UNCPath nvarchar(255)
Port nvarchar(6)
DriverName nvarchar(64)
WindowsName nvar char(64)
IPAddress nvarch ar(40)
NC_ParallelPort
PK,FK1 ComponentOID binary(16)
LogicalName nvar char(64)
IsEPP smallint
IsECP smallint
NC_Software
PK,FK1 ComponentOID binary(16)
FK2,I1 ParentSuiteOID binary(16)
Path nvarchar(255)
AdditionalInfo nvarchar(200)
NC_SerialPort
PK,FK1 ComponentOID binary(16)
LogicalName nvarchar(4)
®
NC_Workstation
PK WorkstationOID binary(16)
FK2,I1 ZenWorksAg entId binary(16)
UnManagedAgentId binary(16)
I16 MachineName nvarchar(32)
I11 InventoryType smallint
AssetType tinyin t
VirtualMachineType tinyint
I15 LoginName nvarchar(32)
I19 Site nvarchar(32)
I9 Dept nvarchar(32)
I6 CostCenter nvarchar(32)
I5 Building nvarchar(32)
I10 Floor nvarchar(10)
Room nvarchar(32)
Phone nvarchar(32)
I22 TotalMemory int
AvailableMemorySlots smallint
I21 TotalHardDiskSpace float
FreeHardDiskSpace float
LastScanId binary(16)
I14 LastSuccessfulScanDate datetime
LastSuccessfulLoadDate datetime
LastUsageGatherDate datetime
LANAddress nvarchar(12)
I12 IPAddress nvarchar(15)
SubnetMask nvarchar(15)
DefaultGateway nvarchar(15)
WkstnDomain nvarchar(64)
I18 SerialNumber nvarchar(38)
I4 AssetTag nvarchar(38)
IsLeased smallint
LeaseExpireDate datetime
LeaseContractId nvarchar(20)
I3 AccountId varbinary(16)
I8 CreateDate datetime
DateLastModified datetime
I13 IsDeleted datetime
I7 CPUSpeed float
CPUProduct nvarchar(100)
CPUCount smallint
SystemManufacturer nvarchar(35)
SystemProduct nvarchar(100)
SystemModel nvarchar(25)
I20 SystemChassis smallint
OSManufacturer nvarchar(35)
OSProduct nvarcha r(100)
OSModel nvarchar(25)
OSServicePack nvarchar(8)
OSBuild nvarchar(8)
I17 ScannedSerialNumber nvarchar(38)
CalculatedPrimaryUser nvarchar(128)
ADF0 nvarchar(256)
ADF1 nvarchar(256)
ADF2 nvarchar(64)
ADF3 nvarchar(64)
ADF4 nvarchar(64)
ADF5 nvarchar(64)
ADF6 nvarchar(64)
ADF7 nvarchar(64)
ADF8 nvarchar(64)
ADF9 nvarchar(64)
ADF10 nvarchar(64)
ADF11 nvarchar(64)
ADF12 nvarchar(64)
ADF13 nvarchar(64)
ADF14 nvarchar(64)
ADF15 nvarchar(64)
ADF16 nvarchar(64)
ADF17 nvarchar(64)
ADF18 nvarchar(64)
ADF19 nvarchar(64)
FK1,I2 PrimaryUserOID binary(16)
NC_User
PK UserOID binary(16)
I1 FirstName nvarchar (32)
I3 Mi ddleName nvarchar (32)
I2 LastName nvarchar(32)
Phone nvarchar(32)
Email nvarchar(100)
Phone2 nvarchar(32)
Fax nvarchar(32)
IsDeleted datetime
ADF0 nvarchar(256)
ADF1 nvarchar(256)
ADF2 nvarchar(64)
ADF3 nvarchar(64)
ADF4 nvarchar(64)
ADF5 nvarchar(64)
ADF6 nvarchar(64)
ADF7 nvarchar(64)
ADF8 nvarchar(64)
ADF9 nvarchar(64)
ADF10 nvarchar(64)
ADF11 nvarchar(64)
ADF12 nvarchar(64)
ADF13 nvarchar(64)
ADF14 nvarchar(64)
ADF15 nvarchar(64)
ADF16 nvarchar(64)
ADF17 nvarchar(64)
ADF18 nvarchar(64)
ADF19 nvarchar(64)
NC_VirtualMachine
PK VirtualMachineOID binary(16)
VMDisplayName nvarchar(100)
VMGuestOS nvarchar(100)
VMType tinyint
VMEthernetAddr ess nvarchar(12)
VMUUID nvarchar(36)
FK1,I1 HostWorkstationOID binary(16)
NC_WkstnReconcileData
PK WkstnReconcileDataOID binary(16)
ReconcileData nvar char(38)
ReconcileType smallint
IsNovell smallint
InstanceVer int
NC_WkstnChanges
PK WkstnChangesOID binary(16)
TypeOfChange smallint
SourceOfChange smallint
FieldId int
FieldLabel nvarchar(50)
Value1 nvarchar(255)
Value2 nvarchar(255)
CreateDate datetime
FK1,I1 WorkstationOID binary(16)
NC_PRU
PK PRUOID binary(16)
KBVersion nvarchar(48)
PRUVersion nvarc har(48)
PRUNumber smallint
PRULabel nvarchar (16)
PRUDate datetime
PRU image
LMPRUVersion nvar char(48)
NC_LDAPImportTask
PK,FK2 ZUID binary(16)
LdapServer nvarchar(128)
LdapPort nvarchar(8)
LdapBaseDn nvarchar(256)
UseSSL tinyint
LdapSearchFilter nvarchar(255)
PersistCredentials tinyint
HasCredentials tinyint
FK1,I1 CredentialServerUID binary(16)
LastCredentialUpdate datetime
RunningStatus nvarchar(32)
LdapSourceName nvarchar(128)
LastStartTi me datetime
LastFinishTime datetime
LdapContexts ntext
LdapServerCert ntext
FK3,I2 ServerUID binary(16)
Schedule nvarchar(2048)
LastCount int
LastMessages ntext
Packet ntext
NC_LDAPImportMappings
PK,FK2 ZUID binary(16)
FK1,I1 LDAPImportTaskUID binary(16)
invClassType smallint
invFieldType smallint
isMatch tinyint
LDAPProperty nvarchar(100)
NC_IPAddress
PK IPAddressOID binary(16)
IPAddress nvarchar(40)
SubnetMask nvarch ar(40)
FK1,I1 LANAdapterOID binary(16)
NC_FileScanData
PK FileScanDataOID binary(16)
FileDate datetime
FileSize numeric(19,2)
FileName nvarchar(64)
SubDirectory nvarchar(255)
Extension nvarchar(32)
FileScanCategory smallint
VICompanyName nvarchar(64)
VIProductName nvarchar(80)
VIProductVersion nvarchar(32)
VILanguage nvarchar(16)
VIFileVersion nvarchar(32)
StartupCount int
TotalRuntimeSeconds int
TotalActiveSeconds int
FK1,I1 WorkstationOID binary(16)
NC_DeviceRes
PK DeviceResOID binary(16)
Description nvarchar(64)
IOMap nvarchar(64)
IRQs nvarchar(64)
DMAs nvarchar(64)
Memory nvarchar(64)
FK1,I1 WorkstationOID binary(16)
NC_ChoiceListItem
PK ChoiceListItemOID binary(16)
ChoiceText nvarchar (100)
FK1,I1 ADFOID numeric(19,0)
NC_CompChanges
PK CompChangesOID binary(16)
TypeOfChange smallint
SourceOfChange smallint
FieldId int
FieldLabel nvarchar(50)
Value1 nvarchar(255)
Value2 nvarchar(255)
CreateDate datetime
I1 PrevWkstnOID binary(16)
FK1,I2 Component OID binary(16)
NC_ADF
PK ADFOID numeric(19,0) identity
TableName nvarchar(32)
InternalName nvar char(8)
Label nvarchar(32)
DataType smallint
InUse tinyint
DefaultValue nvarchar(255)
IsDisplay smallint
IsEditable smallint
ControlType smallint
EditMask nvarchar(64)
AutoFill smallint
IsStoreMask smallint
IsRequired smallint
IsUnique smallint
MaxLength smallint
DateLastModified datetime
NC_System
PK,FK1 ComponentOID binary(16)
ChassisType smallint
ThermalState smallint
CoverRemoved dat etime
Fingerprint varbinary(255)
NC_SystemBoard
PK,FK1 ComponentOID binary(16)
Revision nvarchar(32)
Bus1type smallint
Bus1slots smallint
Bus2type smallint
Bus2slots smallint
L2CacheSize smallint
L2CacheSpeed small int
L2CacheWritePolicy smallint
SystemBoardId nvarchar(64)
MotherboardUID binary(16)
NC_VideoAdapter
PK,FK1 ComponentOID binary(16)
MinRefreshRate smallint
MaxRefreshRate smallint
MemoryType smallint
MemorySize int
MinVertResolution smallint
MinHorizResolution smallint
MaxVertResolution smallint
MaxHorizResolution smallint
NumberBitsPerPixel smallint
PixelShaderMajorVersion smallint
PixelShaderMinorVersion smallint
ZENworks 10 Configuration ManagementSP2
Inventory – 05/2009
Notice: Details about the ZENworksdatabase
schema are provided for referencepurposes. The
schema generally changes in eachrelease of the
product and any integration doneat the database
level may be impacted by these changes.We
suggest you contact Novellto discuss your import
or export integrat ion plans with the ZENworks
database.
Copyright © 2009 Novell, Inc.Al lrights reserved.
No part of this publication may be reproduced,
photocopied, st ored on a retrieval system, or
transmitted without the express writtenconsent
of the publisher.
NC_MemoryModu le
PK,FK1 ComponentOID binary(16)
MemoryType smallint
ModuleSize smalli nt
Speed smallint
SocketDesignat or nvarchar(24)
FormFactor smallint
Parity smallint
ECC smallint
zDevice
PK,FK4 ZUID binary(16)
Platform nvarchar(32)
Hostname nvarcha r(64)
DNS nvarchar(64)
Password nvarchar(64)
Port int
AddedDate datetime
LastContact datet ime
LastFullRefresh datetime
OSName nvarchar(32)
FK2,I2 OSId binary(16)
FK3,I3 PrimaryUser binary(16)
Owner nvarchar(256)
Language nvarchar(10)
Site nvarchar(64)
Department nvarchar(64)
Location nvarchar(64)
U5,U1,U6,U3,U4 ,U2 SerialNumber nvarcha r(64)
LastInventoryScan datetime
PrimaryUserCal culated tinyint
Lost tinyint
FK1,I1 ManagedFolder binary(16)
Retired tinyint
RetiredDate datet ime
ZenAgentVersion ntext
Timezone numeric(19,0)
AgentVersion nvarchar(32)
3