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.3

Version 10.0.3.3089 (13.10.2020) - Release Candidate 1

New Tables

Table name
PDRConfigurationProjectClassPackage
SchemaRelation-PDRConfigurationPackageClassBase2PDRConfigurationPackageClassBase

Changed Attributes

Table Attribute Change
SPSGenericConnectorConfigurationClassSilverback ApiKey Length changed from 2000 to 4000

New Attributes

Table Attribute
PDRConfigurationProjectClassBase

MinimalRequiredProductVersion

SPSAssetClassBase SDDMConfigurationItemID
SPSComputerClassBase VmWareUUID
SPSGlobalConfigurationClassSecurity AllowExtensionGalleryToInstallPackages
SPSSecurityGroupClassMember Sid-Calc
WFPPromotionsTable Culture

Version 10.0.3.3048 (13.10.2020) - Technical Preview 1

New Attributes

Table Attribute

SPSGenericConnectorConfigurationClassAzureAD

ExtensionApplicationID

SPSGenericConnectorConfigurationClassAzureAD

ExtensionApplicationIDIsAppClientID

Version 10.0.2

Version 10.0.2.3077 (16.11.2020)

New Attributes

Table Attribute
SPSGlobalConfigurationClassSecurity  AllowExtensionGalleryToInstallPackages

Version 10.0.2.3047 (01.10.2020)

Updated Attributes

Table Attribute Details
SPSCurrencyExchangeRateClassItem Ask Precision changed FROM 11 TO 22 
SPSCurrencyExchangeRateClassItem Bid Precision changed FROM 11 TO 22  

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 LCMLicenseDemandClassBase
LCMLicenseDemandRuleClassBase Enabled
LCMLicenseModelClassBase ObsoleteCRRaised
PDRConfigurationProjectClassBase InstallationPSScript
PDRConfigurationProjectClassBase InstallationSQLScript
PDRConfigurationProjectClassBase MaintenanceMode
PDRConfigurationProjectClassBase RecycleWebApplication
PDRConfigurationProjectClassBase RestartM42WindowsServices
PDRConfigurationProjectClassBase PDRConfigurationProjectClassBase
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 Length was changed FROM 200 TO 400
SPSComputerClassBase DataStoresNames Length was changed FROM 4000 TO -1 
SPSGlobalConfigurationClassServiceCatalog OrderRecipientFilter Length was changed FROM 500 TO 1000 

Version 10.0.1

Version 10.0.1.3050 (12.10.2020)

New Attributes

Table Attribute
SPSGenericConnectorConfigurationClassAzureAD ExtensionApplicationID
SPSGenericConnectorConfigurationClassAzureAD ExtensionApplicationIDIsAppClientID

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?