Database Schema Changes 26.1.x

+ More

Table of Contents

Version 26.1.x 26.1.0.3097 Deleted Tables Added Tables Deleted Columns Changed Columns Added Columns

Version 26.1.x

26.1.0.3097

Deleted Tables

Table	Column
`SchemaRelation-SCIApplicationClass2SCITagClass`	`Applications`
	`ID`
	`Tags`
	`TimeStamp`
`SchemaRelation-SCIContractClass2SCITagClass`	`Contracts`
	`ID`
	`Tags`
	`TimeStamp`
`SchemaRelation-SCIExpensesClass2SCITagClass`	`Expenses`
	`ID`
	`Tags`
	`TimeStamp`
`SchemaRelation-SCILicenseClass2SCITagClass`	`ID`
	`Licenses`
	`Tags`
	`TimeStamp`
`SchemaRelation-SCIUserClass2SCITagClass`	`ID`
	`Tags`
	`TimeStamp`
	`Users`
`SCIApplicationClassUsages`	`Expression-ObjectID`
	`ID`
	`Sources`
	`SyncDate`
	`TimeStamp`
	`UsageDate`
	`UsageDateKey`
	`UsedInTypeSCIApplicationType`
	`User`
`SCIContractClass`	`AllLicenseActiveUsersCount`
	`Application`
	`AutoRenewal`
	`Expression-ObjectID`
	`ID`
	`Name`
	`NoticeDate`
	`PaymentTerm`
	`RenewalDate`
	`SourceID`
	`Status`
	`SyncDate`
	`TimeStamp`
	`UsedInTypeSCIContractType`
	`YearlyCost`
	`YearlyCost__CC`
`SCIContractType`	`ID`
	`TimeStamp`
`SCIExpensesClass`	`Amount`
	`AmountCurrency`
	`Application`
	`Description`
	`Expression-ObjectID`
	`ID`
	`MatchedBy`
	`SourceID`
	`SourceTransactionId`
	`Status`
	`SyncDate`
	`TimeStamp`
	`UsedInTypeSCIExpensesType`
`SCIExpensesType`	`ID`
	`TimeStamp`
`SCITagClass`	`AppCount`
	`Description`
	`Expression-ObjectID`
	`FirstLevelParentLabel`
	`ID`
	`Label`
	`Name`
	`ParentLabel`
	`Priority`
	`SourceID`
	`SourceParentId`
	`Status`
	`SyncDate`
	`TimeStamp`
	`UsedInTypeSCITagType`
	`UserCount`
`SCITagType`	`ID`
	`TimeStamp`
`SCIUserClass`	`Emails`
	`Expression-ObjectID`
	`ID`
	`LastActivity`
	`Name`
	`Person`
	`SourceID`
	`Status`
	`SyncDate`
	`TimeStamp`
	`UsedInTypeSCIUserType`
	`VendorsDetected`
	`VendorsUsed`
	`YearlyCost`
	`YearlyCost__CC`
`SCIUserClassApplicationUsage`	`Application`
	`Expression-ObjectID`
	`ID`
	`LastActivity`
	`SyncDate`
	`TimeStamp`
	`Usage30`
	`Usage90`
	`UsageAllTime`
	`UsedInTypeSCIUserType`
`SCIUserClassAssignedLicenses`	`Expression-ObjectID`
	`ID`
	`SaaSLicense`
	`SyncDate`
	`TimeStamp`
	`UsedInTypeSCIUserType`
`SCIUserType`	`ID`
	`TimeStamp`
`TmpDisabledCustomTriggers`	`TableName`
	`TriggerName`
`WorkerQueueStatistics`	`Count`
	`Interval`
	`LastUpdated`
	`TotalTimeSec`

Added Tables

