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

Version 9.1.1

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?