Skip to main content
Matrix42 Self-Service Help Center

Database Schema Changes 11.0.x

Version 11.0.2

Release 11.0.2.3591 (05.02.2024) 

New Attributes

Table Attribute
SPSConnectorClassBase Licensed
SPSGenericConnectorClassBase Licensed

Release 11.0.2.3581 (04.01.2024) 

New Attributes

Table Attribute
SPSRatingSummaryClassBase UsedInTypeSVCServiceTypeConfigGroup

Release 11.0.2.3576 (12.12.2023) 

New Attributes

Table Attribute
SPSGenericConnectorConfigurationClassAzureAD PrefillPersonsEmail
SPSSecurityGroupClassMember Sid

Release 11.0.2.3552 (05.10.2023) 

New Tables

Table Attribute
DWPAzureADCustomFilterPickup DisplayString
  GraphFilterExpression
  Hidden
  ID
  Position
  TimeStamp
  Type
  Value
DWPAzureADCustomFilterPickup-CI DisplayString
  ID
  LCID
  Owner
  TimeStamp
DWPAzureADCustomFilterTypePickup DisplayString
  Hidden
  ID
  Position
  TimeStamp
  Value
DWPAzureADCustomFilterTypePickup-CI DisplayString
  ID
  LCID
  Owner
  TimeStamp

Release 11.0.2.3538 (24.08.2023) 

New Attributes

Table Attribute
SPSArticleClassBase DeclineBookingIfAllChildrenDeclined
SPSGlobalConfigurationClassServiceDesk InheritTaskOwnershipFromInitiator

Release 11.0.2.3492 (23.03.2023)

New Tables

Table Attribute
ESMEmailRobotPickupMemoization DisplayString
ESMEmailRobotPickupMemoization Hidden
ESMEmailRobotPickupMemoization ID
ESMEmailRobotPickupMemoization Position
ESMEmailRobotPickupMemoization TimeStamp
ESMEmailRobotPickupMemoization Value
ESMEmailRobotPickupMemoization-CI DisplayString
ESMEmailRobotPickupMemoization-CI ID
ESMEmailRobotPickupMemoization-CI LCID
ESMEmailRobotPickupMemoization-CI Owner
ESMEmailRobotPickupMemoization-CI TimeStamp
TmpDisabledCustomTriggers TableName
TmpDisabledCustomTriggers TriggerName

New Attributes

Table Attribute
SPSGlobalConfigurationClassMailBox Memoization
SPSRatingSummaryClassBase UsedInTypeSPSArticleTypeGroup
SPSRatingSummaryClassBase     UsedInTypeSPSArticleTypeService
SPSRatingSummaryClassBase     UsedInTypeSVCServiceTypeBundle
GDIEImportClassDatabase Server

Changed Attributes

Table Attribute Change
GDIEImportClassDatabase Server Length increased from 50 to 500

Release Candidate 11.0.2.3415 (30.09.2022) 

New Attributes

Table Attribute
SPSGlobalConfigurationClassBase     ShowHiddenValuesInSearch

Technical Preview 11.0.2.3382 (12.09.2022)

New Tables

Table Attribute
DWPFileInfo BindAttribute
DWPFileInfo Comment
DWPFileInfo Expression-ObjectID
DWPFileInfo FileId
DWPFileInfo ID
DWPFileInfo Name
DWPFileInfo ObjectId
DWPFileInfo ObjectTypeId
DWPFileInfo Size
DWPFileInfo Storage
DWPFileInfo Thumbnail
DWPFileInfo TimeStamp
DWPFileInfo TypeID
DWPFileInfo UniqueFileId
DWPFileInfo UpdatedBy
DWPFileInfo UpdatedOn
DWPFileInfo Uploaded
DWPFileStorageAccountClass ConfigurationItems
DWPFileStorageAccountClass CustomSettingsCiName
DWPFileStorageAccountClass CustomSettingsEntity
DWPFileStorageAccountClass Default
DWPFileStorageAccountClass Description
DWPFileStorageAccountClass Enabled
DWPFileStorageAccountClass Expression-ObjectID
DWPFileStorageAccountClass Extensions
DWPFileStorageAccountClass FileCountPerObject
DWPFileStorageAccountClass ID
DWPFileStorageAccountClass MaxFileSizeMb
DWPFileStorageAccountClass Name
DWPFileStorageAccountClass Priority
DWPFileStorageAccountClass Secured
DWPFileStorageAccountClass TimeStamp
DWPFileStorageAccountClass TypeID
DWPFileStorageAccountClassCustomEntity Expression-ObjectID
DWPFileStorageAccountClassCustomEntity ID
DWPFileStorageAccountClassCustomEntity TimeStamp
DWPFileStorageAccountClassCustomEntity TypeID
DWPFileStorageAccountClassSqlServer ConnectionString
DWPFileStorageAccountClassSqlServer Expression-ObjectID
DWPFileStorageAccountClassSqlServer ID
DWPFileStorageAccountClassSqlServer StorageContainer
DWPFileStorageAccountClassSqlServer TimeStamp
DWPFileStorageAccountClassSqlServer UsedInTypeDWPFileStorageAccountTypeSqlServer
SchemaRelation-DWPFileStorageAccountClass2SPSLocationClassBase FileStorageAccounts
SchemaRelation-DWPFileStorageAccountClass2SPSLocationClassBase ID
SchemaRelation-DWPFileStorageAccountClass2SPSLocationClassBase Locations
SchemaRelation-DWPFileStorageAccountClass2SPSLocationClassBase TimeStamp
SchemaRelation-DWPFileStorageAccountClass2SPSScRoleClassBase FileStorageAccounts
SchemaRelation-DWPFileStorageAccountClass2SPSScRoleClassBase ID
SchemaRelation-DWPFileStorageAccountClass2SPSScRoleClassBase Roles
SchemaRelation-DWPFileStorageAccountClass2SPSScRoleClassBase TimeStamp

