Skip to main content
Matrix42 Self-Service Help Center

Database Schema Changes 9.1.x

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

Version 9.1.3

Version 9.1.3.2754 (Technical Preview 1)

New Tables

Table 
PLSLWorkflowEnginePickupType
PLSLWorkflowEnginePickupType-CI
ReplaceComplianceRulesIDs
uvw_GetMobileDeviceToMatch

New Attributes

Table  Attribute 
PLSLWorkflowEnginePickupType DisplayString
PLSLWorkflowEnginePickupType Hidden
PLSLWorkflowEnginePickupType ID
PLSLWorkflowEnginePickupType Position
PLSLWorkflowEnginePickupType TimeStamp
PLSLWorkflowEnginePickupType Value
PLSLWorkflowEnginePickupType-CI DisplayString
PLSLWorkflowEnginePickupType-CI LCID
PLSLWorkflowEnginePickupType-CI ID
PLSLWorkflowEnginePickupType-CI Owner
PLSLWorkflowEnginePickupType-CI TimeStamp
ReplaceComplianceRulesIDs NewTypeId
ReplaceComplianceRulesIDs OldTypeId
uvw_GetMobileDeviceToMatch CompMobileTypeID
uvw_GetMobileDeviceToMatch DeviceType
uvw_GetMobileDeviceToMatch ID
uvw_GetMobileDeviceToMatch MDMSilverbackDeviceID
uvw_GetMobileDeviceToMatch Name
uvw_GetMobileDeviceToMatch RelatedComputer
uvw_GetMobileDeviceToMatch RelatedMobileID
uvw_GetMobileDeviceToMatch UsedInTypeSPSAssetTypeMobile
PLSLWorkerClassBase ComputerAlias
PLSLWorkflowProcessInstanceClassBase Engine
SPSAssetClassLicenseBaseLicense AllowUpgradeToUnlimited
SPSAssetClassLicenseMaintenance Settings
SPSAssetClassLicenseMaintenance ValidFrom
SPSAssetClassMobile RelatedMobile
SPSComputerClassBase ClusterNames
SPSGenericConnectorConfigurationClassAirWatch EnableDeviceUserAutoAssignment
SPSGlobalConfigurationClassLicenseManagement Agent
SPSSoftwareClassBase AutoCreateLRQForFingerprint
SPSUserSkillGroupsClassBase Description
SPSUserSkillGroupsClassBase Parent

Updated Tables

Table Name COLUMN Details
SPSGlobalConfigurationClassMailBox Password Updated length FROM 100 TO 200

Version 9.1.2

Version 9.1.2.2762

Deleted Tables

Table

ReplaceComplianceRulesIDs

New Attributes

Table  Attribute 
SPSActivityClassTimeTracking ManuallyChanged

 

Updated Tables

Table Attribute 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
VirtualComputerAssignedUserProposal Name Updated length FROM 100 TO 255

Version 9.1.2.2757

Updated Tables

Table Name COLUMN Details

SPSComputerClassBase

ClusterName

Updated length FROM 100 TO 4000

Version 9.1.2.2737

New Tables

Table 
SchemaRelation-SPSActivityClassBase2SPSUserSkillsClassBase
SchemaRelation-SPSScCategoryClassBase2SPSUserSkillsClassBase
SchemaRelation-SPSScRoleClassBase2SPSUserSkillsClassBase
SchemaRelation-SPSUserClassBase2SPSUserSkillGroupsClassBase
SPSActivityClassBase-RequiredSkills
SPSUserSkillGroupsClassBase

New Attributes