Table	Column
`CatalogTilesPhotoStyleModes`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`CatalogTilesPhotoStyleModes-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`DWPAIFunctionClassBase`	`Description`
	`Expression-ObjectID`
	`ID`
	`Name`
	`PreserveExecutionHistory`
	`TimeStamp`
	`TypeID`
	`Widget`
`DWPAIFunctionClassBase-CI`	`Description`
	`ID`
	`LCID`
	`Name`
	`Owner`
	`TimeStamp`
`DWPAIFunctionClassExecution`	`Executor`
	`Expression-ObjectID`
	`FunctionImplementation`
	`ID`
	`Prompt`
	`RequestedDate`
	`Result`
	`Success`
	`Temperature`
	`TimeStamp`
	`UsedInTypeDWPAIFunctionType`
	`UsedTokens`
`DWPAIFunctionClassImplementation`	`Enabled`
	`Expression-ObjectID`
	`ID`
	`MaxOutputTokens`
	`Model`
	`Priority`
	`Prompt`
	`Service`
	`Temperature`
	`TimeStamp`
	`UsedInTypeDWPAIFunctionType`
`DWPAIFunctionClassParameter`	`EntityName`
	`Expression-ObjectID`
	`FrontendContextProperty`
	`ID`
	`IsArray`
	`Name`
	`Output`
	`TimeStamp`
	`Type`
	`UsedInTypeDWPAIFunctionType`
`DWPAIServiceProviderClassBase`	`Description`
	`Enabled`
	`Expression-ObjectID`
	`ID`
	`Name`
	`Priority`
	`ServiceConnection`
	`ServiceUrl`
	`TimeStamp`
	`Type`
	`TypeID`
`DWPAIServiceProviderClassBase-CI`	`Description`
	`ID`
	`LCID`
	`Name`
	`Owner`
	`TimeStamp`
`DWPAIServiceProviderClassModel`	`Description`
	`Expression-ObjectID`
	`Hidden`
	`ID`
	`Name`
	`Priority`
	`TimeStamp`
	`UsedInTypeDWPAIServiceProviderType`
`DWPAIServiceProviderClassModel-CI`	`Description`
	`ID`
	`LCID`
	`Name`
	`Owner`
	`TimeStamp`
`DWPAIServiceTypePickup`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`DWPAIServiceTypePickup-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`DWPDocumentTemplatePurposePickup`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`DWPDocumentTemplatePurposePickup-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`DWPEmailDescriptorType`	`ID`
	`TimeStamp`
`DWPFileInfoCache`	`DownloadLink`
	`ExpiresOn`
	`FileId`
`DWPFileStorageAccountClassAzureBlob`	`ConnectionString`
	`DownloadLinkLifeTimeHours`
	`Expression-ObjectID`
	`ID`
	`StorageContainer`
	`TimeStamp`
	`UsedInTypeDWPFileStorageAccountTypeAzureBlob`
`DWPFileStorageAccountClassAzureBlobEntraId`	`DownloadLinkLifeTimeHours`
	`Expression-ObjectID`
	`ID`
	`ServiceConnection`
	`StorageAccountName`
	`StorageContainer`
	`TimeStamp`
	`UsedInTypeDWPFileStorageAccountTypeAzureBlobEntraId`
`DWPFileStorageAccountClassMatrix42Cloud`	`DownloadLinkLifeTimeHours`
	`Expression-ObjectID`
	`ID`
	`Region`
	`ServiceConnection`
	`StorageContainer`
	`TimeStamp`
	`UsedInTypeDWPFileStorageAccountTypeMatrix42Cloud`
`DWPFileStoragePickupType`	`Active`
	`CiName`
	`Hidden`
	`ID`
	`Name`
	`TimeStamp`
`DwpGlobalIntelligenceSettings`	`AiFunctionSystemPrompt`
	`Expression-ObjectID`
	`ID`
	`TimeStamp`
	`UsedInTypeSPSGlobalConfigurationType`
`DWPJournalEntryPickupCreationType`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`DWPJournalEntryPickupCreationType-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`DWPWorkerLogClass`	`CorrelationID`
	`ErrorMessage`
	`ExecutionTimeMs`
	`Expression-ObjectID`
	`ID`
	`IsCompleted`
	`Isolated`
	`LastUpdated`
	`PeakCpuPercent`
	`PeakMemoryBytes`
	`ProcessID`
	`ProcessName`
	`ProcessType`
	`TimeStamp`
	`TypeID`
	`WorkerId`