New Attributes

Table Attribute
PDRConfigurationPackageClassBase CertificateDisplayName
SPSGlobalConfigurationClassSecurity AdditionalLoginDelay

Changed Attributes

Table Attribute Change
PLSLWorkerClassBase StateDescription data type became "TEXT"

Deleted Attributes

Table Attribute
Files Comment
Files Folder
Files Name
Files Thumbnail
Files UploadedBy
Files UploadedOn

Version 11.0.1

Release 11.0.1.3380 (29.09.2022) 

No database schema changes have been made in this version

Release 11.0.1.3376 (09.09.2022)

No database schema changes have been made in this version

Release 11.0.1.3372 (25.08.2022)

No database schema changes have been made in this version

Release 11.0.1.3367 (11.08.2022)

No database schema changes have been made in this version

Release 11.0.1.3361 (01.08.2022) 

No database schema changes have been made in this version

Release 11.0.1.3350 (04.07.2022)

New Tables

Table Attribute
PDRControlDescriptorStyleClassBase Control
PDRControlDescriptorStyleClassBase Expression-ObjectID
PDRControlDescriptorStyleClassBase ID
PDRControlDescriptorStyleClassBase Name
PDRControlDescriptorStyleClassBase Style
PDRControlDescriptorStyleClassBase TimeStamp
PDRControlDescriptorStyleClassBase UsedInTypePDRControlDescriptorStyleType
PDRControlDescriptorStyleType ID
PDRControlDescriptorStyleType TimeStamp
PDRDwpConfigurationClass Expression-ObjectID
PDRDwpConfigurationClass ID
PDRDwpConfigurationClass Key
PDRDwpConfigurationClass TimeStamp
PDRDwpConfigurationClass UsedInTypeSPSGlobalConfigurationType
PDRDwpConfigurationClass Value
PDRDwpFrontendConfigurationClass Expression-ObjectID
PDRDwpFrontendConfigurationClass ID
PDRDwpFrontendConfigurationClass Key
PDRDwpFrontendConfigurationClass TimeStamp
PDRDwpFrontendConfigurationClass Type
PDRDwpFrontendConfigurationClass UsedInTypeSPSGlobalConfigurationType
PDRDwpFrontendConfigurationClass Value
PDRDwpFrontendConfigurationPickupType DisplayString
PDRDwpFrontendConfigurationPickupType Hidden
PDRDwpFrontendConfigurationPickupType ID
PDRDwpFrontendConfigurationPickupType Position
PDRDwpFrontendConfigurationPickupType TimeStamp
PDRDwpFrontendConfigurationPickupType Value
PDREmailHtmlTagPickup DisplayString
PDREmailHtmlTagPickup Hidden
PDREmailHtmlTagPickup ID
PDREmailHtmlTagPickup Position
PDREmailHtmlTagPickup StylePreview
PDREmailHtmlTagPickup TagName
PDREmailHtmlTagPickup TimeStamp
PDREmailHtmlTagPickup Value
PDREmailHtmlTagPickup-CI DisplayString
PDREmailHtmlTagPickup-CI ID
PDREmailHtmlTagPickup-CI LCID
PDREmailHtmlTagPickup-CI Owner
PDREmailHtmlTagPickup-CI TimeStamp
PDREmailSkinClassBase Default
PDREmailSkinClassBase Expression-ObjectID
PDREmailSkinClassBase ID
PDREmailSkinClassBase Name
PDREmailSkinClassBase Styles
PDREmailSkinClassBase TimeStamp
PDREmailSkinClassBase UsedInTypePDREmailSkinType
PDREmailSkinType ID
PDREmailSkinType TimeStamp
PDRPrintLayoutClassBase-CI ID
PDRPrintLayoutClassBase-CI LCID
PDRPrintLayoutClassBase-CI Owner
PDRPrintLayoutClassBase-CI Template
PDRPrintLayoutClassBase-CI TimeStamp
SVMEmailConfigurationClassBase Description
SVMEmailConfigurationClassBase EmailFrom
SVMEmailConfigurationClassBase EmailLayout
SVMEmailConfigurationClassBase Expression-ObjectID
SVMEmailConfigurationClassBase ID
SVMEmailConfigurationClassBase Name
SVMEmailConfigurationClassBase OU
SVMEmailConfigurationClassBase Role
SVMEmailConfigurationClassBase Signature
SVMEmailConfigurationClassBase Skin
SVMEmailConfigurationClassBase TimeStamp
SVMEmailConfigurationClassBase UsedInTypeSVMEmailConfigurationType
SVMEmailConfigurationType ID
SVMEmailConfigurationType TimeStamp
WorkerEvents EnterpriseId
WorkerEvents Id
WorkerEvents InstanceId
WorkerEvents RecordDetails
WorkerEvents StartTime