Table  Attribute 
SchemaRelation-SPSActivityClassBase2SPSUserSkillsClassBase Activities
SchemaRelation-SPSActivityClassBase2SPSUserSkillsClassBase ID
SchemaRelation-SPSActivityClassBase2SPSUserSkillsClassBase RequiredSkills
SchemaRelation-SPSActivityClassBase2SPSUserSkillsClassBase TimeStamp
SchemaRelation-SPSScCategoryClassBase2SPSUserSkillsClassBase Categories
SchemaRelation-SPSScCategoryClassBase2SPSUserSkillsClassBase ID
SchemaRelation-SPSScCategoryClassBase2SPSUserSkillsClassBase RequiredSkills
SchemaRelation-SPSScCategoryClassBase2SPSUserSkillsClassBase TimeStamp
SchemaRelation-SPSScRoleClassBase2SPSUserSkillsClassBase ID
SchemaRelation-SPSScRoleClassBase2SPSUserSkillsClassBase Roles
SchemaRelation-SPSScRoleClassBase2SPSUserSkillsClassBase Skills
SchemaRelation-SPSScRoleClassBase2SPSUserSkillsClassBase TimeStamp
SchemaRelation-SPSUserClassBase2SPSUserSkillGroupsClassBase ID
SchemaRelation-SPSUserClassBase2SPSUserSkillGroupsClassBase Skills
SchemaRelation-SPSUserClassBase2SPSUserSkillGroupsClassBase TimeStamp
SchemaRelation-SPSUserClassBase2SPSUserSkillGroupsClassBase Users
SPSActivityClassBase-RequiredSkills Inner
SPSActivityClassBase-RequiredSkills Outer
SPSUserSkillGroupsClassBase DisplayString
SPSUserSkillGroupsClassBase Expression-ObjectID
SPSUserSkillGroupsClassBase ID
SPSUserSkillGroupsClassBase Position
SPSUserSkillGroupsClassBase TimeStamp
SPSUserSkillGroupsClassBase TypeID
SPSGlobalConfigurationClassServiceDesk EnableUserChangeSkillsInUserProfile

Version 9.1.2.2729

Deleted Tables

Table

ReplaceComplianceRulesIDs 

Version 9.1.2.2707 (General Availability)

Deleted Tables

Table

TmpDisabledCustomTriggers

New Tables

Table 
PLSLWorkerClassBase
PLSLWorkerPickupStatus
PLSLWorkerPickupStatus-CI
ReplaceComplianceRulesIDs
SchemaRelation-SVCApprovalTaskClassBase2SPSScRoleClassBase
SchemaRelation-SVCApprovalTaskClassBase2SPSUserClassBase
SPSGlobalConfigurationClassTimeTracking
SVMTimeTrackingPickupMode
SVMTimeTrackingPickupMode-CI
WFPInstancesTable
WFPLockOwnersTable
WFPPromotionsTable

New Attributes

Table  Attribute 
TimeTrackingConfigurationPDRActionClassBase Purpose
PDRContentWidgetClassList CalendarDefaultView
PDRContentWidgetClassList CalendarEventIsBackgroundColumn
PDRContentWidgetClassList CalendarEventIsReadOnlyColumn
PDRContentWidgetClassList CalendarEventIsWholeDayColumn
PDRContentWidgetClassList CalendarExtraDimensionImageColumn
PDRContentWidgetClassList CalendarExtraDimensionRelation
PDRContentWidgetClassList CalendarItemColorColumn
PDRContentWidgetClassList GroupByExtraDimension
PDRContentWidgetClassList ShowDayView
PDRContentWidgetClassList ShowMonthView
PDRContentWidgetClassList ShowWeekView
SPSAssetClassMobile UsedInTypeSPSComputerType
SPSGlobalConfigurationClassAssetManagement UEMMode
SPSGlobalConfigurationClassAssetManagement UEMPermissionsBackup
SPSGlobalConfigurationClassBase WorkflowEngineType
SPSGlobalConfigurationClassLicenseManagement UseComplianceReconciliationWorkflow
SPSScRoleClassBase TimeTrackingConfiguration
SPSSecurityClassRole ManagedBy
SPSUserClassBase TimeTrackingConfiguration

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
SchemaVersion CustomPickupVersionDate Chnaged FROM ''20190401 13:45:50' 16:32:13' TO '20190903 17:25:42'
SPSActivityClassTimeTracking Minutes Changed type FROM int to float. Precision changed from 10 to 53. Radix changed from 10 to 2
SPSActivityClassTimeTracking Minutes Changed type FROM int to float. Precision changed from 10 to 53. Radix changed from 10 to 2
SPSAddressClassBase Phone Updated length FROM 50 TO 64
SPSUserClassBase BusinessPhone Updated length FROM 50 TO 64
SPSUserClassBase IPPhone Updated length FROM 50 TO 64
SPSUserClassBase MobilePhone Updated length FROM 50 TO 64
SPSUserClassBase PrivatePhone Updated length FROM 50 TO 64
VirtualComputerAssignedUserProposal Name Updated length FROM 100 TO 255

 

