Compliance.Logic.Licensing Tables

The complete set of database tables documented here includes:

• AccessEvidence table (see AccessEvidence Table)
• AccessEvidenceEx table (see AccessEvidenceEx Table)
• AccessEvidenceMatchCount table (see AccessEvidenceMatchCount Table)
• AccessMode table (see AccessMode Table)
• AccessedSoftware table (see AccessedSoftware Table)
• AccessedSoftwareDeviceAssignmentReasons table (see AccessedSoftwareDeviceAssignmentReasons Table)
• AccessedSoftwareOccurrence table (see AccessedSoftwareOccurrence Table)
• AccessedSoftwareUserAssignmentReasons table (see AccessedSoftwareUserAssignmentReasons Table)
• AccessingDevice table (see AccessingDevice Table)
• AccessingDeviceSnapshot table (see AccessingDeviceSnapshot Table)
• AccessingUser table (see AccessingUser Table)
• AccessingUserSnapshot table (see AccessingUserSnapshot Table)
• AssignmentStatus table (see AssignmentStatus Table)
• AssignmentStatusFailureReasonMapping table (see AssignmentStatusFailureReasonMapping Table)
• CitrixRemoteEvidenceMapping table (see CitrixRemoteEvidenceMapping Table)
• ClientAccessSourceType table (see ClientAccessSourceType Table)
• ClientAccessedAccessEvidence table (see ClientAccessedAccessEvidence Table)
• ClientAccessedAccessOccurrence table (see ClientAccessedAccessOccurrence Table)
• Cluster table (see Cluster Table)
• ClusterComputer table (see ClusterComputer Table)
• ClusterHostAffinityRule table (see ClusterHostAffinityRule Table)
• ClusterHostAffinityRuleType table (see ClusterHostAffinityRuleType Table)
• ClusterNodeType table (see ClusterNodeType Table)
• ClusterType table (see ClusterType Table)
• ComplianceComputerSnapshot table (see ComplianceComputerSnapshot Table)
• ComplianceComputerTag table (see ComplianceComputerTag Table)
• ComplianceOperatorDashboard table (see ComplianceOperatorDashboard Table)
• ComplianceOperatorDashboardWidget table (see ComplianceOperatorDashboardWidget Table)
• ComplianceUserSnapshot table (see ComplianceUserSnapshot Table)
• ComplianceUserTag table (see ComplianceUserTag Table)
• DashboardTemplate table (see DashboardTemplate Table)
• DashboardTemplateWidget table (see DashboardTemplateWidget Table)
• DashboardWidget table (see DashboardWidget Table)
• DatabaseMutex table (see DatabaseMutex Table)
• EndOfSupportLife table (see EndOfSupportLife Table)
• EndOfSupportLifeName table (see EndOfSupportLifeName Table)
• EntitlementRecommendation table (see EntitlementRecommendation Table)
• EntitlementRecommendationState table (see EntitlementRecommendationState Table)
• EntitlementTransaction table (see EntitlementTransaction Table)
• EntitlementTransactionOtherCandidate table (see EntitlementTransactionOtherCandidate Table)
• EntitlementTransactionState table (see EntitlementTransactionState Table)
• EntitlementTransactionType table (see EntitlementTransactionType Table)
• EvidenceExistenceRule table (see EvidenceExistenceRule Table)
• EvidenceStatus table (see EvidenceStatus Table)
• FNMEAFeature table (see FNMEAFeature Table)
• FNMEALicensedFeature table (see FNMEALicensedFeature Table)
• FileEvidenceCompany table (see FileEvidenceCompany Table)
• FileEvidenceEx table (see FileEvidenceEx Table)
• FileEvidenceExemptionMapping table (see FileEvidenceExemptionMapping Table)
• FileEvidenceExemptionPattern table (see FileEvidenceExemptionPattern Table)
• FileEvidenceFile table (see FileEvidenceFile Table)
• FileEvidenceLanguage table (see FileEvidenceLanguage Table)
• FileEvidenceMatchCount table (see FileEvidenceMatchCount Table)
• FileEvidencePath table (see FileEvidencePath Table)
• GroupSnapshot table (see GroupSnapshot Table)
• IBMLicenseServiceBundledProductData table (see IBMLicenseServiceBundledProductData Table)
• IBMLicenseServiceProductData table (see IBMLicenseServiceProductData Table)
• ImporterRun table (see ImporterRun Table)
• ImporterStepValidationIssue table (see ImporterStepValidationIssue Table)
• ImporterStepValidationIssueType table (see ImporterStepValidationIssueType Table)
• InstalledFileEvidence table (see InstalledFileEvidence Table)
• InstalledFileEvidenceAttribute table (see InstalledFileEvidenceAttribute Table)
• InstalledFileEvidenceDetail table (see InstalledFileEvidenceDetail Table)
• InstalledInstallerAttribute table (see InstalledInstallerAttribute Table)
• InstalledInstallerEvidence table (see InstalledInstallerEvidence Table)
• InstalledInstallerEvidenceDetail table (see InstalledInstallerEvidenceDetail Table)
• InstalledInstanceReplacement table (see InstalledInstanceReplacement Table)
• InstalledJavaEvidenceDetail table (see InstalledJavaEvidenceDetail Table)
• InstalledSoftwareData table (see InstalledSoftwareData Table)
• InstalledSoftwareFilePathExemption table (see InstalledSoftwareFilePathExemption Table)
• InstalledSoftwareRemoval table (see InstalledSoftwareRemoval Table)
• InstalledSoftwareReplacement table (see InstalledSoftwareReplacement Table)
• InstalledSoftwareUsageData table (see InstalledSoftwareUsageData Table)
• InstalledWMIEvidence table (see InstalledWMIEvidence Table)
• InstallerEvidence table (see InstallerEvidence Table)
• InstallerEvidenceEx table (see InstallerEvidenceEx Table)
• InstallerEvidenceMatchCount table (see InstallerEvidenceMatchCount Table)
• InstallerEvidenceType table (see InstallerEvidenceType Table)
• InstdSWAssignmentReasons table (see InstdSWAssignmentReasons Table)
• LicenseAssignmentConsumptionReason table (see LicenseAssignmentConsumptionReason Table)
• LicenseAssignmentFailureReason table (see LicenseAssignmentFailureReason Table)
• LicenseBreachReason table (see LicenseBreachReason Table)
• LicenseDefinitionTitle table (see LicenseDefinitionTitle Table)
• LicenseDefinitionType table (see LicenseDefinitionType Table)
• LicenseDefinitionUsageRight table (see LicenseDefinitionUsageRight Table)
• LicenseMeasurement table (see LicenseMeasurement Table)
• LicenseSimulation table (see LicenseSimulation Table)
• LicenseSimulationBreachStatus table (see LicenseSimulationBreachStatus Table)
• LicenseSimulationChangeType table (see LicenseSimulationChangeType Table)
• LicenseSimulationHWDetails table (see LicenseSimulationHWDetails Table)
• LicenseSimulationLicenseDetails table (see LicenseSimulationLicenseDetails Table)
• LicenseSimulationResults table (see LicenseSimulationResults Table)
• LicenseSimulationRowType table (see LicenseSimulationRowType Table)
• LicenseSimulationSWDetails table (see LicenseSimulationSWDetails Table)
• LicenseSimulationScenario table (see LicenseSimulationScenario Table)
• LicenseStatus table (see LicenseStatus Table)
• NewFileEvidence table (see NewFileEvidence Table)
• OracleLegacyLicenseType table (see OracleLegacyLicenseType Table)
• PODetailProcess table (see PODetailProcess Table)
• PVUSoftwareLicenseProcessorData table (see PVUSoftwareLicenseProcessorData Table)
• PVUVirtualMachineLayer table (see PVUVirtualMachineLayer Table)
• PeriodType table (see PeriodType Table)
• ProcessAction table (see ProcessAction Table)
• ProcessState table (see ProcessState Table)
• ReconcileAccdSWDevAsgnReasons table (see ReconcileAccdSWDevAsgnReasons Table)
• ReconcileAccdSWUsrAsgnReasons table (see ReconcileAccdSWUsrAsgnReasons Table)
• ReconcileAccessedSoftwareData table (see ReconcileAccessedSoftwareData Table)
• ReconcileCloudServiceApplicationWithByol table (see ReconcileCloudServiceApplicationWithByol Table)
• ReconcileIBMLicenseServiceBundledProductData table (see ReconcileIBMLicenseServiceBundledProductData Table)
• ReconcileIBMLicenseServiceProductData table (see ReconcileIBMLicenseServiceProductData Table)
• ReconcileIBMLicenseServiceProducts table (see ReconcileIBMLicenseServiceProducts Table)
• ReconcileInstalledSoftwareData table (see ReconcileInstalledSoftwareData Table)
• ReconcileInstalledSoftwareUsageData table (see ReconcileInstalledSoftwareUsageData Table)
• ReconcileInstdSWAssignmentReasons table (see ReconcileInstdSWAssignmentReasons Table)
• ReconcileInterestingBundleAccessComputer table (see ReconcileInterestingBundleAccessComputer Table)
• ReconcileInterestingBundleInstallComputer table (see ReconcileInterestingBundleInstallComputer Table)
• ReconcileInterestingLicenses table (see ReconcileInterestingLicenses Table)
• ReconcileInterestingTitles table (see ReconcileInterestingTitles Table)
• ReconcileSoftwareAccessDeviceLicensePointsConsumedData table (see ReconcileSoftwareAccessDeviceLicensePointsConsumedData Table)
• ReconcileSoftwareAccessUserLicensePointsConsumedData table (see ReconcileSoftwareAccessUserLicensePointsConsumedData Table)
• ReconcileSoftwareLicenseComputerProblem table (see ReconcileSoftwareLicenseComputerProblem Table)
• ReconcileSoftwareLicenseCoresConsumedData table (see ReconcileSoftwareLicenseCoresConsumedData Table)
• ReconcileSoftwareLicenseGroupPointsConsumedData table (see ReconcileSoftwareLicenseGroupPointsConsumedData Table)
• ReconcileSoftwareLicenseILMTPointsConsumedData table (see ReconcileSoftwareLicenseILMTPointsConsumedData Table)
• ReconcileSoftwareLicensePointsConsumedData table (see ReconcileSoftwareLicensePointsConsumedData Table)
• ReconcileSoftwareLicensePointsConsumedReason table (see ReconcileSoftwareLicensePointsConsumedReason Table)
• ReconcileSoftwareLicenseProcessorData table (see ReconcileSoftwareLicenseProcessorData Table)
• ReconcileSoftwareLicenseSecondUseMappingData table (see ReconcileSoftwareLicenseSecondUseMappingData Table)
• ReconcileSoftwareUserLicensePointsConsumedData table (see ReconcileSoftwareUserLicensePointsConsumedData Table)
• ReconcileVirtualMachineLayer table (see ReconcileVirtualMachineLayer Table)
• RegistryEvidence table (see RegistryEvidence Table)
• RegistryEvidenceHive table (see RegistryEvidenceHive Table)
• RegistryEvidenceKey table (see RegistryEvidenceKey Table)
• RegistryEvidenceValue table (see RegistryEvidenceValue Table)
• RelatedInstalledInstallerEvidence table (see RelatedInstalledInstallerEvidence Table)
• RelatedInstalledInstallerEvidenceSourceMap table (see RelatedInstalledInstallerEvidenceSourceMap Table)
• RelatedInstalledSoftwareData table (see RelatedInstalledSoftwareData Table)
• RemoteUserSIDMembers table (see RemoteUserSIDMembers Table)
• SAPSoftwareLicense table (see SAPSoftwareLicense Table)
• SAPSoftwareLicenseType table (see SAPSoftwareLicenseType Table)
• SAPSpecialVersion table (see SAPSpecialVersion Table)
• ScopingGroup table (see ScopingGroup Table)
• ScopingGroupComplianceSavedSearch table (see ScopingGroupComplianceSavedSearch Table)
• ScopingGroupMember table (see ScopingGroupMember Table)
• ScopingGroupReason table (see ScopingGroupReason Table)
• ScopingGroupType table (see ScopingGroupType Table)
• ServicePack table (see ServicePack Table)
• ServicePackName table (see ServicePackName Table)
• Simulation table (see Simulation Table)
• SimulationComputer table (see SimulationComputer Table)
• SimulationLicenseResult table (see SimulationLicenseResult Table)
• SimulationRun table (see SimulationRun Table)
• SimulationStatus table (see SimulationStatus Table)
• SoftwareAccessDeviceLicensePointsConsumedData table (see SoftwareAccessDeviceLicensePointsConsumedData Table)
• SoftwareAccessMode table (see SoftwareAccessMode Table)
• SoftwareAccessUserLicensePointsConsumedData table (see SoftwareAccessUserLicensePointsConsumedData Table)
• SoftwareLicense table (see SoftwareLicense Table)
• SoftwareLicenseAllocation table (see SoftwareLicenseAllocation Table)
• SoftwareLicenseAllocationStatus table (see SoftwareLicenseAllocationStatus Table)
• SoftwareLicenseAllocationUserType table (see SoftwareLicenseAllocationUserType Table)
• SoftwareLicenseBreachReasonData table (see SoftwareLicenseBreachReasonData Table)
• SoftwareLicenseChangeEvent table (see SoftwareLicenseChangeEvent Table)
• SoftwareLicenseChangeEventReason table (see SoftwareLicenseChangeEventReason Table)
• SoftwareLicenseChangeEventSource table (see SoftwareLicenseChangeEventSource Table)
• SoftwareLicenseCloudServiceProvider table (see SoftwareLicenseCloudServiceProvider Table)
• SoftwareLicenseComplianceStatus table (see SoftwareLicenseComplianceStatus Table)
• SoftwareLicenseComputerProblemData table (see SoftwareLicenseComputerProblemData Table)
• SoftwareLicenseComputerProblemType table (see SoftwareLicenseComputerProblemType Table)
• SoftwareLicenseConnection table (see SoftwareLicenseConnection Table)
• SoftwareLicenseContract table (see SoftwareLicenseContract Table)
• SoftwareLicenseCoresConsumedData table (see SoftwareLicenseCoresConsumedData Table)
• SoftwareLicenseCreation table (see SoftwareLicenseCreation Table)
• SoftwareLicenseDefinition table (see SoftwareLicenseDefinition Table)
• SoftwareLicenseDuration table (see SoftwareLicenseDuration Table)
• SoftwareLicenseExemptionReason table (see SoftwareLicenseExemptionReason Table)
• SoftwareLicenseExemptionRole table (see SoftwareLicenseExemptionRole Table)
• SoftwareLicenseGroupAllocationReportingType table (see SoftwareLicenseGroupAllocationReportingType Table)
• SoftwareLicenseGroupAssignmentHistory table (see SoftwareLicenseGroupAssignmentHistory Table)
• SoftwareLicenseGroupAssignmentHistoryType table (see SoftwareLicenseGroupAssignmentHistoryType Table)
• SoftwareLicenseGroupBreachStatus table (see SoftwareLicenseGroupBreachStatus Table)
• SoftwareLicenseGroupPointsConsumedData table (see SoftwareLicenseGroupPointsConsumedData Table)
• SoftwareLicenseILMTPointsConsumedData table (see SoftwareLicenseILMTPointsConsumedData Table)
• SoftwareLicenseKey table (see SoftwareLicenseKey Table)
• SoftwareLicenseKeyType table (see SoftwareLicenseKeyType Table)
• SoftwareLicenseMetric table (see SoftwareLicenseMetric Table)
• SoftwareLicensePVUPointsConsumedComputersSCD table (see SoftwareLicensePVUPointsConsumedComputersSCD Table)
• SoftwareLicensePVUPointsConsumedPerClusterSCD table (see SoftwareLicensePVUPointsConsumedPerClusterSCD Table)
• SoftwareLicensePVUPointsConsumedPerHostSCD table (see SoftwareLicensePVUPointsConsumedPerHostSCD Table)
• SoftwareLicensePVUPointsConsumedPerProductSCD table (see SoftwareLicensePVUPointsConsumedPerProductSCD Table)
• SoftwareLicensePVUPointsConsumedPerRegionSCD table (see SoftwareLicensePVUPointsConsumedPerRegionSCD Table)
• SoftwareLicensePVUPointsConsumedPoolsSCD table (see SoftwareLicensePVUPointsConsumedPoolsSCD Table)
• SoftwareLicensePVUPointsPeakConsumedData table (see SoftwareLicensePVUPointsPeakConsumedData Table)
• SoftwareLicensePVURegionPeakCalculatedData table (see SoftwareLicensePVURegionPeakCalculatedData Table)
• SoftwareLicensePartitioningDefault table (see SoftwareLicensePartitioningDefault Table)
• SoftwareLicensePoints table (see SoftwareLicensePoints Table)
• SoftwareLicensePointsConsumedData table (see SoftwareLicensePointsConsumedData Table)
• SoftwareLicensePointsConsumedReasonData table (see SoftwareLicensePointsConsumedReasonData Table)
• SoftwareLicensePointsConsumedReasonType table (see SoftwareLicensePointsConsumedReasonType Table)
• SoftwareLicensePointsDefault table (see SoftwareLicensePointsDefault Table)
• SoftwareLicensePointsRule table (see SoftwareLicensePointsRule Table)
• SoftwareLicensePointsRuleCloudServiceProvider table (see SoftwareLicensePointsRuleCloudServiceProvider Table)
• SoftwareLicensePointsRuleSet table (see SoftwareLicensePointsRuleSet Table)
• SoftwareLicensePointsRuleSoftwareTitle table (see SoftwareLicensePointsRuleSoftwareTitle Table)
• SoftwareLicenseProcessorPointsData table (see SoftwareLicenseProcessorPointsData Table)
• SoftwareLicenseProduct table (see SoftwareLicenseProduct Table)
• SoftwareLicensePropertyValue table (see SoftwareLicensePropertyValue Table)
• SoftwareLicenseProposalStatus table (see SoftwareLicenseProposalStatus Table)
• SoftwareLicensePurchaseType table (see SoftwareLicensePurchaseType Table)
• SoftwareLicenseReservation table (see SoftwareLicenseReservation Table)
• SoftwareLicenseReservationNecessityCheckResult table (see SoftwareLicenseReservationNecessityCheckResult Table)
• SoftwareLicenseReservationStatus table (see SoftwareLicenseReservationStatus Table)
• SoftwareLicenseReservationType table (see SoftwareLicenseReservationType Table)
• SoftwareLicenseScopeTag table (see SoftwareLicenseScopeTag Table)
• SoftwareLicenseScopeTagType table (see SoftwareLicenseScopeTagType Table)
• SoftwareLicenseScoping table (see SoftwareLicenseScoping Table)
• SoftwareLicenseScopingGroup table (see SoftwareLicenseScopingGroup Table)
• SoftwareLicenseSecondUseMappingData table (see SoftwareLicenseSecondUseMappingData Table)
• SoftwareLicenseSnapshot table (see SoftwareLicenseSnapshot Table)
• SoftwareLicenseTierType table (see SoftwareLicenseTierType Table)
• SoftwareLicenseType table (see SoftwareLicenseType Table)
• SoftwareLicenseTypeChangeProposal table (see SoftwareLicenseTypeChangeProposal Table)
• SoftwareLicenseTypeCloudServiceProviderDefault table (see SoftwareLicenseTypeCloudServiceProviderDefault Table)
• SoftwareLicenseTypePriority table (see SoftwareLicenseTypePriority Table)
• SoftwareLicenseTypeProperty table (see SoftwareLicenseTypeProperty Table)
• SoftwareLicenseUseRight table (see SoftwareLicenseUseRight Table)
• SoftwareLicenseUseRightIBM table (see SoftwareLicenseUseRightIBM Table)
• SoftwareLicenseUseRightName table (see SoftwareLicenseUseRightName Table)
• SoftwareLicenseUseRightProposal table (see SoftwareLicenseUseRightProposal Table)
• SoftwareLifeCycle table (see SoftwareLifeCycle Table)
• SoftwareRecognition table (see SoftwareRecognition Table)
• SoftwareSKULookup table (see SoftwareSKULookup Table)
• SoftwareSku table (see SoftwareSku Table)
• SoftwareTitle table (see SoftwareTitle Table)
• SoftwareTitleAccessEvidence table (see SoftwareTitleAccessEvidence Table)
• SoftwareTitleAction table (see SoftwareTitleAction Table)
• SoftwareTitleClassification table (see SoftwareTitleClassification Table)
• SoftwareTitleEOSL table (see SoftwareTitleEOSL Table)
• SoftwareTitleEdition table (see SoftwareTitleEdition Table)
• SoftwareTitleEligibleForByol table (see SoftwareTitleEligibleForByol Table)
• SoftwareTitleEx table (see SoftwareTitleEx Table)
• SoftwareTitleFileEvidence table (see SoftwareTitleFileEvidence Table)
• SoftwareTitleHierarchy table (see SoftwareTitleHierarchy Table)
• SoftwareTitleHierarchyEx table (see SoftwareTitleHierarchyEx Table)
• SoftwareTitleInstallerEvidence table (see SoftwareTitleInstallerEvidence Table)
• SoftwareTitleLicense table (see SoftwareTitleLicense Table)
• SoftwareTitleLicenseProposal table (see SoftwareTitleLicenseProposal Table)
• SoftwareTitleLicenseProposalAction table (see SoftwareTitleLicenseProposalAction Table)
• SoftwareTitleLicenseReason table (see SoftwareTitleLicenseReason Table)
• SoftwareTitleOracle table (see SoftwareTitleOracle Table)
• SoftwareTitleProduct table (see SoftwareTitleProduct Table)
• SoftwareTitleProperty table (see SoftwareTitleProperty Table)
• SoftwareTitlePropertyValue table (see SoftwareTitlePropertyValue Table)
• SoftwareTitlePublisher table (see SoftwareTitlePublisher Table)
• SoftwareTitleRegistryEvidence table (see SoftwareTitleRegistryEvidence Table)
• SoftwareTitleSuite table (see SoftwareTitleSuite Table)
• SoftwareTitleSuiteEx table (see SoftwareTitleSuiteEx Table)
• SoftwareTitleType table (see SoftwareTitleType Table)
• SoftwareTitleVersion table (see SoftwareTitleVersion Table)
• SoftwareTitleVersionServicePack table (see SoftwareTitleVersionServicePack Table)
• SoftwareTitleWMIEvidence table (see SoftwareTitleWMIEvidence Table)
• SoftwareUserLicensePointsConsumedData table (see SoftwareUserLicensePointsConsumedData Table)
• SoftwareUserLicensePointsConsumedSuggested table (see SoftwareUserLicensePointsConsumedSuggested Table)
• SoftwareUserLicensePointsConsumedSuggestedHistory table (see SoftwareUserLicensePointsConsumedSuggestedHistory Table)
• SoftwareUserLicensePointsHistory table (see SoftwareUserLicensePointsHistory Table)
• Tag table (see Tag Table)
• TargetOperatingSystemType table (see TargetOperatingSystemType Table)
• TechnopediaProductReleaseInfo table (see TechnopediaProductReleaseInfo Table)
• TemporalInstalledSoftwareSCD table (see TemporalInstalledSoftwareSCD Table)
• VDI table (see VDI Table)
• VDIEndPointAccess table (see VDIEndPointAccess Table)
• VDIGroup table (see VDIGroup Table)
• VDIGroupADGroup table (see VDIGroupADGroup Table)
• VDISite table (see VDISite Table)
• VDITemplate table (see VDITemplate Table)
• VDITemplateToDeviceMapping table (see VDITemplateToDeviceMapping Table)
• VDIUser table (see VDIUser Table)
• VDIUserConnection table (see VDIUserConnection Table)
• WMIEvidence table (see WMIEvidence Table)
• WMIEvidenceMatchCount table (see WMIEvidenceMatchCount Table)