Skip to main content
Matrix42 Self-Service Help Center

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.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
  • Was this article helpful?