Version 9.1.2.2686 (Release Candidate 1)

Deleted Tables

Table

TmpDisabledCustomTriggers

New Tables

Table

PLSLWorkerClassBase

PLSLWorkerPickupStatus

PLSLWorkerPickupStatus-CI

ReplaceComplianceRulesIDs

SchemaRelation-SVCApprovalTaskClassBase2SPSScRoleClassBase

SchemaRelation-SVCApprovalTaskClassBase2SPSUserClassBase

SPSGlobalConfigurationClassTimeTracking

SVMTimeTrackingPickupMode

SVMTimeTrackingPickupMode-CI

WFPInstancesTable

WFPLockOwnersTable

WFPPromotionsTable

New Attributes

Table Attribute

PDRContentWidgetClassList

CalendarDefaultView

PDRContentWidgetClassList

CalendarEventIsBackgroundColumn

PDRContentWidgetClassList

CalendarEventIsReadOnlyColumn

PDRContentWidgetClassList

CalendarEventIsWholeDayColumn

PDRContentWidgetClassList

CalendarExtraDimensionImageColumn

PDRContentWidgetClassList

CalendarExtraDimensionRelation

PDRContentWidgetClassList

CalendarItemColorColumn

PDRContentWidgetClassList

GroupByExtraDimension

PDRContentWidgetClassList

ShowDayView

PDRContentWidgetClassList

ShowMonthView

PDRContentWidgetClassList

ShowWeekView

SPSAssetClassMobile

UsedInTypeSPSComputerType

SPSGlobalConfigurationClassAssetManagement

UEMMode

SPSGlobalConfigurationClassAssetManagement

UEMPermissionsBackup

SPSGlobalConfigurationClassBase

WorkflowEngineType

SPSGlobalConfigurationClassLicenseManagement

UseComplianceReconciliationWorkflow

SPSScRoleClassBase

TimeTrackingConfiguration

SPSSecurityClassRole

ManagedBy

SPSUserClassBase

TimeTrackingConfiguration

Updated Tables

Table Attribute 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

SchemaVersion

CustomPickupVersionDate

Chnaged FROM '20181210 16:32:13' TO '20190821 06:28:13'

SPSActivityClassTimeTracking

Minutes

Changed type FROM int to float. Precision changed from 10 to 53. Radix changed from 10 to 2

SPSActivityClassTimeTracking

Minutes

Changed type FROM int to float. Precision changed from 10 to 53. Radix changed from 10 to 2

SPSAddressClassBase

Phone

Updated length FROM 50 TO 64

SPSUserClassBase

BusinessPhone

Updated length FROM 50 TO 64

SPSUserClassBase

IPPhone

Updated length FROM 50 TO 64

SPSUserClassBase

MobilePhone

Updated length FROM 50 TO 64

SPSUserClassBase

PrivatePhone

Updated length FROM 50 TO 64

VirtualComputerAssignedUserProposal

Name

Updated length FROM 100 TO 255

Version 9.1.2.2584 (Technical Preview 1)

Deleted Columns

Table Attribute

SPSGlobalConfigurationClassServiceDesk

ConsiderServiceTimeProfilesInTimeTracking

SPSGlobalConfigurationClassServiceDesk

DisableAutoTimetrackingForMultiObjects

SPSGlobalConfigurationClassServiceDesk

EnableAutoTimetracking

New Tables

Table

SchemaRelation-SVCApprovalTaskClassBase2SPSScRoleClassBase

SchemaRelation-SVCApprovalTaskClassBase2SPSUserClassBase

SPSGlobalConfigurationClassTimeTracking

SVMTimeTrackingPickupMode

SVMTimeTrackingPickupMode-CI

New Attributes

Table Attribute

PDRContentWidgetClassList

CalendarDefaultView

PDRContentWidgetClassList

CalendarEventIsReadOnlyColumn

PDRContentWidgetClassList

CalendarEventIsWholeDayColumn

PDRContentWidgetClassList

CalendarExtraDimensionImageColumn

PDRContentWidgetClassList

CalendarExtraDimensionRelation

PDRContentWidgetClassList

CalendarItemColorColumn

PDRContentWidgetClassList

GroupByExtraDimension

