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 nvarc har(6)
IsAPMSupport smallint
IsACPICompatible smallint
FamilyCode nvarchar (32)
NC_CDROM
PK,FK1 ComponentOID binary(16)
InterfaceType smalli nt
DriveLetter nvar char(64)
DeviceType smallint
NC_CPU
PK,FK1 ComponentOID binary(1 6)
Speed float
VendorIdentifier nv archar(12)
CPUIDType smallint
CPUIDFamily smallint
CPUIDModel smallint
CPUIDStepping smallint
IsMMX smallint
L1CacheSize smallint
Is64Bit tinyint
CoreCount ti nyint
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)
SerialNumberA lias nvarchar( 38)
AssetTagAlias nvarchar(38)
ModelNumber nvarch ar(32)
CreateDate datet ime
DateLastModified datetime
I1 IsDeleted datetime
ExcludedNonColl ti nyint
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 nvarcha r(64)
ADF11 nvarcha r(64)
ADF12 nvarcha r(64)
ADF13 nvarcha r(64)
ADF14 nvarcha r(64)
ADF15 nvarcha r(64)
ADF16 nvarcha r(64)
ADF17 nvarcha r(64)
ADF18 nvarcha r(64)
ADF19 nvarcha r(64)
FK1,I8 ProductOID binary(16)
FK2,I7 ProductAlias binary(16)
FK3,I6 WorkstationOID binary(16)
I9 IsRetired datetime
NC_Disk
PK,FK1 ComponentOID binary(1 6)
DriveNumber smallint
IsSmartWarning smallint
LogicalDrives nvarc har(1024)
RawTotalSpace float
InterfaceType smalli nt
NC_Floppy
PK,FK1 ComponentOID binary(16)
Capacity float
DriveLetter nvar char(64)
NC_HotFix
PK,FK1 ComponentOID binary(16)
RegistryKey nvarc har(256)
Description nvarchar(128)
DateInstalled nvarchar(20)
NC_Keyboard
PK,FK1 ComponentOID binary(16)
InterfaceType smal lint
NC_LANAdapter
PK,FK1 ComponentOID binary(16)
LANAddress nvarchar (12)
NC_LogicalDrive
PK,FK1 ComponentOID binary(16)
DriveNumber smallint
DriveLetter nvarc har(64)
AvailableSpace floa t
TotalSpace float
LogicalNumber smalli nt
IsRemote smallint
FileSystem smallint
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 smalli nt
Classification smal lint
Platform smallin t
Language smallint
IsCodeValid smallint
IsMerged smallint
DistributionMo del smallint
LicenseProductType s mallint
CurrentManufacturer nvarchar(35)
CreateDate datetime
DateLastModified da tetime
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 ProductCategoryOI D binary(16)
NC_ProductCategory
PK ProductCategoryOID binary(16)
I2 ProductCategoryName n varchar(32)
IsTally smallint
IsDeleted datetime
FK1,I1 CategoryOID binary(16)
NC_Category
PK CategoryOID binary(16)
I1 CategoryName nvarch ar(32)
CategoryType smallint
IsTally smallint
IsDeleted d atetime
NC_MemoryModule
PK,FK1 ComponentOID binary(16)
MemoryType smallint
ModuleSize smallint
Speed smallint
SocketDesignator nvarchar(24)
FormFactor smallint
Parity smallint
ECC smallint
NC_Modem
PK,FK1 ComponentOID binary(16)
Speed int
ComPort nvarch ar(4)
ModemType smallint
NC_Monitor
PK,FK1 ComponentOID binary(16)
EISAManufacturer nvarc har(64)
VESAProduct nvarchar(64 )
YearManufactured s mallint
WeekManufactured sm allint
DiagonalSize float
NC_OperatingSystem
PK,FK1 ComponentOID binary(16)
OSInternalVersion nvarchar(8)
ServicePack nvarchar(8)
BootDriveLetter nvarchar(1)
NC_NetworkDriver
PK,FK1 ComponentOID binary(16)
FileVers ion nvarch ar(32)
Filename nvarch ar(16)
Description nvarchar(80)
NC_Mouse
PK,FK1 ComponentOID binary(16)
InterfaceType smalli nt
NC_RemovableMedia
PK,FK1 ComponentOID binary(16)
InterfaceType smal lint
NC_Printer
PK,FK1 ComponentOID binary(16)
IsRemote smallint
UNCPath nvarch ar(255)
Port nvarchar(6)
DriverName nvarc har(64)
WindowsName nvarc har(64)
IPAddress nvarch ar(40)
NC_ParallelPort
PK,FK1 ComponentOID binary(16)
LogicalName nvarc har(64)
IsEPP smallint
IsECP smallint
NC_Software
PK,FK1 ComponentOID binary(16)
FK2,I1 ParentSuiteOID binary(16)
Path nvarchar(25 5)
AdditionalInfo n varchar(200)
NC_SerialPort
PK,FK1 ComponentOID binary(16)
LogicalName nvarc har(4)
®
NC_Workstation
PK WorkstationOID binary(16)
FK2,I1 ZenWorksA gentId bin ary(16)
UnManagedAgentId b inary(16)
I16 MachineName nvarchar(32)
I11 InventoryType smallint
AssetType tinyin t
VirtualMachineType t inyint
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
AvailableMemorySlo ts smallint
I21 TotalHardDiskSpace float
FreeHardDiskSpa ce float
LastScanId binar y(16)
I14 LastSuccessfulScanDate datetime
LastSuccessfulLoadD ate datetime
LastUsageGatherDate datetime
LANAddress nvarchar(12)
I12 IPAddress nvarchar(15)
SubnetMask nvarch ar(15)
DefaultGateway nvarchar(15)
WkstnDomain nvarchar(64)
I18 SerialNumb er nvarchar(38)
I4 AssetTag nvarchar(38)
IsLeased smallint
LeaseExpireDate dat etime
LeaseContract Id nvarchar(20 )
I3 AccountId varbinary(16)
I8 CreateDate datetime
DateLastModified datetime
I13 IsDeleted datetime
I7 CPUSpeed float
CPUProduct nva rchar(100)
CPUCount smallint
SystemManufac turer nvarcha r(35)
SystemProduct nvarch ar(100)
SystemModel nvarc har(25)
I20 SystemChassis smallint
OSManufacturer nv archar(35)
OSProduct nvarch ar(100)
OSModel nvarch ar(25)
OSServicePack n varchar(8)
OSBuild nvarch ar(8)
I17 ScannedSeri alNumber nvarchar( 38)
CalculatedPrim aryUser nvarcha r(128)
ADF0 nvarchar(25 6)
ADF1 nvarchar(25 6)
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 nvarcha r(64)
ADF11 nvarcha r(64)
ADF12 nvarcha r(64)
ADF13 nvarcha r(64)
ADF14 nvarcha r(64)
ADF15 nvarcha r(64)
ADF16 nvarcha r(64)
ADF17 nvarcha r(64)
ADF18 nvarcha r(64)
ADF19 nvarcha r(64)
FK1,I2 PrimaryUserOID binary(16)
NC_User
PK UserOID binary(1 6)
I1 FirstName nvar char(32)
I3 MiddleName nvarchar(3 2)
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_WebSoftware
PK WebSoftwareOID binary(16)
U2,U4,U5,U6,U1, U3 ApplicationName nvarchar(45)
Manufacturer nvarc har(35)
Version nvarcha r(25)
Language nvarchar( 25)
CreateDate datet ime
DateLastModified da tetime
IsDeleted datetime
NC_WebSoftwareUsage History
PK Web UsageHistoryOID bi nary(16 )
FK2,I4 WebSoftwareOID binary(16)
FK3,I3 Workstatio nOID binary(16)
FK1,I1 UserOID binary(16)
I2 UsageDate datetim e
StartupCount int
RuntimeSeconds int
ActiveSe conds int
IsServerUsage smallint
SourceDevice nvarc har(32)
Path nvarchar(256)
WebBrowserType smallint
NC_WebSoftwareAtt ributes
PK WebSoftwareAtt ributesOID bi nary(16)
FK1,I1 WebS oftwareO ID binary(1 6)
U2,U5,U4,U6,U3, U1 Attribute nvarchar(256)
U2,U5,U4,U6,U3, U1 AttributeType smal lint
NC_VRBSoftware
PK VRBSoftwareOID binary(16)
Server nvarchar(256)
Sharename nvarchar(256)
Path nvarchar(256)
Filename nvarchar( 256)
Manufacturer nvarchar(35)
ManufacturerAlias nvarchar(35)
ProductName nvarc har(100)
ProductNameAlias nvarchar(100)
Version nvarc har(25)
VersionAlias nvarchar(25)
FileVersion nva rchar(25)
Language nvarchar( 25)
CreateDate da tetime
DateLastModified datetime
NC_VirtualMachine
PK Virtua lMachi neOID binary(16)
VMDisplayName nvarchar(100)
VMGuestOS nvarch ar(100)
VMType tinyint
VMEthernetAddress n varchar(12)
VMUUID nvarchar( 36)
FK1,I1 HostWorkstationOID binary(16)
NC_SoftwareUsage History
PK SWU sageHistoryOID binary(16)
FK1,I4 ComponentOID binary(16)
FK2,I1 UserOID binary(16)
I2 UsageDate dateti me
StartupCount int
RuntimeSeconds int
ActiveSeconds int
I3 IsServerUsage smallint
SourceDevice nvarchar(32)
RemoteWorkstationOID binary(16)
NC_WebSoftwareUs ageSummary
PK We bUsage SummaryOI D binary(16)
FK1,I2 We bSoftwar eOID binar y(16)
FK2,I1 WorkstationOID binary(16)
FirstUsed datetime
LastUsed dateti me
NC_WkstnChanges
PK WkstnChangesOID binary(16)
TypeOfChange smallint
SourceOfChange smallint
FieldId int
FieldLabel nvarch ar(50)
Value1 nvarchar(25 5)
Value2 nvarchar(25 5)
CreateDate da tetime
FK1,I1 WorkstationOID binary(16)
NC_PRU
PK PRUOID binary(16)
KBVersion nvarchar(48)
PRUVersion nvarchar(48)
PRUNumber smallint
PRULabel nvarchar(16)
PRUDate datetime
PRU image
LMPRUVersion nvarcha r(48)
NC_NetSoftwareUs ageSummary
PK NWSWUsageSummaryOID binar y(16)
FK1,I2 VRBSoftwareOID binary(16)
FK2,I1 WorkstationOID binary(16)
FirstUsed datetime
LastUsed datetime
NC_NetSoftwareUsageHistory
PK NWSWUsag eHistoryOID binary( 16)
FK2,I4 VRBSoftwareOID binary(16)
I2 UsageDate datetime
StartupCount int
RuntimeSeconds int
ActiveSeconds int
FK3,I3 WorkstationOID b inary(16)
FK1,I1 UserOID binary(16)
NC_LDAPImportTask
PK,FK2 ZUID binary(16)
LdapServer nvarchar(1 28)
LdapPort nvarchar(8 )
LdapBaseDn nvarchar(2 56)
UseSSL tinyint
LdapSearchFilter nvar char(255)
PersistCredentials tinyint
HasCredentials tinyint
FK1,I1 CredentialServ erUID binary(16)
LastCredentialUpd ate datetime
RunningStatus nvarc har(32)
LdapSourceName nvar char(128)
LastStartTime dat etime
LastFinishTime dat etime
LdapContexts ntext
LdapServerCert ntext
FK3,I2 ServerUID binary(16)
Schedule nvarchar(2 048)
LastCount int
LastMessages ntext
Packet ntext
NC_LDAPImportMap pings
PK,FK2 ZUID binary(16)
FK1,I1 LDAPImportTaskUID b inary(16)
invClassType smallint
invFieldType smallint
isMatch tinyint
LDAPProperty nvarchar (100)
NC_IPAddress
PK IPAddressOID binary(16)
IPAddress nvarcha r(40)
SubnetMask nvarchar( 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 nvarc har(32)
StartupCount int
TotalRun timeSecon ds int
TotalActiveSeconds int
FK1,I1 WorkstationOI D binary (16)
NC_DeviceRes
PK DeviceResOID binar y(16)
Description nvarc har(64)
IOMap nvarchar(64)
IRQs nvarchar(64)
DMAs nvarchar(64)
Memory nvarchar(6 4)
FK1,I1 Wor kstationOID bina ry(16)
NC_ChoiceListItem
PK ChoiceListItemOID binar y(16)
ChoiceText nvarchar( 100)
FK1,I1 ADFOID numeric(19,0)
NC_CompChanges
PK CompChangesOID binary(16)
TypeOfChange smallint
SourceOfChange smallint
FieldId int
FieldLabel nvarcha r(50)
Value1 nvarchar(255 )
Value2 nvarchar(255 )
CreateDate datetime
I1 PrevWkstnO ID binary(16)
FK1,I2 ComponentOI D binary( 16)
NC_ADF
PK ADFOID numeric(19,0) identit y
TableName nvarchar( 32)
InternalName nvarchar(8)
Label nvarchar(32 )
DataType smallint
InUse tinyint
DefaultValue nv archar(255)
IsDisplay smallint
IsEditable smallint
ControlType smallint
EditMask nvarchar(64)
AutoFill smallint
IsStoreMask smallint
IsRequired smalli nt
IsUnique smallint
MaxLength smallint
DateLastModified datetime
NC_System
PK,FK1 ComponentOID binary(16)
ChassisType smallint
ThermalState smallint
CoverRemoved dateti me
Fingerprint varbi nary(255)
NC_SystemBoard
PK,FK1 ComponentOID binary(16)
Revision nvarchar (32)
Bus1type smallint
Bus1slots smallint
Bus2type smallint
Bus2slots smallint
L2CacheSize smallint
L2CacheSpeed smallint
L2CacheWritePolicy smallint
SystemBoardId nvar char(64)
MotherboardUID bi nary(16)
NC_VideoAdapter
PK,FK1 ComponentOID binary(16)
MinRefreshRate smallint
MaxRefreshRate smallint
MemoryType sma llint
MemorySize int
MinVertResolution smallint
MinHorizResolution smallint
MaxVertResolution smallint
MaxHorizResolution smallint
NumberBitsPerPixel smallint
PixelShaderMajorV ersion smallint
PixelShaderMinor Version smallint
NC_SoftwareUsageSummary
PK SWUsageSummaryOID binary( 16)
FK1,I1 ComponentOID binary(16)
FirstUsed datetime
LastUsed datetime
FirstServed dateti me
LastServed datetime
ZENworks 10 Configuration Management SP2
Inventory + Usage – 05/2009
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. We
suggest you contact Novell to discuss your import
or export integration plans with the ZENworks
database.
Copyright © 2009 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.
NC_WkstnReconcile Data
PK WkstnReconcileDataOID binary(16)
ReconcileData nvarc har(38)
ReconcileType smallint
IsNovell smallint
InstanceVer int
zDevice
PK,FK4 ZUID binary(16)
Platform nvarchar(32)
Hostname nvarchar(64)
DNS nvarchar(64)
Password nvarchar(6 4)
Port int
AddedDate datetime
LastContact dateti me
LastFullRefresh d atetime
OSName nvarchar(32)
FK2,I2 OSId binary(16)
FK3,I3 PrimaryUser b inary(16)
Owner nvarchar(256)
Language nvarchar( 10)
Site nvarchar(64)
Department nvarcha r(64)
Location nvarchar( 64)
U5,U1,U6,U3,U4, U2 SerialNumber nvarchar( 64)
LastInventorySc an datetime
PrimaryUserCalcula ted tinyint
Lost tinyint
FK1,I1 ManagedFol der binary(16)
Retired tinyint
RetiredDate dateti me
ZenAgentVersion n text
Timezone nume ric(19,0)
AgentVersion nvarc har(32)
binary(16)
InstanceVer int
Vendor nvarchar(10)
Category nvarchar(7)
Platform nvarchar(8)
ServicePack int
DisplayAttribute nvarchar(32)
3