Skip to main content
Matrix42 Self-Service Help Center

Database Schema Changes 10.0.x

List of database schema changes for Software Asset & Service Management 10.0.x

Version 10.0.2

Version 10.0.2.3011 Release Candidate 1 (21.08.2020)

Deleted Tables

Table name
TmpDisabledCustomTriggers

 

Deleted Attributes

Table Attribute
PLSLWorkerClassBase DataProvidersAppState
PLSLWorkerClassBase WorkflowsAppState

 

New Tables

Table name

PDRConfigurationProjectClassAssembly 

PDRConfigurationProjectClassFile 

PDRConfigurationProjectPickupFilesFolders 

ReplaceComplianceRulesIDs 

New Attributes

Table Attribute

ITSMEQMClassBase 

Category 

LCMLicenseDemandClassBase 

LicenseModelSetManually 

LCMLicenseDemandRuleClassBase 

Enabled 

LCMLicenseModelClassBase 

ObsoleteCRRaised 

PDRConfigurationProjectClassBase 

InstallationPSScript 

PDRConfigurationProjectClassBase 

InstallationSQLScript 

PDRConfigurationProjectClassBase 

MaintenanceMode 

PDRConfigurationProjectClassBase 

RecycleWebApplication 

PDRConfigurationProjectClassBase 

RestartM42WindowsServices 

PDRConfigurationProjectClassBase 

UninstallationPSScript 

PDRConfigurationProjectClassBase 

UninstallationSQLScript 

PDRConfigurationProjectClassBase 

UUXWorkspaces 

PDRConfigurationProjectClassChange 

AlwaysFullImport 

PDRConfigurationProjectClassChange 

FullExport 

PLSLWorkerClassBase 

ApplicationsState 

QueueTask 

Worker 

SPSADDomainClassBase 

LdapPort 

SPSADDomainClassBase 

UseSsl 

SPSAlertingConfiguration 

DefaultHeaderFooter 

SPSGlobalConfigurationClassMailBox 

EQMProfile 

SPSGlobalConfigurationClassSecurity 

Saml2LogoutSign 

WFPPromotionsTable Culture

 

Updated Attributes

Table Attribute Details

SchemaScripts 

Name 

Langth was changed FROM 200 TO 400   

SPSComputerClassBase 

DataStoresNames 

Langth was changed FROM 4000 TO -1 

SPSGlobalConfigurationClassServiceCatalog 

OrderRecipientFilter 

Langth was changed FROM 500 TO 1000   

Version 10.0.1

Version 10.0.1.3025 (19.07.2020)

Updated Tables

Table Column Details

SPSComputerClassBase

DataStoresNames

Character Length from 4000 to max

Version 10.0.1.2990 Release Candidate 3 (22.06.2020)

Updated Tables

Table Column Details

ITSMEQMClassBase

Default

Deleted

SPSGenericConnectorClassBase

AppName

Value has changed from '' to Matrix42.DataGateway.Workflow

Version 10.0.1. 2970 Release Candidate 2 (27.05.2020)

 

New Tables

Table
PLSLConnectionTypePickup
PLSLConnectionTypePickup-CI
ReplaceComplianceRulesIDs
PLSLWorkerClassBase

 

New Attributes

Table Attribue
PLSLConnectionTypePickup DisplayString
PLSLConnectionTypePickup Hidden
PLSLConnectionTypePickup ID
PLSLConnectionTypePickup TimeStamp
PLSLConnectionTypePickup Value
PLSLConnectionTypePickup-CI DisplayString
PLSLConnectionTypePickup-CI ID
PLSLConnectionTypePickup-CI LCID
PLSLConnectionTypePickup-CI Owner
PLSLConnectionTypePickup-CI TimeStamp
ReplaceComplianceRulesIDs NewTypeId
ReplaceComplianceRulesIDs OldTypeId

Updated Tables

Table Column Details
PLSLWorkerClassBase DataProvidersAppState Added
PLSLWorkerClassBase ProductionDBConnection Added
PLSLWorkerClassBase WFInstanceDBConnection Added
PLSLWorkerClassBase WFMonitoringDBConnection Added
PLSLWorkerClassBase WorkflowsAppState Added

Version 10.0.1. 2956 Release Candidate 1 (21.05.2020)

Deleted Tables

Table
SVCOperationLevelAgreementType
SVCUnderpinningContractType

Updated Tables