`DWPWorkerPickupFunctionType`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`DWPWorkerPickupFunctionType-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`DWPWorkerQueueStatisticsClass`	`AvgExecTime`
	`Count`
	`ID`
	`Interval`
	`LastUpdated`
	`TimeStamp`
	`TypeID`
	`UsedInType`
`ESMSchedulerLeaderLease`	`IsActive`
	`LastRenewedUtc`
	`LeaseEndUtc`
	`LeaseId`
	`LeaseStartUtc`
	`OwnerId`
	`ResourceName`
	`Version`
`ESMWorkspaceClassBase`	`Activated`
	`CreatedDate`
	`Creator`
	`DefaultCategory`
	`DefaultChangeTemplate`
	`DefaultRole`
	`DefaultSender`
	`Description`
	`Expression-ObjectID`
	`Icon`
	`ID`
	`Lead`
	`TimeStamp`
	`Title`
	`Type`
	`UsedInTypeESMWorkspaceType`
	`Visibility`
`ESMWorkspaceClassBase-CI`	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
	`Title`
`ESMWorkspacePickupType`	`Color`
	`DisplayString`
	`Hidden`
	`ID`
	`Image`
	`Position`
	`TimeStamp`
	`Value`
`ESMWorkspacePickupType-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`ESMWorkspacePickupVisibility`	`Color`
	`DisplayString`
	`Hidden`
	`ID`
	`Image`
	`Position`
	`TimeStamp`
	`Value`
`ESMWorkspacePickupVisibility-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`ESMWorkspaceType`	`ID`
	`TimeStamp`
`GdieImportPendingQueue`	`CreatedAt`
	`ErrorMessage`
	`HeartbeatAt`
	`ID`
	`Params`
	`RequiredCapabilities`
	`Status`
	`Task`
	`TaskId`
	`TimeStamp`
	`TrackingId`
	`Type`
	`TypeID`
	`UpdatedAt`
`GDIEProcessStatus`	`AbortRunningImport`
	`ActionName`
	`ActionPercent`
	`CustomInfo`
	`CustomStatus`
	`ID`
	`ImportLoggerId`
	`LastStep`
	`PartialImport`
	`SequenceId`
	`StartTime`
	`Status`
	`TimeElapsed`
	`TimeStamp`
	`TypeID`
`LCMEffectiveLicensePositionDetail`	`Expression-ObjectID`
	`ID`
	`License`
	`Software`
	`TimeStamp`
	`TypeID`
	`UsedCount`
`LCMEffectiveLicensePositionTotal`	`AvailableCount`
	`ID`
	`License`
	`PurchasedCount`
	`RemainingCount`
	`Software`
	`TimeStamp`
	`UsedCount`
`LCMReportLicenseModelClassBase`	`Expression-ObjectID`
	`FKID`
	`ID`
	`Name`
	`TimeStamp`
	`TypeID`
`LCMReportOrgUnitClassBase`	`Expression-ObjectID`
	`FKID`
	`FullHierarchicalName`
	`ID`
	`Name`
	`ParentFKID`
	`ShortHierarchicalName`
	`TimeStamp`
	`TypeID`
`LCMReportSoftwareClassBase`	`Expression-ObjectID`
	`FKID`
	`ID`
	`Name`
	`ProductFamily`
	`ProductGroup`
	`Publisher`
	`SoftwareProduct`
	`TimeStamp`
	`TypeID`
	`Version`
`LCMReportSoftwareProductClassBase`	`Expression-ObjectID`
	`ID`
	`Name`
	`Publisher`
	`TimeStamp`
	`TypeID`
`LCMSoftwareReportClassCompliancePerOU`	`Active`
	`AnnualCostRisk`
	`AnnualCostRisk__CC`
	`Entitled`
	`Expression-ObjectID`
	`ID`
	`LastUpdate`
	`LicenseModel`
	`Missing`
	`OrgUnit`
	`Period`
	`PurchaseRisk`
	`PurchaseRisk__CC`
	`ReportDate`
	`Required`
	`SoftwareProduct`
	`TimeStamp`
	`TypeID`
`LCMSoftwareReportClassCompliancePerOUDetails`	`AnnualCostRisk`
	`AnnualCostRisk__CC`
	`AnnualUnitPrice`
	`AnnualUnitPrice__CC`
	`Expression-ObjectID`
	`ID`
	`Missing`
	`PricePerLicense`
	`PricePerLicense__CC`
	`PurchaseRisk`
	`PurchaseRisk__CC`
	`Software`
	`TimeStamp`
	`UsedInTypeLCMSoftwareReportCompliancePerOUType`
`PDRContentWidgetClassDocumentTemplate`	`Expression-ObjectID`
	`ID`
	`Purpose`
	`Skin`
	`TimeStamp`
	`UsedInTypePDRContentWidgetTypeEmail`
`PDRSearchEngineTypePickup`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`PDRSearchEngineTypePickup-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`PLBEEngineClassExecution`	`Expression-ObjectID`
	`ID`
	`LastUpdate`
	`LeaseExpiration`
	`OwnerId`
	`Restart`
	`TimeStamp`
	`UsedInTypePLBEEngineTypeCustom`