PDRContentWidgetClassList

ShowDayView

PDRContentWidgetClassList

ShowMonthView

PDRContentWidgetClassList

ShowWeekView

SPSScRoleClassBase

TimeTrackingConfiguration

SPSUserClassBase

TimeTrackingConfiguration

Version 9.1.1

Version 9.1.1.2613


Deleted Tables

Table
ReplaceComplianceRulesIDs

New Tables

Table
TmpDisabledCustomTriggers

New Attributes

Table Attribute
TmpDisabledCustomTriggers TableName
TmpDisabledCustomTriggers TriggerName

Updated Tables

Table Attribute Details
SchemaVersion CustomPickupVersionDate Default value has changed
from '20190903 14:51:27' to '20190610 13:43:52'

Version 9.1.1.2596

New Attributes

Table Attribute

SPSTargetingClassTarget

UsedInTypeSPSArticleTypeGroup

SPSTargetingClassTarget

UsedInTypeSPSArticleTypeService

SPSTargetingClassTarget

UsedInTypeSVCServiceTypeBundle

SPSTargetingClassTarget

UsedInTypeSVCServiceTypeConfigGroup

Updated Tables

Table Attribute Details
SchemaVersion CustomPickupVersionDate Default value has changed
from '20190807 13:52:18' to '20190814 15:09:00'

Version 9.1.1.2577

New Attributes

Table Attribute

SPSGlobalConfigurationClassBase

OpenDialogIfNoPreview

Version 9.1.1.2540

Updated Tables

Table Attribute Details
SPSConnectorPickupMatchingAttributes DisplayString

attribute for pickup was marked as not localizable

Version 9.1.1.2528

New Tables

Table

GDIEImportClassBase-CI

PDRDataQueryClassBase-CI

PDRThemeClassBase-CI

PLBEServiceInterfaceClassBase-CI

PLRECategoryClassBase-CI

SPSAccountClassBase-CI

SPSApplicationClassBase-CI

SPSConnectorManagementTypePickup-CI

SPSGenericConnectorClassBase-CI

SPSGenericConnectorConfigurationClassBase-CI

SPSGlobalConfigurationClassServiceCatalog-CI

SVCServiceLevelAgreementClassBase-CI

SVCServiceLevelAgreementClassServiceLevels-CI

SVMChangeTemplateClassBase-CI

SVMServiceTimeProfileClassBase-CI

New Attributes

Table Attribute

PDRApplicationClassBase-CI

Description

PDRControlDescriptorClassProperty-CI

Description

PDRDataQueryClassFilter-CI

Description

SPSArticleClassBase-CI

Description

SPSArticleClassBase-CI

Name

SPSArticlePickupSet

CollapsedByDefault

SPSCommonPickupObjectStateReason-CI

ReasonDescription

SPSCommonPickupObjectStatus-CI

StateDescription

SPSGlobalConfigurationClassLicenseManagement

RelevantForSoftwareStatuses

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageComputerList

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageConfigPath

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageConfigReloadInterval

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageEnabled

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageMigrated

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageNetworkCredentialsDomain

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageNetworkCredentialsPassword

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageNetworkCredentialsUser

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageReportInterval

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageScanInterval

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageServiceUrl

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageTargetFolder

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageUseNetworkSharing

SPSGlobalConfigurationClassLicenseManagement

RemoteUsageUseProcessCredentials

SPSPortfolioClassbase-CI

Description

SVMEmailTemplateClassBase-CI

Name

Updated Tables

Table Attribute Details

PDRControllerClassBase

ControllerUrl

Length changed FROM 255 TO 500

SPSAccountClassADUSer

Pager

Length changed FROM 50 TO 64

SPSAccountClassBase

Description

Length changed FROM 1000 TO 1024

SPSAccountClassBase

DisplayName

Length changed FROM 100 TO 256

SPSAddressClassBase

Street

Length changed FROM 255 TO 1024

SPSAssetClassBase

Description

Length changed FROM 1000 TO 1024

SPSComputerClassBase

Name

Length changed FROM 100 TO 255

SPSConnectorPackageItemPickupType

DisplayString

Length changed FROM 50 TO 200

SPSConnectorPackageItemPickupType-CI

DisplayString

Length changed FROM 50 TO 200