Table Column Details
SPSContractClassBase UsedInTypeSVCOperationLevelAgreementType Deleted
SPSContractClassBase UsedInTypeSVCUnderpinningContractType Deleted
SVCServiceLevelAgreementClassBase UsedInTypeSVCOperationLevelAgreementType Deleted
SVCServiceLevelAgreementClassBase UsedInTypeSVCUnderpinningContractType Deleted
SVCServiceLevelAgreementClassServiceLevels UsedInTypeSVCOperationLevelAgreementType Deleted
SVCServiceLevelAgreementClassServiceLevels UsedInTypeSVCUnderpinningContractType Deleted
SPSSerialNumberClassBase Key Character Length from 100 to 500
SPSSerialNumberClassBase SerialNumber Character Length from 100 to 500
LCMLicenseDemandRuleClassBase CombineCondition Added
LCMLicenseDemandRuleClassBase DataQuery Added
LCMLicenseDemandRuleClassBase EffectiveStatuses Added
LCMLicenseDemandRuleClassBase QuerySchemaType Added
PDRApplicationClassBase PrintLayout Added
PLSLWorkerClassBase IsDefault Added
PLSLWorkerClassBase IsLocal Added
PLSLWorkerClassBase LastHostAddress Added
PLSLWorkerClassBase LocationHash Added
PLSLWorkerClassBase RemoteAgent Added
PLSLWorkerClassBase Trusted Added
PLSLWorkerClassBase UpdateInterval Added
PLSLWorkflowProcessInstanceClassBase HasPersistencePoint Added
PLSLWorkflowProcessInstanceClassBase WorkerName Added
SPSActivityClassBase Queue Added
SPSADDomainClassBase DirectoryType Added
SPSComputerClassBase IsVirtual Added
SPSComputerClassBase VmType Added
SPSGenericConnectorConfigurationClassAzureAD SkipImportDeletedObjects Added
SPSGenericConnectorConfigurationClassBase PasswordPhrase Added
SPSGenericConnectorConfigurationClassBase PrivateKey Added
SPSGenericConnectorConfigurationClassBase UsePubkeyAuth Added
SPSGlobalConfigurationClassBase DefaultPrintLayout Added
SPSGlobalConfigurationClassBase InMaintenance Added
SPSGlobalConfigurationClassBase CallTrackerAdditionalPhoneAttributes Added
SPSUserClassBase ActiveConfigurationProject Added
SVCServiceLevelAgreementClassBase SLA_Type Added

New Tables

Table
ASMVirtualMachineTypePickup
ASMVirtualMachineTypePickup-CI
ITSMEQMClassBase
ITSMEQMClassBase-CI
ITSMEQMProfileStatusPickup
ITSMEQMProfileStatusPickup-CI
ITSMEQMType
LCMOracleProcessorCoreFactorClassBase
PDRConfigurationPackageClassBase
PDRConfigurationProjectClassBase
PDRConfigurationProjectClassChange
PDRConfigurationProjectPickupOperation
PDRConfigurationProjectPickupOperation-CI
PDRDirectoryClassAuth
PDRDirectoryClassAuth-CI
PDRDirectoryTypePickup
PDRDirectoryTypePickup-CI
PDRPrintLayoutClassBase
SchemaRelation-ITSMEQMClassBase2SPSSecurityClassRole
SchemaRelation-ITSMEQMClassBase2SPSUserClassBase0
SchemaRelation-ITSMEQMClassBase2SPSUserSkillGroupsClassBase
SPSActivityAgileTypePickup
SPSActivityAgileTypePickup-CI
SPSActivityClassAgile
SPSGlobalConfigurationClassEQM
SVCServiceLevelAgreementTypePickup
SVCServiceLevelAgreementTypePickup-CI

New Attributes