`PLBEEngineSingletonLock`	`AcquiredAt`
	`LastHeartbeat`
	`LockKey`
	`OwnerId`
	`TimeoutSeconds`
`QueueTask2Capability`	`Capability`
	`ID`
	`QueueTask`
`ReplaceComplianceRulesIDs`	`NewTypeId`
	`OldTypeId`
`SchemaPreLoadOptimization`	`ID`
	`ProcessId`
	`SchemaId`
	`SchemaType`
`SchemaRelation-ESMWorkspaceClassBase2SPSSecurityClassRole`	`ID`
	`Roles`
	`TimeStamp`
	`Workspaces`
`SchemaRelation-PDRNavigationItemClassBase2SPSCommonClassBase`	`Editors`
	`ID`
	`Navigations`
	`TimeStamp`
`SchemaRelation-PDRWidgetInstanceClass2SPSCommonClassBase`	`Editors`
	`ID`
	`TimeStamp`
	`WidgetInstances`
`SchemaRelation-PLSLWorkerClassBase2SPSRemoteAgentClassBase`	`Capabilities`
	`ID`
	`TimeStamp`
	`Workers`
`SCIApplicationClassSources`	`Expression-ObjectID`
	`ID`
	`LastUsed`
	`Sources`
	`SyncDate`
	`TimeStamp`
	`UsedInTypeSCIApplicationType`
`SCIApplicationClassUsageReport`	`ActiveUsers`
	`Expression-ObjectID`
	`ID`
	`Period`
	`SyncDate`
	`TimeStamp`
	`UsedInTypeSCIApplicationType`
`SCIApplicationPickupPortfolioType`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`SourceId`
	`TimeStamp`
	`Value`
