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

ZENworks 10 Configuration Management SP2
Network Discovery – 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_NetworkDeviceExtended
PK,FK1 NetworkDeviceOID binary(16)
ClientID binary(16)
ClientVersion nvarchar(12)
ClientInstallType smallint
SystemName nvarchar(255)
SystemDescription nvarchar(255)
SystemObjectId nvarchar(255)
SystemUpTime numeric(19,2)
SystemContact nvarchar(255)
SystemLocation nvarchar(255)
SystemServices int
Manufacturer nvarchar(50)
ManufacturerAlias nvarchar(50)
ProductName nvarchar(100)
ProductNameAlias nvarchar(100)
SerialNumber nvarchar(64)
AssetTag nvarchar(64)
SerialNumberAlias nvarchar(64)
AssetTagAlias nvarchar(64)
LastSuccessfulLoadDate datetime
DateLastModified datetime
IsLeased smallint
LeaseExpireDate datetime
LeaseContractID nvarchar(20)
NC_NetworkDeviceBase
PK NetworkDeviceOID binary(16)
NetworkDeviceType smallint
I4 PrimaryIPAddress nvarchar(42)
I5 PrimaryMACAddress nvarchar(32)
I3 DNSName nvarchar(128)
DiscoveryDate datetime
LastSuccessfulScanDate datetime
InstanceVer int
DiscoveryMode nvarchar(13)
FK1,I2 DiscoveryTaskUID binary(16)
DiscoveredType nvarchar(12)
ShouldIgnore tinyint
FK2,I1 MigrationLocation binary(16)
DeploymentUID binary(16)
DeploymentStatus nvarchar(12)
StatusMessage nvarchar(1024)
AgentVersion nvarchar(24)
IsManaged tinyint
IsRetired tinyint
IsInventoried tinyint
ManagedDeviceUID binary(16)
ZoneUID binary(16)
ZoneName nvarchar(512)
NC_NetworkDeviceAddress
PK NetworkDeviceAddressOID binary(16)
FK1,I1 NetworkDeviceOID binary(16)
InstanceVer int
Description nvarchar(255)
InterfaceType int
MaxDatagramSize int
Speed int
MACAddress nvarchar(18)
AdminStatus int
OperationalStatus int
IPAddress nvarchar(15)
Subnet nvarchar(15)
SubnetMask nvarchar(15)
NC_NetworkPrinter
PK,FK1 NetworkDeviceOID binary(16)
FirmwareRevision nvarchar(25)
TotalPagesPrinted numeric(19,0)
NC_NetworkPrinter_Alert
PK PrinterAlertOID binary(16)
FK1,I1 NetworkDeviceOID binary(16)
InstanceVer int
SeverityLevel nvarchar(16)
TrainingLevel nvarchar(48)
AlertingSubunitName nvarchar(64)
Alert nvarchar(64)
AlertDetail nvarchar(255)
NC_NetworkPrinter_Consumable
PK PrinterConsumableOID binary(16)
FK1,I1 NetworkDeviceOID binary(16)
InstanceVer int
SupplyLevel nvarchar(20)
SupplyDescription nvarchar(255)
SupplyType nvarchar(20)
NC_NetworkHub
PK,FK1 NetworkDeviceOID binary(16)
FirmwareRevision nvarchar(25)
Ports int
NC_NetworkRouter
PK,FK1 NetworkDeviceOID binary(16)
FirmwareRevision nvarchar(25)
Ports int
NC_NetworkSwitch
PK,FK1 NetworkDeviceOID binary(16)
FirmwareRevision nvarchar(50)
Ports int
NC_NetworkWin32Device
PK,FK1 NetworkDeviceOID binary(16)
WkstnDomain nvarchar(64)
LoggedOnUser nvarchar(64)
NC_NetWareServer
PK,FK1 NetworkDeviceOID binary(16)
ServerName nvarchar(75)
OSSerialNumber nvarchar(20)
InternalIPXNumber nvarchar(12)
OSSFTLevel nvarchar(15)
OSVersion nvarchar(10)
OSReleaseDate datetime
NC_ManageableDevice
PK,FK1 NetworkDeviceOID binary(16)
MemSize numeric(19,0)
LDAPDomain nvarchar(512)
HostName nvarchar(256)
NC_ManageableDevice_CPU
PK CPUOID binary(16)
FK1,I1 NetworkDeviceOID binary(16)
InstanceVer int
CPUDescription nvarchar(128)
CPUType nvarchar(6)
CPUSpeed int
NC_ManageableDevice_LogicDisk
PK DiskOID binary(16)
FK1,I1 NetworkDeviceOID binary(16)
InstanceVer int
DiskID nvarchar(32)
DiskCapacity numeric(19,0)
DiskFreeSpace numeric(19,0)
NC_ManageableDevice_NetAdapter
PK AdapterOID binary(16)
FK1,I1 NetworkDeviceOID binary(16)
InstanceVer int
DNSName nvarchar(50)
IPAddress nvarchar(15)
MACAddress nvarchar(18)
IsPrimary tinyint
NC_ManageableDevice_OSSuite
PK SuiteOID binary(16)
FK1,I1 NetworkDeviceOID binary(16)
InstanceVer int
SuiteType nvarchar(16)
NC_ManageableDevice_OSVersion
PK OSVersionOID binary(16)
FK1,I1 NetworkDeviceOID binary(16)
InstanceVer int
Version nvarchar(48)
VersionType nvarchar(8)
NC_ManageableDevice_OSType
PK NetworkDeviceOID binary(16)
InstanceVer int
Vendor nvarchar(10)
Category nvarchar(7)
Platform nvarchar(8)
ServicePack int
DisplayAttribute nvarchar(32)
3