Database Schema Changes 10.1.x
List of database schema changes for Enterprise Service Management 10.1.x
Version 10.1.1
Hotfix 10.1.1.3373
New Attributes
| Table | Attribute |
|---|---|
| SPSGlobalConfigurationClassMailBox | MarkIgnoredEmailsAsRead |
| SPSGlobalConfigurationClassMailBox | MoveToFolderIgnored |
| SPSGlobalConfigurationClassMailBox | MoveToFolderIgnoredType |
| SPSGlobalConfigurationClassServiceDesk | EmailRobotReceiveTimeout |
| SPSGlobalConfigurationClassServiceDesk | ImportedTicketMaxDescriptionSize |
Hotfix 10.1.1.3352
New Attributes
| Table | Attribute |
|---|---|
| PLBEActivationClassSchedule | RunTimeLocal |
| PLBEActivationClassSchedule | TimeZone |
Hotfix 10.1.1.3338
No database schema changes have been made in this version.
Hotfix 10.1.1.3335
No database schema changes have been made in this version.
Hotfix 10.1.1.3321
Deleted Attributes
| Table | Attribute |
|---|---|
| SPSGlobalConfigurationClassServiceDesk | SendEmailRecipientsSplitting |
Hotfix 10.1.1.3311
New Attributes
| Table | Attribute |
|---|---|
| SPSComputerClassBase | ManagementServerIp |
| SPSComputerClassBase | VmName |
Technical Preview Release 10.1.1.3300
New Tables
| Table | Attribute |
|---|---|
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole | ID |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole | InstallationRecipientRoles |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole | ProvisioningInstallationSendEmailWF |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole | TimeStamp |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole0 | ID |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole0 | ProvisioningUninstallationSendEmailWF |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole0 | TimeStamp |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole0 | UninstallationRecipientRoles |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole1 | ID |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole1 | ProvisioningRepairSendEmailWF |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole1 | RepairRecipientRoles |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSSecurityClassRole1 | TimeStamp |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase | ID |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase | InstallationRecipientUsers |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase | ProvisioningInstallationSendEmailWF |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase | TimeStamp |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase0 | ID |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase0 | ProvisioningUninstallationSendEmailWF |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase0 | TimeStamp |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase0 | UninstallationRecipientUsers |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase1 | ID |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase1 | ProvisioningRepairSendEmailWF |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase1 | RepairRecipientUsers |
| SchemaRelation-SVCServiceProvisioningClassBaseSendEmailWF2SPSUserClassBase1 | TimeStamp |
| SVCServicePickupFilterCombiningMode | DisplayString |
| SVCServicePickupFilterCombiningMode | Hidden |
| SVCServicePickupFilterCombiningMode | ID |
| SVCServicePickupFilterCombiningMode | Position |
| SVCServicePickupFilterCombiningMode | TimeStamp |
| SVCServicePickupFilterCombiningMode | Value |
| SVCServicePickupFilterCombiningMode-CI | DisplayString |
| SVCServicePickupFilterCombiningMode-CI | ID |
| SVCServicePickupFilterCombiningMode-CI | LCID |
| SVCServicePickupFilterCombiningMode-CI | Owner |
| SVCServicePickupFilterCombiningMode-CI | TimeStamp |
| SVCServiceProvisioningClassBaseCreateWFTask | ConfigurationID |
| SVCServiceProvisioningClassBaseCreateWFTask | Expression-ObjectID |
| SVCServiceProvisioningClassBaseCreateWFTask | ID |
| SVCServiceProvisioningClassBaseCreateWFTask | InstallationTaskTemplate |
| SVCServiceProvisioningClassBaseCreateWFTask | RepairTaskTemplate |
| SVCServiceProvisioningClassBaseCreateWFTask | TimeStamp |
| SVCServiceProvisioningClassBaseCreateWFTask | UninstallationTaskTemplate |
| SVCServiceProvisioningClassBaseCreateWFTask | UsedInTypeSVCServiceProvisioningTypeCreateWFTask |
| SVCServiceProvisioningClassBaseExecuteScriptWF | ConfigurationID |
| SVCServiceProvisioningClassBaseExecuteScriptWF | Expression-ObjectID |
| SVCServiceProvisioningClassBaseExecuteScriptWF | ID |
| SVCServiceProvisioningClassBaseExecuteScriptWF | InstallationCategory |
| SVCServiceProvisioningClassBaseExecuteScriptWF | InstallationResponsiblePerson |
| SVCServiceProvisioningClassBaseExecuteScriptWF | InstallationResponsibleRole |
| SVCServiceProvisioningClassBaseExecuteScriptWF | InstallationScript |
| SVCServiceProvisioningClassBaseExecuteScriptWF | RepairCategory |
| SVCServiceProvisioningClassBaseExecuteScriptWF | RepairResponsiblePerson |
| SVCServiceProvisioningClassBaseExecuteScriptWF | RepairResponsibleRole |
| SVCServiceProvisioningClassBaseExecuteScriptWF | RepairScript |
| SVCServiceProvisioningClassBaseExecuteScriptWF | TimeStamp |
| SVCServiceProvisioningClassBaseExecuteScriptWF | UninstallationCategory |
| SVCServiceProvisioningClassBaseExecuteScriptWF | UninstallationResponsiblePerson |
| SVCServiceProvisioningClassBaseExecuteScriptWF | UninstallationResponsibleRole |
| SVCServiceProvisioningClassBaseExecuteScriptWF | UninstallationScript |
| SVCServiceProvisioningClassBaseExecuteScriptWF | UsedInTypeSVCServiceProvisioningTypeExecuteScriptWF |
| SVCServiceProvisioningClassBaseSendEmailWF | ConfigurationID |
| SVCServiceProvisioningClassBaseSendEmailWF | Expression-ObjectID |
| SVCServiceProvisioningClassBaseSendEmailWF | ID |
| SVCServiceProvisioningClassBaseSendEmailWF | InstallationEmailAddresses |
| SVCServiceProvisioningClassBaseSendEmailWF | InstallationEmailDescriptor |
| SVCServiceProvisioningClassBaseSendEmailWF | RepairEmailAddresses |
| SVCServiceProvisioningClassBaseSendEmailWF | RepairEmailDescriptor |
| SVCServiceProvisioningClassBaseSendEmailWF | TimeStamp |
| SVCServiceProvisioningClassBaseSendEmailWF | UninstallationEmailAddresses |
| SVCServiceProvisioningClassBaseSendEmailWF | UninstallationEmailDescriptor |
| SVCServiceProvisioningClassBaseSendEmailWF | UsedInTypeSVCServiceProvisioningTypeSendEmailWF |
| SVCServiceProvisioningTypeCreateWFTask | ID |
| SVCServiceProvisioningTypeCreateWFTask | TimeStamp |
| SVCServiceProvisioningTypeExecuteScriptWF | ID |
| SVCServiceProvisioningTypeExecuteScriptWF | TimeStamp |
| SVCServiceProvisioningTypeSendEmailWF | ID |
| SVCServiceProvisioningTypeSendEmailWF | TimeStamp |
Deleted Attributes
| Table | Attribute |
|---|---|
| WFPPromotionsTable | Culture |
Updated Tables
| Table | Attribute | Remarks |
|---|---|---|
| PDRApplicationClassBase | Enabled | ((0)) <> ((1)) |
| Schema-MetaInfo | CustomValue | 1024 <> 2024 |
| Schema-MetaInfo | Value | 2024 |
New Attributes
| Table | Attribute |
|---|---|
| PDRApplicationClassBase | UnifiedSearchBackground |
| PDRApplicationClassBase | UnifiedSearchEnabled |
| PDRApplicationClassBase | UnifiedSearchHeadlineColorOverride |
| PDRApplicationClassBase | UnifiedSearchTitle1 |
| PDRApplicationClassBase | UnifiedSearchTitle2 |
| PDRApplicationClassBase-CI | UnifiedSearchTitle1 |
| PDRApplicationClassBase-CI | UnifiedSearchTitle2 |
| PDRServiceConnectionAppClass | AccountId |
| PDRServiceConnectionAppClass | PrivateKey |
| PDRServiceConnectionProviderClass | ClaimsFormat |
| PDRServiceConnectionProviderClass | ExchangeTokenFormat |
| PDRThemeClassBase | UnifiedSearchBgColor |
| SPSArticleClassBase | TechnicalTargetFilterAccounts |
| SPSArticleClassBase | TechnicalTargetFilterAllComputers |
| SPSArticleClassBase | TechnicalTargetFilterCombineMode |
| SPSArticleClassBase | TechnicalTargetFilterComputers |
| SPSGlobalConfigurationClassBase | ProfileDialogId |
Version 10.1
Release 10.1.0.3321
New Attributes
| Table | Attribute |
|---|---|
| SPSActivityClassBase | ClosureAttachments |
Technical Release 10.1.0.3279
New Attributes
| Table | Attribute |
|---|---|
|
SPSGlobalConfigurationClassSecurity |
UseNewRedirectURL |
Technical Release 10.1.0.3273
Deleted Tables
| Table | Remarks |
|---|---|
| SPSGlobalConfigurationClassDependencyDefinition | |
| SPSGlobalConfigurationClassDependencyObjectDisplay | |
| SVCServicePickupDependencyDirection | |
| SVCServicePickupDependencyDirection-CI |
New Tables
| Table | Attribute |
|---|---|
| ASMClusterClassBase | ClusterProduct |
| ASMClusterClassBase | ClusterStatus |
| ASMClusterClassBase | ClusterType |
| ASMClusterClassBase | ClusterVIP |
| ASMClusterClassBase | Expression-ObjectID |
| ASMClusterClassBase | ID |
| ASMClusterClassBase | Name |
| ASMClusterClassBase | ObjectId |
| ASMClusterClassBase | SDDMConfigurationItemID |
| ASMClusterClassBase | TimeStamp |
| ASMClusterClassBase | UsedInTypeASMClusterType |
| ASMClusterPickupStatus | DisplayString |
| ASMClusterPickupStatus | Hidden |
| ASMClusterPickupStatus | ID |
| ASMClusterPickupStatus | Position |
| ASMClusterPickupStatus | TimeStamp |
| ASMClusterPickupStatus | Value |
| ASMClusterPickupStatus-CI | DisplayString |
| ASMClusterPickupStatus-CI | ID |
| ASMClusterPickupStatus-CI | LCID |
| ASMClusterPickupStatus-CI | Owner |
| ASMClusterPickupStatus-CI | TimeStamp |
| ASMClusterPickupType | DisplayString |
| ASMClusterPickupType | Hidden |
| ASMClusterPickupType | ID |
| ASMClusterPickupType | Position |
| ASMClusterPickupType | TimeStamp |
| ASMClusterPickupType | Value |
| ASMClusterPickupType-CI | DisplayString |
| ASMClusterPickupType-CI | ID |
| ASMClusterPickupType-CI | LCID |
| ASMClusterPickupType-CI | Owner |
| ASMClusterPickupType-CI | TimeStamp |
| ASMClusterType | ID |
| ASMClusterType | TimeStamp |
| ASMStorageDeviceClassBase | Expression-ObjectID |
| ASMStorageDeviceClassBase | ID |
| ASMStorageDeviceClassBase | IPAddress |
| ASMStorageDeviceClassBase | MonitoringStatus |
| ASMStorageDeviceClassBase | Name |
| ASMStorageDeviceClassBase | ObjectID |
| ASMStorageDeviceClassBase | SDDMConfigurationItemID |
| ASMStorageDeviceClassBase | TimeStamp |
| ASMStorageDeviceClassBase | UsedInTypeASMStorageDeviceType |
| ASMStorageDevicePickupMonitoringStatus | DisplayString |
| ASMStorageDevicePickupMonitoringStatus | Hidden |
| ASMStorageDevicePickupMonitoringStatus | ID |
| ASMStorageDevicePickupMonitoringStatus | Position |
| ASMStorageDevicePickupMonitoringStatus | TimeStamp |
| ASMStorageDevicePickupMonitoringStatus | Value |
| ASMStorageDevicePickupMonitoringStatus-CI | DisplayString |
| ASMStorageDevicePickupMonitoringStatus-CI | ID |
| ASMStorageDevicePickupMonitoringStatus-CI | LCID |
| ASMStorageDevicePickupMonitoringStatus-CI | Owner |
| ASMStorageDevicePickupMonitoringStatus-CI | TimeStamp |
| ASMStorageDeviceType | ID |
| ASMStorageDeviceType | TimeStamp |
| DWPThemeIconSetPickup | DisplayString |
| DWPThemeIconSetPickup | Hidden |
| DWPThemeIconSetPickup | ID |
| DWPThemeIconSetPickup | Path |
| DWPThemeIconSetPickup | Position |
| DWPThemeIconSetPickup | TimeStamp |
| DWPThemeIconSetPickup | Value |
| DWPThemeIconSetPickup-CI | DisplayString |
| DWPThemeIconSetPickup-CI | ID |
| DWPThemeIconSetPickup-CI | LCID |
| DWPThemeIconSetPickup-CI | Owner |
| DWPThemeIconSetPickup-CI | TimeStamp |
| PDRServiceConnectionScopeClass-CI | Description |
| PDRServiceConnectionScopeClass-CI | ID |
| PDRServiceConnectionScopeClass-CI | LCID |
| PDRServiceConnectionScopeClass-CI | Owner |
| PDRServiceConnectionScopeClass-CI | TimeStamp |
| PDRServiceConnectionStatusPickup | DisplayString |
| PDRServiceConnectionStatusPickup | Hidden |
| PDRServiceConnectionStatusPickup | ID |
| PDRServiceConnectionStatusPickup | Position |
| PDRServiceConnectionStatusPickup | TimeStamp |
| PDRServiceConnectionStatusPickup | Value |
| PDRServiceConnectionStatusPickup-CI | DisplayString |
| PDRServiceConnectionStatusPickup-CI | ID |
| PDRServiceConnectionStatusPickup-CI | LCID |
| PDRServiceConnectionStatusPickup-CI | Owner |
| PDRServiceConnectionStatusPickup-CI | TimeStamp |
| SchemaRelation-ASMClusterClassBase2SPSComputerClassBase | Clusters |
| SchemaRelation-ASMClusterClassBase2SPSComputerClassBase | ID |
| SchemaRelation-ASMClusterClassBase2SPSComputerClassBase | Nodes |
| SchemaRelation-ASMClusterClassBase2SPSComputerClassBase | TimeStamp |
| SchemaRelation-ASMStorageDeviceClassBase2SPSComputerClassBase | ID |
| SchemaRelation-ASMStorageDeviceClassBase2SPSComputerClassBase | StorageDevices |
| SchemaRelation-ASMStorageDeviceClassBase2SPSComputerClassBase | Systems |
| SchemaRelation-ASMStorageDeviceClassBase2SPSComputerClassBase | TimeStamp |
Deleted Attributes
| Table | Attribute |
|---|---|
| SPSGlobalConfigurationClassServiceDesk | AllowedTypesForObjectClassDependency |
| SPSObjectClassDependency | Direction |
| SVCServicePickupDependencyType | Opposite |
Updated Tables
| Table | Attribute | Remarks |
|---|---|---|
| CTMContractItemPickupServiceType | DisplayString | Character length changed from '50' to '55' |
| CTMContractItemPickupServiceType-CI | DisplayString | Character length changed from '50' to '55' |
| PDRServiceConnectionAppClass | Name | Character length changed from '100' to '200' |
| PDRServiceConnectionClass | Name | Character length changed from '100' to '200' |
| SPSCurrencyPickupConversionBankRate | DisplayString | Character length changed from '50' to '55' |
| SPSCurrencyPickupConversionBankRate-CI | DisplayString | Character length changed from '50' to '55' |
| SPSGenericConnectorConfigurationClassAzureAD | ClientID | AllowNull is changed from NO to YES |
| SPSGenericConnectorConfigurationClassAzureAD | ClientSecret | AllowNull is changed from NO to YES |
| SPSGenericConnectorConfigurationClassAzureAD | Tenant | AllowNull is changed from NO to YES |
New Attributes
| Table | Attribute |
|---|---|
| PDRServiceConnectionClass | Status |
| PDRServiceConnectionScopeClass | Description |
| PDRServiceConnectionScopeClass | GrantType |
| PDRServiceConnectionScopeClass | ValidateUri |
| PDRThemeClassBase | IconSet |
| SPSAssetClassBase | UsedInTypeASMStorageDeviceType |
| SPSGenericConnectorConfigurationClassAzureAD | ServiceConnection |
| SPSGlobalConfigurationClassSecurity | AllowUserRegistration |
| SPSGlobalConfigurationClassSecurity | Domain |
| SPSGlobalConfigurationClassServiceDesk | KeepResponsibleRoleOnEmptyDefaultsFromChangedItem |
| SPSGlobalConfigurationClassWorkflowEngine | MonitoringMaxVariableSize |
Technical Preview 10.1.0.3200
Deleted Tables
| Table | Remarks |
|---|---|
| ReplaceComplianceRulesIDs |
Deleted Attributes
| Table | Attribute |
|---|---|
| ReplaceComplianceRulesIDs | NewTypeId |
| ReplaceComplianceRulesIDs | OldTypeId |
New Attributes
| Table | Attribute |
|---|---|
| PDRConfigurationPackageClassBase | PackageHash |
| PLSLWorkerClassBase | WorkerProcessId |
| SPSGlobalConfigurationClassMailBox | ServiceConnection |