Table Attribue
ASMVirtualMachineTypePickup Color
ASMVirtualMachineTypePickup DisplayString
ASMVirtualMachineTypePickup Hidden
ASMVirtualMachineTypePickup ID
ASMVirtualMachineTypePickup Image
ASMVirtualMachineTypePickup Position
ASMVirtualMachineTypePickup TimeStamp
ASMVirtualMachineTypePickup Value
ASMVirtualMachineTypePickup-CI DisplayString
ASMVirtualMachineTypePickup-CI ID
ASMVirtualMachineTypePickup-CI LCID
ASMVirtualMachineTypePickup-CI Owner
ASMVirtualMachineTypePickup-CI TimeStamp
ITSMEQMClassBase Color
ITSMEQMClassBase CostCenter
ITSMEQMClassBase Default
ITSMEQMClassBase Description
ITSMEQMClassBase Expression-ObjectID
ITSMEQMClassBase ID
ITSMEQMClassBase Location
ITSMEQMClassBase Name
ITSMEQMClassBase NeedApproveOnUnassign
ITSMEQMClassBase OU
ITSMEQMClassBase Status
ITSMEQMClassBase TimeStamp
ITSMEQMClassBase UsedInTypeITSMEQMType
ITSMEQMClassBase-CI Description
ITSMEQMClassBase-CI ID
ITSMEQMClassBase-CI LCID
ITSMEQMClassBase-CI Name
ITSMEQMClassBase-CI Owner
ITSMEQMClassBase-CI TimeStamp
ITSMEQMProfileStatusPickup DisplayString
ITSMEQMProfileStatusPickup Hidden
ITSMEQMProfileStatusPickup ID
ITSMEQMProfileStatusPickup Position
ITSMEQMProfileStatusPickup TimeStamp
ITSMEQMProfileStatusPickup Value
ITSMEQMProfileStatusPickup-CI DisplayString
ITSMEQMProfileStatusPickup-CI ID
ITSMEQMProfileStatusPickup-CI LCID
ITSMEQMProfileStatusPickup-CI Owner
ITSMEQMProfileStatusPickup-CI TimeStamp
ITSMEQMType ID
ITSMEQMType TimeStamp
LCMOracleProcessorCoreFactorClassBase CPUType
LCMOracleProcessorCoreFactorClassBase ID
LCMOracleProcessorCoreFactorClassBase MatchingExpr
LCMOracleProcessorCoreFactorClassBase OracleCoreFactor
LCMOracleProcessorCoreFactorClassBase TimeStamp
LCMOracleProcessorCoreFactorClassBase Vendor
PDRConfigurationPackageClassBase Description
PDRConfigurationPackageClassBase Expression-ObjectID
PDRConfigurationPackageClassBase FileName
PDRConfigurationPackageClassBase ID
PDRConfigurationPackageClassBase InstalledDate
PDRConfigurationPackageClassBase LastUpdatedDate
PDRConfigurationPackageClassBase Name
PDRConfigurationPackageClassBase PackageID
PDRConfigurationPackageClassBase TimeStamp
PDRConfigurationPackageClassBase TypeID
PDRConfigurationPackageClassBase UpdatedBy
PDRConfigurationPackageClassBase Vendor
PDRConfigurationPackageClassBase Version
PDRConfigurationProjectClassBase CreatedDate
PDRConfigurationProjectClassBase Description
PDRConfigurationProjectClassBase Expression-ObjectID
PDRConfigurationProjectClassBase ID
PDRConfigurationProjectClassBase LastUpdateDate
PDRConfigurationProjectClassBase MajorCurrentVersion
PDRConfigurationProjectClassBase MajorReleaseVersion
PDRConfigurationProjectClassBase MinorCurrentVersion
PDRConfigurationProjectClassBase MinorReleaseVersion
PDRConfigurationProjectClassBase Name
PDRConfigurationProjectClassBase Owner
PDRConfigurationProjectClassBase TechnicalName
PDRConfigurationProjectClassBase TimeStamp
PDRConfigurationProjectClassBase TypeID
PDRConfigurationProjectClassChange ArtifactType
PDRConfigurationProjectClassChange ChangedBy
PDRConfigurationProjectClassChange Date
PDRConfigurationProjectClassChange Descriptor
PDRConfigurationProjectClassChange Expression-ObjectID
PDRConfigurationProjectClassChange ID
PDRConfigurationProjectClassChange MajorPackageVersion
PDRConfigurationProjectClassChange MinorPackageVersion
PDRConfigurationProjectClassChange ObjectID
PDRConfigurationProjectClassChange ObjectName
PDRConfigurationProjectClassChange Operation
PDRConfigurationProjectClassChange SchemaName
PDRConfigurationProjectClassChange SchemaScriptBuild
PDRConfigurationProjectClassChange SchemaScriptMajor
PDRConfigurationProjectClassChange SchemaScriptMinor
PDRConfigurationProjectClassChange SchemaScriptName
PDRConfigurationProjectClassChange SchemaScriptType
PDRConfigurationProjectClassChange TimeStamp
PDRConfigurationProjectClassChange UsedInTypePDRConfigurationProjectType
PDRConfigurationProjectPickupOperation DisplayString
PDRConfigurationProjectPickupOperation Hidden
PDRConfigurationProjectPickupOperation ID
PDRConfigurationProjectPickupOperation Position
PDRConfigurationProjectPickupOperation TimeStamp
PDRConfigurationProjectPickupOperation Value
PDRConfigurationProjectPickupOperation-CI DisplayString
PDRConfigurationProjectPickupOperation-CI ID
PDRConfigurationProjectPickupOperation-CI LCID
PDRConfigurationProjectPickupOperation-CI Owner
PDRConfigurationProjectPickupOperation-CI TimeStamp
PDRDirectoryClassAuth Expression-ObjectID
PDRDirectoryClassAuth ID
PDRDirectoryClassAuth IdentityProviderCertificate
PDRDirectoryClassAuth NameIdAllowCreate
PDRDirectoryClassAuth NameIdPolicy
PDRDirectoryClassAuth Saml2IdentityProviderID
PDRDirectoryClassAuth ServiceProviderIssuerName
PDRDirectoryClassAuth ShowLoginButton
PDRDirectoryClassAuth SignInButtonTitle
PDRDirectoryClassAuth SingleSignOnUriEndpoint
PDRDirectoryClassAuth SingleSignOutUriEndpoint
PDRDirectoryClassAuth TenantId
PDRDirectoryClassAuth TimeStamp
PDRDirectoryClassAuth UsedInTypeSPSADDomainType
PDRDirectoryClassAuth-CI ID
PDRDirectoryClassAuth-CI LCID
PDRDirectoryClassAuth-CI Owner
PDRDirectoryClassAuth-CI SignInButtonTitle
PDRDirectoryClassAuth-CI TimeStamp
PDRDirectoryTypePickup DisplayString
PDRDirectoryTypePickup Hidden
PDRDirectoryTypePickup ID
PDRDirectoryTypePickup Position
PDRDirectoryTypePickup TimeStamp
PDRDirectoryTypePickup Value
PDRDirectoryTypePickup-CI DisplayString
PDRDirectoryTypePickup-CI ID
PDRDirectoryTypePickup-CI LCID
PDRDirectoryTypePickup-CI Owner
PDRDirectoryTypePickup-CI TimeStamp
PDRPrintLayoutClassBase Expression-ObjectID
PDRPrintLayoutClassBase Footer
PDRPrintLayoutClassBase Header
PDRPrintLayoutClassBase ID
PDRPrintLayoutClassBase Name
PDRPrintLayoutClassBase TimeStamp
PDRPrintLayoutClassBase TypeID
SchemaRelation-ITSMEQMClassBase2SPSSecurityClassRole ID
SchemaRelation-ITSMEQMClassBase2SPSSecurityClassRole Queue
SchemaRelation-ITSMEQMClassBase2SPSSecurityClassRole Role
SchemaRelation-ITSMEQMClassBase2SPSSecurityClassRole TimeStamp
SchemaRelation-ITSMEQMClassBase2SPSUserClassBase0 ID
SchemaRelation-ITSMEQMClassBase2SPSUserClassBase1 ManagedBy
SchemaRelation-ITSMEQMClassBase2SPSUserClassBase2 ManageQueue
SchemaRelation-ITSMEQMClassBase2SPSUserClassBase3 TimeStamp
SchemaRelation-ITSMEQMClassBase2SPSUserSkillGroupsClassBase ID
SchemaRelation-ITSMEQMClassBase2SPSUserSkillGroupsClassBase QueueRequirements
SchemaRelation-ITSMEQMClassBase2SPSUserSkillGroupsClassBase RequiredSkills
SchemaRelation-ITSMEQMClassBase2SPSUserSkillGroupsClassBase TimeStamp
SPSActivityAgileTypePickup DisplayString
SPSActivityAgileTypePickup Hidden
SPSActivityAgileTypePickup ID
SPSActivityAgileTypePickup Image
SPSActivityAgileTypePickup Position
SPSActivityAgileTypePickup TimeStamp
SPSActivityAgileTypePickup Value
SPSActivityAgileTypePickup-CI DisplayString
SPSActivityAgileTypePickup-CI ID
SPSActivityAgileTypePickup-CI LCID
SPSActivityAgileTypePickup-CI Owner
SPSActivityAgileTypePickup-CI TimeStamp
SPSActivityClassAgile BusinessValue
SPSActivityClassAgile Effort
SPSActivityClassAgile ID
SPSActivityClassAgile Sprint
SPSActivityClassAgile StackRank
SPSActivityClassAgile TimeStamp
SPSActivityClassAgile Type
SPSGlobalConfigurationClassEQM Enabled
SPSGlobalConfigurationClassEQM Expression-ObjectID
SPSGlobalConfigurationClassEQM ID
SPSGlobalConfigurationClassEQM TimeStamp
SPSGlobalConfigurationClassEQM UsedInTypeSPSGlobalConfigurationType
SVCServiceLevelAgreementTypePickup DisplayString
SVCServiceLevelAgreementTypePickup Hidden
SVCServiceLevelAgreementTypePickup ID
SVCServiceLevelAgreementTypePickup Position
SVCServiceLevelAgreementTypePickup TimeStamp
SVCServiceLevelAgreementTypePickup Value
SVCServiceLevelAgreementTypePickup-CI DisplayString
SVCServiceLevelAgreementTypePickup-CI ID
SVCServiceLevelAgreementTypePickup-CI LCID
SVCServiceLevelAgreementTypePickup-CI Owner
SVCServiceLevelAgreementTypePickup-CI TimeStamp