New Attributes

Table Attribute
PDRContentWidgetClassEmail EmailConfiguration
PDRContentWidgetClassEmail ExpressionEmailConfiguration
PDRContentWidgetClassEmail Skin
PDRControlDescriptorClassBase FormatElements
PDRControlDescriptorClassBase StylePreview
PDRPrintLayoutClassBase ApplyTemplate
PDRPrintLayoutClassBase Template
SPSAlertingConfiguration PreserveEmbeddedImages
SPSAlertingConfiguration ServiceConnection
SPSAlertingConfiguration SslProtocol
SPSAlertingConfiguration UserEmailAddress
SPSGenericConnectorConfigurationClassAzureAD ImportOnPremiseExtensionAttributes
SPSGlobalConfigurationClassBase AllowNonWindowsAutoLogin
SPSGlobalConfigurationClassBase AutoLogin
SPSGlobalConfigurationClassBase DataSourcePageSize
SPSGlobalConfigurationClassBase DataSourcePageSizes
SPSGlobalConfigurationClassBase ExportMaxRowSize
SPSGlobalConfigurationClassBase ExtraOrigins
SPSGlobalConfigurationClassBase LinkAllowProtocols
SPSGlobalConfigurationClassBase MaxFileSize
SPSGlobalConfigurationClassBase MaxRecentSearches
SPSGlobalConfigurationClassBase MaxWordsPerCondition
SPSGlobalConfigurationClassMailBox MarkIgnoredEmailsAsRead
SPSGlobalConfigurationClassMailBox MoveToFolderIgnored
SPSGlobalConfigurationClassMailBox MoveToFolderIgnoredType
SPSGlobalConfigurationClassSecurity AuthenticationRedirectURISuffix
SPSGlobalConfigurationClassServiceDesk EmailRobotReceiveTimeout
SPSGlobalConfigurationClassServiceDesk ImportedTicketMaxDescriptionSize
SPSInventoryClassBase UsedInTypeSPSAssetTypeNetworkDevice
WFPPromotionsTable Culture

Version 11.0.0

Release 11.0.0.3367 (08.07.2022)

New Attributes

Table Attribute
SPSGenericConnectorConfigurationClassAzureAD ImportOnPremiseExtensionAttributes
SPSGlobalConfigurationClassMailBox MarkIgnoredEmailsAsRead
SPSGlobalConfigurationClassMailBox MoveToFolderIgnored
SPSGlobalConfigurationClassMailBox MoveToFolderIgnoredType
SPSGlobalConfigurationClassServiceDesk EmailRobotReceiveTimeout
SPSGlobalConfigurationClassServiceDesk ImportedTicketMaxDescriptionSize

Release 11.0.0.3358

No database schema changes have been made in this version

Release 11.0.0.3350

No database schema changes have been made in this version

Release 11.0.0.3347 

No database schema changes have been made in this version

Release 11.0.0.3343

New Attributes

Table Attribute
PLBEActivationClassSchedule RunTimeLocal
PLBEActivationClassSchedule TimeZone

Release 11.0.0.3339

No database schema changes have been made in this version

Release 11.0.0.3333

No database schema changes have been made in this version

Release 11.0.0.3331 (General Availability)

Changed Attributes

Table Attribute Change
SPSUserClassBase Office     Character length changed from 100 to 128

Release 11.0.0.3326 (Release Candidate 2)

Deleted Attributes

Table Attribute
SPSGlobalConfigurationClassServiceDesk SendEmailRecipientsSplitting

Release 11.0.0.3324 (Release Candidate 1)

New Attributes

Table Attribute
SPSAlertingConfiguration     RecipientsSplitDomain
  • Was this article helpful?