`SCIApplicationPickupPortfolioType-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`SCIApplicationUsageClassBase`	`Application`
	`ApplicationID`
	`Country`
	`Expression-ObjectID`
	`ID`
	`LastUsed`
	`SourceID`
	`Sources`
	`SyncDate`
	`TimeStamp`
	`TypeID`
	`UserDepartment`
	`UserID`
	`UserName`
	`UserPrimaryEmail`
`SPSActivityReassignmentPickupMode`	`DisplayString`
	`Hidden`
	`ID`
	`Image`
	`Position`
	`TimeStamp`
	`Value`
`SPSActivityReassignmentPickupMode-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`SPSComputerPickupComplianceState`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`SPSComputerPickupComplianceState-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`SPSContractMonthlyCostsReport`	`Date`
	`Expression-ObjectID`
	`ID`
	`Month`
	`Series`
	`TimeStamp`
	`UsedInTypeSPSContractItemTypeGeneral`
	`UsedInTypeSPSContractItemTypeMaintenance`
	`UsedInTypeSPSContractItemTypePurchase`
	`UsedInTypeSPSContractItemTypeRent`
	`UsedInTypeSPSContractItemTypeService`
	`Value`
	`Value__CC`
	`Year`
`SPSContractMonthlyCostsTypePickupReport`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`SPSNewActivityReassignmentPickupMode`	`DisplayString`
	`Hidden`
	`ID`
	`Image`
	`Position`
	`TimeStamp`
	`Value`
`SPSNewActivityReassignmentPickupMode-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`SPSScCategorySSPConfigurationClassBase`	`EnableAssetSelection`
	`EnableCategory`
	`EnableImpactUrgency`
	`EnableServiceSelection`
	`Expression-ObjectID`
	`ID`
	`TimeStamp`
	`UsedInTypeSPSScCategoryType`
`SPSStockKeepingUnitClassStockReport`	`Amount`
	`EndOfLife`
	`Expression-ObjectID`
	`ID`
	`MinDate`
	`Month`
	`Series`
	`TimeStamp`
	`UsedInTypeSPSStockKeepingUnitType`
	`Year`
