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

LC_Component
PK ComponentOID binary(16)
I3 WorkstationOID binary(16)
FK1,I2 TallyProductOID binary(16)
I4 Excluded smallint
ExcludedNonColl smallint
Ignored tinyint
I1 ReferencedComponentOID bin ary(16)
LC_ImportError
PK ErrorOID binary(16)
FK1,I1 JobOID binary(16)
FileName nvarchar(64)
LineNum int
ErrorMsg nvarchar(64)
StackTrace nvarchar(256)
CreateDate datetime
LC_ImportHistory
PK JobOID binary(16)
NumRecordsCreated int
NumDetailsCreated int
NumProductsCreated int
ImportStartTime datetime
ImportEndTime datetime
Duration numeric(19,2)
NumErrors int
FileName nvarchar(64)
FileLength numeric(19,2)
NumRows int
Success int
Progress numeric(19,2)
LC_TallyProductSuiteMap
PK MapOID binary(16)
FK2,I2,U1 SuiteOID binary(16)
FK1,I1,U1 ComponentProductOID binary(16)
LC_PurchaseRecDetail
PK DetailOID binary(16)
FK2,I2 PurchaseRecOID binary(16)
FK1,I1 PurchasedProdOID binary(16)
Quantity int
SerialNumber nvarchar(40)
Comments nvarchar(128)
CostCenter nvarchar(32)
Department nvarchar(32)
Site nvarchar(32)
InvoiceNumber nvarchar(32)
UnitMSRP numeric(19,2)
UnitPrice numeric(19,2)
TotalPrice numeric(19,2)
ExpDate datetime
LC_License
PK,FK1 ZUID binary(16)
U2,U1 Manufacturer nvarchar(64)
U2,U1 Version nvarchar(32)
Notes nvarchar(256)
AllocateBy smallint
AllocateImports s mallint
U2,U1 LicenseName nvarchar(255)
Compliance smallint
CalculatedIndex flo at
ManualIndex float
TotalLicenses int
TotalInstalled int
HasManualSource tinyint
CalculatedLicenseQty int
ManualLicenseQty int
CalculatedConsumption int
ManualConsumption int
CalculatedOverLicen sedQty int
ManualOverLicensedQty int
CalculatedUnderLi censedQty int
ManualUnderLicensedQty int
CalculationDate datetim e
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)
AllocatedQty int
LC_LicenseToPPMap
PK MapOID binary(16)
FK2,U2,U3,U5,U1,U4 Purchas edProductOID binary(16)
FK1,I1 LicenseOID binary(16)
LC_TallyProduct
PK,FK2 ZUID binary(16)
Version nvarchar(32)
Manufacturer nvarchar(64)
Excluded int
I2 Source int
Platform int
Product nvarchar(256)
CurrentManufacturer nvarchar(64)
DistributionModel smallint
LicenseType smallint
QtyIgnored int
QtyInstalled int
FK1,I1 DpExtensionUID binary(16)
LC_PurchaseRec
PK,FK1 ZUID binary(16)
OrderDate datetime
PONumber nvarchar(32)
Reseller nvarchar(64)
Company nvarchar(32)
ShipAddress1 nvarchar(64)
ShipAddress2 nvarchar(64)
ShipAddress3 nvarchar(64)
ShipCity nvarchar(32)
ShipState nvarchar(32)
ShipZip nvarchar(16)
ShipCountry nvarchar(32)
Recipient nvarchar(32)
Notes nvarchar(256)
LC_LicenseToTPMap
PK MapOID binary(16)
FK2,I1 TallyProductOID binary(16)
FK1,I2 LicenseOID binary(16)
LC_TallyProductMap
PK MapOID binary(16)
FK1,I1 TallyProdOID binary(16)
I2 Source int
LC_PurchasedProduct
PK,FK1 ZUID binary(16)
ProductDesc nvarchar(128)
ResellerSKU nvarchar(32)
MfgPartNum nvarchar(32)
U2,U1 Manufacturer nvarchar(64)
U2,U1 Version nvarchar(32)
U2,U1 Type nvarchar(32)
U2,U1 LicenseQty int
Upgrade int
Excluded int
Matched int
Associated int
Notes nvarchar(255)
U2,U1 Product nv archar(256)
LC_TallyProductSuite
PK ZUID binary(16)
FK1,I1 ProductOID binary(16)
SuiteName nvarchar(64)
LC_ProductStandards
PK StandardsOID binary(16)
FK1,I1 ProductOID binary(16)
GroupName nvarchar(30)
StandardName nvarchar(30)
LC_PurchaseRecordImportMa p
PK MapName nvar char(64)
MapResellerName nvarchar(32)
MapDelim nvarchar(8)
MapDateFormat nvarchar(16)
MapIgnoredCols nvarchar(512)
PONum nvarchar(32)
OrderDate nvarchar(32)
InvoiceNum nvarchar(32)
Reseller nvarchar(32)
Recipient nvarchar(32)
CompanyName nvarchar(32)
ShippingAddress1 nvarcha r(32)
ShippingAddress2 nvarcha r(32)
ShippingAddress3 nvarcha r(32)
City nvarchar(32)
State nvarchar(32)
Zip nvarchar(32)
Country nvarchar(32)
Notes nvarchar(32)
Manufacturer nvarchar(32)
ProductName nvarchar(32)
Version nvarchar(32)
ProductType nvarchar(32)
LicensesPerPackage nvarchar(32)
ResellerSKU nvarchar(32)
MfrPartNum nvarchar(32)
Upgrade nvarchar(32)
PurchaseQty nvarchar(32)
SerialNum nvarchar(32)
Site nvarchar(32)
Department nvarchar(32)
CostCenter nvarchar(32)
Comments nvarchar(32)
UnitMSRP nvarchar(32)
UnitPrice nvarchar(32)
ExtendedPrice nvarchar(32)
ExpDate nvarchar(32)
LC_SuiteComponent
PK ComponentOID binary(16)
FK3,I2 TallyProductOID binary(16)
FK1,I1 SuiteComponentOID binary(16)
FK2,I3 SuiteProductOID binary(16)
LC_WorkstationAllocati on
PK AllocationOID binary(16)
FK1,I1 LicenseOID binary(16)
Qty int
DuplicateAllocation ti nyint
InstalledQty int
®
ZENworks 10 Configuration Management SP2
Software / Contract Manageme nt – 05/2009
Notice: Details about the ZENworks data base
schema are provided for refer ence 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 expres s written consent
of the publisher.
LC_CollComponent
PK ZUID binary(16)
FK1,U2,U3,I1,U1,U5,U4 MemberComponentOID binary(16)
FK4,I3 MemberProductOID binary(16)
FK2,U2,U3,I2,U1,U5,U4 ParentComponentOID binary(16)
FK3,I4 ParentProductOID binary(16)
LC_Contract
PK,FK7 ZUID binary(16)
FK1,I2 ParentContractOID binary(16)
U4,U5,U1,U2,U7,U3,U6 AdminContractID nvarchar(64)
ContractName nvarchar(64)
Description nvarchar(255)
ContractType nvarchar(32)
ContractStatus nvarchar(32)
ProgramName nvarchar(255)
TotalCost numeric(19,2)
InternalContactName nvarchar( 64)
InternalContactPhone nva rchar(16)
InternalContactEmail nva rchar(64)
StartDate datetime
EndDate datetime
Evergreen tinyint
NoticeDescription nvarchar( 255)
NoticeDate datetime
TimeRemaining numeric(19,0)
RenewalOption tinyint
RenewalProvision nvarchar( 255)
KeyTerms nvarchar(255)
VendorContractID nvarchar( 32)
FK6,I6 VendorOID binary(16)
FK3,I3 StartDateNotifOID binary (16)
FK4,I4 EndDateNotifOID binary( 16)
FK5,I1 NoticeDateNotifOID binary(16)
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)
FK2,I5 LeaseOID binary(16)
LC_ContractDocumentMap
PK ZUID binary(16)
FK1,U3,U2,U1,I1,U5,U4 Co ntractOID binary(16)
FK2,U3,U2,U1,I2,U5,U4 DocumentOID binary(16)
AttachedBy nvarchar(64)
DateAttached datetime
LC_ContractNetworkDevic eMap
PK ZUID binary(16)
FK1,U2,U3,U1,I2,U5,U4 Co ntractOID binary(16)
U2,U3,U1,I1,U5,U4 NetworkDevice OID binary(16)
LC_ContractOrgUnitAsso c
PK ZUID binary(16)
FK1,U3,U2,I1,U1,U5,U4 ContractOID binary(16)
U3,U2,U1,U5,U4 OUType smalli nt
U3,U2,U1,U5,U4 OUValue nvarc har(32)
LC_ContractUserMap
PK ZUID binary(16)
FK1,U2,U1,I1,U4,U3 ContractOID binary(16)
U2,U1,I2,U4,U3 User OID binary(16)
LC_ContractWkstnMap
PK ZUID binary(16)
FK1,U3,U2,U1,I2,U5,U4 ContractOID binary(16)
U3,U2,U1,I1,U5,U4 WorkstationOID binary(16)
LC_Document
PK,FK1 ZUID binary(16)
UserDocID nvarchar(64)
FName nvarchar(256)
FileExt nvarchar(8)
FilePath nvarchar(1024 )
FileLength numeric(19,0)
ServerName nvarchar(128)
FileDate datetime
UploadDate datetime
UploadedBy nvarchar(64)
Description nvarchar(255)
FileBlob image
LC_Notifications
PK,FK4 ZUID binary(16)
NotificationType smallint
DocumentType smallint
FK1,I2 ContractOID binary(16)
ContractType smallint
FK2,I3 LeaseOID binary(16)
FK3,I1 ServiceLevelAgreementOID binary(16)
NotificationName nvarchar (150)
FieldName nvarchar(65)
FieldLabel nvarchar(64)
DaysPrior int
Status smallint
Recipients ntext
RepeatCount int
Frequency smallint
NotificationsSent int
NotificationFailures int
LastSentDate datetime
NextScheduledDate datetime
AutoDelete smallint
Subject nvarchar(256)
CreateDate datetime
MessageText nvarchar(2048)
Sender nvarchar(128)
Locale nvarchar(10)
LC_NotificationDefaul ts
PK Notificati onDefaultOID binary(16)
DaysPrior int
Recipients ntext
RepeatCount int
Frequency small int
AutoDelete smallint
EmailFrom nvarchar(64)
LC_RenewalHistory
PK RenewalOID binary(16)
FK1,I1 ContractOID binary(16)
DateOfChange datetime
SourceOfChange nvarchar(64)
BeforeEndDate datetime
AfterEndDate datetime
EffectiveDate datetime
Notes nvarchar(512)
LC_ServiceLevelAgreement
PK ServiceLevelAgreem entOID binary(16)
FK1,I3 ContractOID bi nary(16)
DefinedServiceLevel nvarchar (128)
ActualServiceLevel nvarchar(128)
ServiceStartDate datetime
ServiceEndDate datetime
FK2,I1 StartDateNotifOID binary(16)
FK3,I2 EndDateNotifOID binary(16)
PercentMet int
LC_TallyProductColl
PK,FK2 ZUID binary(16)
FK1,U2,U3,U5,U4,U1 Prod uctOID binary(16)
Platform int
Source int
IsTracked int
DateLastModified dat etime
LC_TallyProductCollMap
PK MapOID binary(16)
FK2,I2,U3,U1,U4,U5,U2,U7,U6 ParentProductOID binary(16)
FK1,I1,U3,U1,U4,U5,U2,U7,U6 MemberProductOID binary(16)
IsRequired smallint
LC_Vendor
PK VendorOID binary(16)
VendorName nvarchar(64)
AdminVendorID nvarchar(64)
AccountNumber nvarchar(64)
PriContactName nvarchar(64)
PriContactPhone nvarchar(32 )
PriContactEmail nvarchar(32)
SecContactName nvarchar(64)
SecContactPhone nvarchar(32 )
SecContactEmail nvarchar(32 )
LC_Lease
PK LeaseOID binary(16)
DateOrdered datetime
DateShipped datetime
DateDelivered datetime
DateSignedFor datetime
DateInspected datetime
DateAccepted datetime
DeliveryProcedures nvarchar(255)
ReturnObligations nvarchar(255)
RightsToRelocate nvarchar(255)
DefaultsAndRemedies nvarchar(2 55)
InsuranceProvisions nvarchar(255)
InsuranceAmount numeric(19,2)
ModificationProvisions nvarchar(255)
PurchaseOption nvarchar(255)
EndOfLeaseProvisions nvarchar(2 55)
PrevailingLaw nvarchar(255)
FK1,I4 DateOrderedNotifOID binary(16)
FK2,I5 DateShippedNotifOID binary(16)
FK3,I1 DateDeliveredNotifOID binary(16)
FK4,I6 DateSignedNotifO ID binary(16)
FK5,I2 DateIns pectedNotifOID binary(16 )
FK6,I3 DateAcce ptedNotifOID binary(16)
LC_CalculatedCompliance
PK ZUID binary(16)
FK1,I1 LicenseOID binary(16)
CalculationType smallint
VersionsCovered nvarchar(1024)
LicenseQty int
QtyConsumed int
FK2,I2 EntitlementUI D binary(16)
LC_ChangeLog
PK ZUID binary(16)
DateChanged datetime
ChangedBy nvarchar(64)
QuantityBefore int
QuantityAfter int
DescriptionBefore nvarchar(256)
DescriptionAfter nvarchar(256)
LC_ChangeLogEntMap
PK ZUID binary(16)
FK2,I1 EntitlementUID b inary(16)
FK1,I2 ChangeLogUID binary(16)
LC_ChangeLogSPMap
PK ZUID binary(16)
FK2,I1 Summar yPurchaseUID binary(16)
FK1,I2 ChangeLogUID binary(16)
LC_ComplianceEngineLog
PK ZUID binary(16)
StartTime datetime
FinishTime datetime
LastModifiedTime datetime
Status smallint
Source smallint
StartedBy nvarchar(64)
LicensesToDo int
LicensesDone int
FK1,I1 LicenseOID binary(16)
Comments nvarchar(256)
LC_ContractEntitlementMa p
PK ZUID binary(16)
FK1,I2 ContractOID binary(16)
FK2,I1 EntitlementUID binary(16)
LC_DemographicAllocatio n
PK AllocationOID binary(16)
FK1,I1 LicenseOID binary(16)
Type smallint
Unit nvarchar(32)
Qty int
WorkstationQty int
InstalledQty int
VarianceQty int
LC_Entitlement
PK ZUID binary(16)
FK2,I1 LicenseOID binary(16)
FK1,I2 UpgradeFrom binary(16)
LicenseModel smallint
LicenseModelName nvarchar(64)
LicenseQty int
Description nvarchar(256)
Platform nvarchar(64)
Type smallint
LicensePeriod smallint
StartDate datetime
EndDate datetime
Notes nvarchar(256)
QtyUpgraded int
QtyAvailable int
QtyConsumed int
Status smallint
VMUseRights nvarchar(256)
LC_EntitlementDocumentMap
PK ZUID binary(16)
FK2,I2 EntitlementUID binary(16)
FK1,I1 DocumentOID binary(16)
attachedBy nvarchar(64)
dateAttached datetime
LC_EntitlementToTPMap
PK MapOID binary(16)
FK1,I2 EntitlementUID binary(16)
FK2,I1 TallyProductOID binary(16)
LC_MachinesCovered
PK ZUID binary(16)
FK1,I1 EntitlementUID binary(16)
WorkstationOID binary(16)
MachineName nvarchar(32)
SerialNumber nvarchar(38)
IsDeleted tinyint
IsInstalled tinyint
IsLicenseConsumed tinyint
IsRetired tinyint
LC_SummaryPurchase
PK ZUID binary(16)
FK1,I1 Entitl ementUID binary(16)
Description nvarchar( 256)
LicenseQty int
DateEntered datetime
EnteredBy nvarchar(64)
Notes nvarchar(256)
TotalCost numeric(19,2)
LC_SummaryPurchaseDocumentMap
PK ZUID binary(16)
FK2,I1 SummaryPu rchaseUID binary(16)
FK1,I2 DocumentOID binary(16)
attachedBy nvarchar(64)
dateAttached datetime
LC_TallyProductExten sion
PK DpExtensionUID binary(16)
FK2,U2,U1,U5,U4,U3 TallyProductOID binary(16)
I2 ExcludedByUser tinyint
UndiscoveredQty int
Notes nvarchar(255)
FK1,I1 DpStandardsUID binary(16)
LC_EntitlementToPPMap
PK MapOID binary(16)
FK2,U1,U5,U3,U4,U2 Purchas edProductOID binary(16)
FK1,I1 EntitlementUID binary(16)
LC_AllocationsVsIn stallations
PK ZUID binary(16)
FK1,I1 LicenseOID binary(16)
TotalInstQty int
DemographicInstQty int
WorkstationInstQty int
UnallocatedInstQty int
TotalOverAllocQty int
TotalUnderAllocQty int
DemoOverAllocQty int
DemoUnderAllocQty int
WkstnOverAllocQty int
LC_ComplianceInstCountD emog
PK ZUID binary(16)
FK1,I1 LicenseOID binary(16)
CostCenter nvarchar(32)
Department nvarchar(32)
Site nvarchar(32)
InstalledQty int
IgnoredQty int
UndiscoveredQty int
LC_ComplianceDemographics
PK ZUID bin ary(16)
FK1,I1 LicenseOID binary(16)
CostCenter nvarchar(32)
Department nvarchar(32)
Site nvarchar(32)
Source smallint
LicenseQty int
AllocatedQty int
InstalledQty int
QtyConsumed int
OverLicensedQty int
UnderLicensedQty int
LC_ComplianceLicCountDemog
PK ZUID binary(16)
FK1,I1 LicenseOID binary(16)
CostCenter nvarchar(32)
Department nvarchar(32)
Site nvarchar(32)
Source smallint
LicenseQty int
AllocatedQty int
3