Database Schema Changes 10.1.x
Table of Contents
Version 10.1.1
Hotfix 10.1.1.3378
Hotfix 10.1.1.3373
Hotfix 10.1.1.3359
Hotfix 10.1.1.3358
Hotfix 10.1.1.3352
Hotfix 10.1.1.3338
Hotfix 10.1.1.3335
Hotfix 10.1.1.3321
Hotfix 10.1.1.3311
Hotfix 10.1.1.3308
Technical Release 10.1.1.3304
Technical Preview Release 10.1.1.3300
Version 10.1
Release 10.1.0.3321
Release 10.1.0.3313
Release 10.1.0.3310
Release 10.1.0.3302
Release 10.1.0.3296
Technical Release 10.1.0.3286
Technical Release 10.1.0.3279
Technical Release 10.1.0.3273
Technical Preview 10.1.0.3200
List of database schema changes for Enterprise Service Management 10.1.x
Version 10.1.1
Hotfix 10.1.1.3378
No database schema changes have been made in this version
Hotfix 10.1.1.3373
New Attributes
| Table | Attribute |
|---|---|
| SPSGlobalConfigurationClassMailBox | MarkIgnoredEmailsAsRead |
| SPSGlobalConfigurationClassMailBox | MoveToFolderIgnored |
| SPSGlobalConfigurationClassMailBox | MoveToFolderIgnoredType |
| SPSGlobalConfigurationClassServiceDesk | EmailRobotReceiveTimeout |
| SPSGlobalConfigurationClassServiceDesk | ImportedTicketMaxDescriptionSize |
Hotfix 10.1.1.3359
No database schema changes have been made in this version
Hotfix 10.1.1.3358
No database schema changes have been made in this version
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 |
Hotfix 10.1.1.3308
No database schema changes have been made in this version
Technical Release 10.1.1.3304
No database schema changes have been made in this version
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 |
Release 10.1.0.3313
No database schema change have been made in this version
Release 10.1.0.3310
No database schema change have been made in this version
Release 10.1.0.3302
No database schema change have been made in this version
Release 10.1.0.3296
No database schema change have been made in this version
Technical Release 10.1.0.3286
No database schema change have been made in this version
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 |