`SPSStockKeepingUnitPickupStockRemainingReport`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`SPSStockKeepingUnitPickupStockRemainingReport-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`SVMCalendarHolidayClass`	`DateFrom`
	`DateTo`
	`Expression-ObjectID`
	`Holiday`
	`ID`
	`TimeStamp`
	`TypeID`
`SVMHolidayClass`	`Country`
	`Expression-ObjectID`
	`HolidayID`
	`ID`
	`Name`
	`TimeStamp`
	`Type`
	`TypeID`
	`UseInEscalationManager`
`SVMHolidayClass-CI`	`ID`
	`LCID`
	`Name`
	`Owner`
	`TimeStamp`

Deleted Columns

Table	Column
`PLSLWorkerClassBase`	`RemoteAgent`
`SCIApplicationClass`	`ActivityThresholdInDays`
	`Status`
	`SubCategory`
`SCILicenseClass`	`Contract`
`SPSGlobalConfigurationClassAssetManagement`	`AmountComputersRelevantForLicensing`
`SPSGlobalConfigurationClassRegionalSettings`	`AutoTranslateService`
	`AutoTranslateTranslationEngine`
`SPSGlobalConfigurationClassServices`	`Expression-ObjectID`
	`UsedInTypeSPSGlobalConfigurationType`

Changed Columns

Table	Column	Change
`PDRServiceConnectionClass`	`Password`	`Length: 500 <> 4000`
`SCIApplicationClass`	`SourceID`	`Type: int <> nvarchar \| Length: NULL <> 100 \| Allow Null: NO <> YES`
`SPSComplianceRuleActions`	`Template`	`Type: varbinary <> nvarchar`

Added Columns

Table	Column
`DWPExtensionAssemblyClass`	`RuntimeCapabilities`
`ESMKBArticleTemplateClass`	`Workspace`
`LCMLicenseDemandClassServerStatistics`	`NumberOfVOSEMobilityInCluster`
`LISSoftwareProductClassBase`	`EndOfExtendedSupport`
	`EndOfSales`
`PDRActionClassBase`	`AIFunction`
`PDRApplicationClassBase`	`PanelDisplayContextsMode`
	`SearchEngine`
	`WizardDockPosition`
`PDRContentWidgetClassBase`	`IgnoreWorkspace`
`PDRContentWidgetClassEmail`	`DocumentTemplate`
	`UsedInTypeDWPEmailDescriptorType`
`PDRContentWidgetTemplateView`	`IgnoreWorkspace`
`PDRDirectoryClassAuth`	`ImplicitFlowFallbackDisabled`
`PDREmailSkinClassBase`	`DefaultPDF`
`PLBEActivationClassTask`	`ActivationParmsJson`
	`WorkerType`
`PLBEEngineClassBase`	`DataLayerMode`
	`ImplementationType`
	`WorkerType`
`PLSLProcessInstanceClassBase`	`MetaInfo`
`PLSLServiceClassBase`	`RunOnWorker`
`PLSLWorkerClassBase`	`StateInfo`
`PLSLXamlComponentClassBase`	`UseFunctionalWorker`
`QueueTask`	`IsRealtime`
`SCIApplicationClass`	`AboutUrl`
	`ApplicationSourceID`
	`AssignedLicensesCount`
	`BillableLicensesCount`
	`CookiePolicyUrl`
	`Description`
	`GDPRUrl`
	`HomePageUrl`
	`PortfolioType`
	`PotentialSaving`
	`PotentialSaving__CC`
	`PricingPageUrl`
	`PrivacyPolicyUrl`
	`Publisher`
	`RenewalDate`
	`SecurityUrl`
	`TermsOfServiceUrl`
`SPSActivityClassBase`	`RecipientToCleanUp`
	`RecipientToReassignFrom`
`SPSActivityClassUnitOfWork`	`CreationType`
	`MessageID`
`SPSActivityTemplateClassBase`	`Workspace`
`SPSAlertingConfiguration`	`SmimeCertificate`
	`SmimeCertificatePassword`
	`SmtpServerConnectionType`
	`UseSmimeCertificateForEncrypting`
	`UseSmimeCertificateForSigning`
`SPSArticleCategoryClassBase`	`ServiceDeskCategory`
`SPSAssetClassMobile`	`ComplianceState`
	`DeviceCategory`
	`IsEncrypted`
`SPSComputerClassBase`	`FreeStorageSpace`
	`TotalStorageSpace`
`SPSComputerClassOS`	`Edition`
`SPSGlobalConfigurationClassRegionalSettings`	`AutoTranslateAIFunction`
	`AutoTranslateOptimization`
	`EnhanceTextAIFunction`
`SPSGlobalConfigurationClassSecurity`	`Saml2ImplicitFlowFallbackDisabled`
`SPSGlobalConfigurationClassServiceCatalog`	`CatalogTilesPhotoStyleMode`
`SPSGlobalConfigurationClassServiceDesk`	`DefaultActivityDelegationMode`
	`DefaultDelegationDuration`
	`DefaultNewActivityDelegationMode`
	`EnableTicketWizard`
	`EnableWorkspaces`
`SPSOrgUnitClassBase`	`EnableComplianceReporting`
`SPSQuickCallClassBase`	`Workspace`
`SPSRemoteAgentClassBase`	`AutoDetect`
`SPSScCategoryClassBase`	`Workspace`
`SPSSoftwareClassBase`	`AnnualUnitPrice`
	`AnnualUnitPrice__CC`
`SPSUserClassBase`	`ActivityDelegationMode`
	`NewActivityDelegationMode`
`SVMChangeTemplateClassBase`	`InWorkspace`
`SVMEmailSignatureClassBase`	`Workspace`
`SVMEmailTemplateClassBase`	`Workspace`
`SVMKBArticleClassBase`	`ProposalDate`
	`ProposalSource`
	`ProposalStatus`

Database Schema Changes 26.1.x

Contact Us

Version 26.1.x

26.1.0.3097

Deleted Tables

Added Tables

Deleted Columns

Changed Columns

Added Columns

Related Articles