Version 10.0

Version 10.0.0.2944 (04.04.2020)

New Attributes

Table Attribute

SPSGlobalConfigurationClassServiceDesk

CallTrackerAdditionalPhoneAttributes

Version 10.0.0.2934 (General Availability)

New Tables

Table
PLSLProcessPickupStateReason
PLSLProcessPickupStateReason-CI
WFPBookmarks
WorkerQueueStatistics

New Attributes

Table Attribute
PLSLProcessPickupStateReason Color
PLSLProcessPickupStateReason DisplayString
PLSLProcessPickupStateReason Hidden
PLSLProcessPickupStateReason ID
PLSLProcessPickupStateReason Image
PLSLProcessPickupStateReason Position
PLSLProcessPickupStateReason TimeStamp
PLSLProcessPickupStateReason Value
PLSLProcessPickupStateReason-CI DisplayString
PLSLProcessPickupStateReason-CI ID
PLSLProcessPickupStateReason-CI LCID
PLSLProcessPickupStateReason-CI Owner
PLSLProcessPickupStateReason-CI TimeStamp
WFPBookmarks BookmarkName
WFPBookmarks InstanceId
WFPBookmarks Type
WFPBookmarks Value
WorkerQueueStatistics Count
WorkerQueueStatistics Interval
WorkerQueueStatistics LastUpdated
WorkerQueueStatistics TotalTimeSec
LISApplicationMatchEntryClassBase StandardSLA
LISLicenseCatalogItemClassBase StandardSLA
PLSLProcessInstanceClassBase StateReason
PLSLWorkerClassBase StateDescription
PLSLWorkflowProcessInstanceClassBase BookmarkInputArguments
PLSLWorkflowProcessInstanceClassBase BookmarkName
QueueTask StatusDescription
SPSComputerClassBase ConnectionState
SPSComputerClassBase DataCenter
SPSComputerClassBase DataStoresNames
SPSComputerClassBase inMaintenanceMode
SPSComputerClassBase IsStandalone
SPSComputerClassBase VCenterServerName
SPSComputerClassBase VCenterVersion
SPSComputerClassBase VmotionEnabled

 

Updated Tables

Table Name COLUMN Details
PDRContentWidgetTemplateView Expression-ObjectID Updated AllowNull From YES to NO
PLSLMessageCommandClassBase Expression-ObjectID Updated AllowNull From YES to NO
PLSLWebServiceOperation Expression-ObjectID Updated AllowNull From YES to NO
PLSTSApiTokenBase Expression-ObjectID Updated AllowNull From YES to NO
SPSAssetClassBase Name Updated length FROM 150 to 300
VirtualComputerAssignedUserProposal Name Updated length FROM 100 to 255

Version 10.0.0.2846 (Technical Preview 1)

New Attributes

Table Attribute
LISApplicationMatchEntryClassBase

StandardSLA

LISLicenseCatalogItemClassBase

StandardSLA

 

Version 9.1

Database schema changes of version 9.0 can be found here.

  • Was this article helpful?