Skip to main content
Matrix42 Self-Service Help Center

Database Schema Changes 12.0.x

Version 12.0.4

12.0.4.3222 (08.05.2024) 

Added Tables

 

Table Column
SVCServiceBookingClassBase-CI ID
  LCID
  Owner
  ServiceName
  TimeStamp

12.0.4.3192 (22.03.2024) 

Added Tables

 

Table Column
DWPCertificatesSyncResult ErrorMessage
  ID
  LastSyncDate
  TimeStamp
DWPLoginPageConfigurationClass BackgroundColor
  BackgroundImage
  ButtonColor
  ButtonTextColor
  Expression-ObjectID
  ID
  LeftForegroundColor
  LeftForegroundImage
  Logo
  RightForegroundColor
  RightForegroundImage
  RightForegroundImageBehaviour
  ShowRightPanel
  TextColor
  TimeStamp
  UsedInTypeSPSGlobalConfigurationType
  WelcomeText
  WelcomeTitle
  WelcomeTitleColor
DWPLoginPageConfigurationClass-CI ID
  LCID
  Owner
  TimeStamp
  WelcomeText
  WelcomeTitle
SPSEnvironmentTypePickup DiaplayString
  Hidden
  ID
  Position
  TimeStamp
  Value
SPSEnvironmentTypePickup-CI DiaplayString
  ID
  LCID
  Owner
  TimeStamp

Added Columns

Table Column
PDRThemeClassBase IsAvailable
SPSArticleClassBase OneFromOptionalRequired
SPSGlobalConfigurationClassBase EnvironmentType

Changed Columns

Cgange type TABLE_NAME COLUMN_NAME CharacterLengthDifferent
column changed DWPLoginPageConfigurationClass Logo From 100 to -1

Version 12.0.3

12.0.3.3107 (05.02.2024) 

Deleted Attributes

 

Table Attribute
SPSSecurityGroupClassMember Sid

12.0.3.3092 (Technical Preview; 20.12.2023) 

New Tables

Table Attribute
DWPActionGroupPickup DisplayString
  Hidden
  Icon
  ID
  Position
  TimeStamp
  Value
DWPActionGroupPickup-CI DisplayString
  ID
  LCID
  Owner
  TimeStamp
PDRCustomFilterExpressions DataDefinition
  FilterExpression
  ID
  TimeStamp

Changed Attributes

Table Attribute Change
SPSAccountClassAD HomeDriveUNCPath Length increased from 255 to 4000
SPSAccountClassAD TSHomeDriveUNCPath Length increased from 255 to 4000

New Attributes

 

Table Attribute
LCMLicenseDemandClassBase ConfirmationMissingTaskCreated
PDRActionClassBase Group
PDRNavigationItemClassBase ShowStructureInNavigation
SPSArticleCategoryClassBase Icon
SPSGenericConnectorConfigurationClassAzureAD PrefillPersonsEmail
SPSGlobalConfigurationClassBase ForceNewLookForEveryone
  TelemetryEnabled
SPSSecurityGroupClassMember Sid
PDRThemeClassBase BaseLayoutColor

Version 12.0.2

12.0.2.1197 (Technical Release; 02.10.2023) 

Deleted Attributes

Table Attribute
WFPPromotionsTable Culture

 

12.0.2.1193 (Release candidate; 26.09.2023) 

New Attributes

Table Attribute
SPSArticleClassBase DeclineBookingIfAllChildrenDeclined
SPSGlobalConfigurationClassBase AllowParameterizedFiltersOnly
SPSRemoteAgentClassBase Name

 

Deleted Tables

Table Attribute
AspNetViewState Date
  Expire
  ID

 

Deleted Attributes

Table Attribute
SPSAlertingConfiguration SuiteURL
SPSGlobalConfigurationClassContractManagement UseUuxLinksInEmails
SPSGlobalConfigurationClassLicenseManagement UseUuxLinksInEmails
SPSGlobalConfigurationClassServiceCatalog UseUuxLinksInEmails
SPSGlobalConfigurationClassServiceDesk UseUuxLinksInEmails
WFPPromotionsTable Culture

 

Version 12.0.1

12.0.1.1174 (21.09.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

 

12.0.1.1162 (31.08.2023) 

New Attributes

Table Attribute
SPSGlobalConfigurationClassSecurity Saml2LoginSign
SPSGlobalConfigurationClassServiceDesk InheritTaskOwnershipFromInitiator

12.0.1.1124 (Technical Preview; 03.07.2023) 

New Attributes

 

Table Attribute
PDRActionClassBase ReloadPageOnSuccess
PDRAudienceClass UsedInTypePDRDataQueryType
PDRDataQueryClassBase PrimaryFilter
PDRDataQueryClassBase Priority
PDRThemeClassBase IsActiveForNewUi
SPSActivityClassGroupTicket KnownError
SPSGlobalConfigurationClassServiceDesk DaysAllowedToReopenClosedTicket

Version 12.0

12.0.0.1050 (Release Candidate; 28.03.2023) 

New Tables

Table Attribute
SchemaRelation-SVCDecisionMakerGroupClassBase2SPSSecurityClassRole DecisionMakerGroups
  ID
  Roles
  TimeStamp
SchemaRelation-SVCDecisionMakerGroupClassBase2SPSUserClassBase DecisionMakerGroupss
  ID
  TimeStamp
  Users
SVCDecisionMakerGroupClassBase Description
  Expression-ObjectID
  Expressions
  ID
  Name
  TimeStamp
  TypeID
SVCDecisionMakerGroupClassBase-CI ID
  LCID
  Name
  Owner
  TimeStamp

New Attributes

Table Attribute
SPSGlobalConfigurationClassBase HistoryConsolidationUseAuditService
  HistoryServiceConnection
SPSInventoryClassBase UsedInTypeSPSPrinterType
SPSRatingSummaryClassBase UsedInTypeSPSArticleTypeGroup
  UsedInTypeSPSArticleTypeService
  UsedInTypeSVCServiceTypeBundle
  UsedInTypeSVCServiceTypeConfigGroup

Changed Attributes

Table Attribute Change
PDRAsyncOperationClass OperationName Size increased from
100 to 1000
  • Was this article helpful?