SPSUserClassBase

Description

Length changed FROM 1000 TO 1024

SPSUserClassBase

DisplayName

Length changed FROM 200 TO 256

SPSUserClassBase

Pager

Length changed FROM 30 TO 64

Version 9.1

Version 9.1.0.2524

Deleted Tables

Table

ReplaceComplianceRulesIDs

New Tables

Table

TmpDisabledCustomTriggers

New Attributes

Table Attribute

SPSGlobalConfigurationClassServiceDesk

AutoApplyingTightestSLA

Updated Tables

Table Attribute Details

SPSContractItemClassBase

PeriodUnits

Default value has changed from 1 to 0

SchemaVersion CustomPickupVersionDate Default value has changed
from '20190402 10:20:30' to '20190319 19:19:49'

Version 9.1.0.2502

Deleted Tables

Table

LCMSoftwareProductClassBase_Temp

SPSAssetTypeLicenseBaseAssoc

SPSAssetTypeLicenseOEM

SPSAssetTypeLicenseUpdate

TmpDisabledCustomTriggers

Deleted Attributes

Table Attribute

SPSAssetClassBase

UsedInTypeSPSAssetTypeLicenseOEM

SPSAssetClassBase

UsedInTypeSPSAssetTypeLicenseUpdate

SPSAssetClassLicense

UsedInTypeSPSAssetTypeLicenseOEM

SPSAssetClassLicense

UsedInTypeSPSAssetTypeLicenseUpdate

SPSAssetClassLicenseBaseAssoc

Expression-ObjectID

SPSAssetClassLicenseBaseAssoc

UsedInTypeSPSAssetTypeLicenseBaseAssoc

SPSAssetClassLicenseExclusiveUsage

UsedInTypeSPSAssetTypeLicenseOEM

SPSAssetClassLicenseExclusiveUsage

UsedInTypeSPSAssetTypeLicenseUpdate

SPSAssetClassLicenseMaintenance

UsedInTypeSPSAssetTypeLicenseOEM

SPSAssetClassLicenseMaintenance

UsedInTypeSPSAssetTypeLicenseUpdate

SPSAssetClassOrder

UsedInTypeSPSAssetTypeLicenseOEM

SPSAssetClassOrder

UsedInTypeSPSAssetTypeLicenseUpdate

SPSSerialNumberClassBase

UsedInTypeSPSAssetTypeLicenseOEM

SPSSerialNumberClassBase

UsedInTypeSPSAssetTypeLicenseUpdate

New Tables

Table

ReplaceComplianceRulesIDs

SchemaRelation-SPSActivityClassBase2SPSUserClassBase_NotifyUsers

SPSActivityClassBase-NotifyUsers

New Attributes

Table Attribute

PDRContentWidgetClassDialog

HideHeaderTitle

PDRContentWidgetClassDialog

NotUseInCreateEditPurposes

PDRContentWidgetClassList

CalendarShowHolidays

PLSLServiceClassBase

DocumentationLink

PLSLWebServiceOperation

DocumentationLink

PLSLWebServiceOperation

IsPublic

SPSArticleGroupClassArticle

AllowChangeQuantity

SPSArticlePickupSet

UseDropdownToSelectOptions

SPSGlobalConfigurationClassContractManagement

UseUuxLinksInEmails

SPSGlobalConfigurationClassLicenseManagement

UseUuxLinksInEmails

SPSGlobalConfigurationClassServiceDesk

ConsiderServiceTimeProfilesInTimeTracking

SPSGlobalConfigurationClassServiceDesk

UseStrictHtmlSanitizerRules

Updated Tables

Table Attribute Details

LCMLicenseModelClassBase

Metric

Default value has changed from NULL to 0

PDRContentWidgetTemplateView

Expression-ObjectID

Default value has changed from YES to NO

PLSLMessageCommandClassBase

Expression-ObjectID

Default value has changed from YES to NO

PLSLWebServiceOperation

Expression-ObjectID

Default value has changed from YES to NO

PLSTSApiTokenBase

Expression-ObjectID

Default value has changed from YES to NO

SPSConnectorClassEmpirumLocation

HttpPort

Default value for http port has changed from 9200 to 9100

Version 9.0

Database schema changes of version 9.0 can be found here.

  • Was this article helpful?