Skip to main content
Matrix42 Self-Service Help Center

Database Schema Changes

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

Version 9.1

Deleted Tables

Version Table
9.1.0.2524

ReplaceComplianceRulesIDs

9.1.0.2502

LCMSoftwareProductClassBase_Temp

9.1.0.2502

SPSAssetTypeLicenseBaseAssoc

9.1.0.2502

SPSAssetTypeLicenseOEM

9.1.0.2502

SPSAssetTypeLicenseUpdate

9.1.0.2502

TmpDisabledCustomTriggers

Deleted Attributes

Version Table Attribute
9.1.0.2502

SPSAssetClassBase

UsedInTypeSPSAssetTypeLicenseOEM

9.1.0.2502

SPSAssetClassBase

UsedInTypeSPSAssetTypeLicenseUpdate

9.1.0.2502

SPSAssetClassLicense

UsedInTypeSPSAssetTypeLicenseOEM

9.1.0.2502

SPSAssetClassLicense

UsedInTypeSPSAssetTypeLicenseUpdate

9.1.0.2502

SPSAssetClassLicenseBaseAssoc

Expression-ObjectID

9.1.0.2502

SPSAssetClassLicenseBaseAssoc

UsedInTypeSPSAssetTypeLicenseBaseAssoc

9.1.0.2502

SPSAssetClassLicenseExclusiveUsage

UsedInTypeSPSAssetTypeLicenseOEM

9.1.0.2502

SPSAssetClassLicenseExclusiveUsage

UsedInTypeSPSAssetTypeLicenseUpdate

9.1.0.2502

SPSAssetClassLicenseMaintenance

UsedInTypeSPSAssetTypeLicenseOEM

9.1.0.2502

SPSAssetClassLicenseMaintenance

UsedInTypeSPSAssetTypeLicenseUpdate

9.1.0.2502

SPSAssetClassOrder

UsedInTypeSPSAssetTypeLicenseOEM

9.1.0.2502

SPSAssetClassOrder

UsedInTypeSPSAssetTypeLicenseUpdate

9.1.0.2502

SPSSerialNumberClassBase

UsedInTypeSPSAssetTypeLicenseOEM

9.1.0.2502

SPSSerialNumberClassBase

UsedInTypeSPSAssetTypeLicenseUpdate

New Tables

Version Table
9.1.0.2524

TmpDisabledCustomTriggers

9.1.0.2502

ReplaceComplianceRulesIDs

9.1.0.2502

SchemaRelation-SPSActivityClassBase2SPSUserClassBase_NotifyUsers

9.1.0.2502

SPSActivityClassBase-NotifyUsers

New Attributes

Version Table Attribute
9.1.0.2524

SPSGlobalConfigurationClassServiceDesk

AutoApplyingTightestSLA
9.1.0.2502

PDRContentWidgetClassDialog

HideHeaderTitle

9.1.0.2502

PDRContentWidgetClassDialog

NotUseInCreateEditPurposes

9.1.0.2502

PDRContentWidgetClassList

CalendarShowHolidays

9.1.0.2502

PLSLServiceClassBase

DocumentationLink

9.1.0.2502

PLSLWebServiceOperation

DocumentationLink

9.1.0.2502

PLSLWebServiceOperation

IsPublic

9.1.0.2502

SPSArticleGroupClassArticle

AllowChangeQuantity

9.1.0.2502

SPSArticlePickupSet

UseDropdownToSelectOptions

9.1.0.2502

SPSGlobalConfigurationClassContractManagement

UseUuxLinksInEmails

9.1.0.2502

SPSGlobalConfigurationClassLicenseManagement

UseUuxLinksInEmails

9.1.0.2502

SPSGlobalConfigurationClassServiceDesk

ConsiderServiceTimeProfilesInTimeTracking

9.1.0.2502

SPSGlobalConfigurationClassServiceDesk

UseStrictHtmlSanitizerRules

Updated Tables

Version Table Attribute Details
9.1.0.2524

SPSContractItemClassBase

PeriodUnits

Default value has changed from 1 to 0

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

LCMLicenseModelClassBase

Metric

Default value has changed from NULL to 0

9.1.0.2502

PDRContentWidgetTemplateView

Expression-ObjectID

Default value has changed from YES to NO

9.1.0.2502

PLSLMessageCommandClassBase

Expression-ObjectID

Default value has changed from YES to NO

9.1.0.2502

PLSLWebServiceOperation

Expression-ObjectID

Default value has changed from YES to NO

9.1.0.2502

PLSTSApiTokenBase

Expression-ObjectID

Default value has changed from YES to NO

9.1.0.2502

SPSConnectorClassEmpirumLocation

HttpPort

Default value for http port has changed from 9200 to 9100

Version 9.0 Update  4

Deleted Tables

Table

TmpDisabledCustomTriggers

New Tables

Table

PDRLocalizationStringTypePickup

PDRLocalizationStringTypePickup-CI

ReplaceComplianceRulesIDs

New Attributes

Table Attribute

LCMDemandEntityClassBase

AssetState

PDRApplicationClassBase

ShowFavorites

PDRApplicationClassBase

ShowNotificationMonitor

PDRApplicationClassBase

ShowRecent

PDRApplicationClassBase

SimpleNavigation

PDRAudienceClass

StrictAdminControl

PDRContentWidgetClassList

CalendarDescriptionField

PDRContentWidgetClassList

CalendarSubjectField

PDRNavigationItemClassBase

HideIfNoChildAvailable

PDRNavigationItemClassBase

HideLeftSideNavigation

SchemaVersion

CustomPickupVersionDate

SPSAssetClassBase

SourceProcess

SPSGlobalConfigurationClassBase

LocalizationExcludedClasses

SPSGlobalConfigurationClassBase

LocalizationIncludedClasses

SPSGlobalConfigurationClassLicenseManagement

RelevantForCompliancePersonStatuses

SPSGlobalConfigurationClassServiceDesk

DisableAutoTimetrackingForMultiObjects

SPSGlobalConfigurationClassServiceDesk

SendEmailRecipientsSplitting

SPSGlobalConfigurationClassServiceDesk

SetNewInfoOnNewJournalEntryAdd

SPSGlobalConfigurationClassServiceDesk

SetNewInfoOnNewJournalEntryResponsibleAdd

SPSQuickCallClassBase

Classification

SPSSystemCultureClassBase

IsBaseLanguageInGroup

Updated Tables

Table Attribute Details

SPSComputerClassBase

BIOSManufacturer

Length has changed from 200 to 900

SPSComputerClassBase

BIOSVersion

Length has changed from 100 to 900

SPSComputerClassBase

DNSServerList

Length has changed from 255 to 900

SPSComputerClassBase

IPGateway

Length has changed from 100 to 900

SPSComputerClassBase

NT4DomainName

Length has changed from 64 to 256

SPSComputerClassBase

WindowsDomainName

Length has changed from 255 to 256

Version 9.0 Update 3

Deleted Tables

Table

PLSTSApiTokens

ReplaceComplianceRulesIDs

Deleted Attributes

Table Attribute

PDRContentWidgetTemplateClassViewCustom

OriginalBase

SPSAssetClassLicense

AllowInheritanceByLocation

SPSAssetClassLicense

AllowInheritanceByOrgUnit

SPSAssetClassLicense

DelayedAllowInheritanceByLocation

SPSAssetClassLicense

DelayedAllowInheritanceByOrgUnit

SPSAssetClassLicense

DelayedUsageCostCenter

SPSAssetClassLicense

DelayedUsageLocation

SPSAssetClassLicense

DelayedUsageOrgUnit

SPSAssetClassLicense

UsageCostCenter

SPSAssetClassLicense

UsageLocation

SPSAssetClassLicense

UsageOrgUnit

TimeZoneOffsets

DaylightDateEnd

TimeZoneOffsets

DaylightDateStart

TimeZoneOffsets

DaylightDeltaMinutes

TimeZoneOffsets

SupportsDaylightSavingTime

TimeZoneOffsets

Year

New Tables

Table

PDRContentWidgetTemplateCustom

PLSTSApiTokenBase

PLSTSApiTokenPickupExpirationType

PLSTSApiTokenPickupExpirationType-CI

TmpDisabledCustomTriggers

New Attributes

Table Attribute

CTMDocumentClassBase

UsedInTypeSPSContractTypeVolumeLicenseAgreement

PDRContentWidgetClassList

defaultBoardGroupingAttribute

PDRContentWidgetClassList

IsBoardDragAndDropEnabled

PDRContentWidgetClassList

isBoardModeEnabled

PDRContentWidgetTemplateClassViewCustom

Order

PDRContentWidgetTemplateClassViewCustom

PartnerCustomization

PDRContentWidgetTemplateView

PartnerCustomization

PLSLBinaryComponentClassBase

WorkerCompatible

PLSLXamlComponentClassBase

UseWorkflowWorker

SPSAccountClassAD

UserPrincipalName

SPSAlertingConfiguration

SuiteUuxUrl

SPSGlobalConfigurationClassContractManagement

DocumentsDirectory

SPSGlobalConfigurationClassSecurity

Saml2LogoutDisabled

TimeZoneOffsets

LocalDateEnd

TimeZoneOffsets

LocalDateStart

TimeZoneOffsets

UtcDateEnd

TimeZoneOffsets

UtcDateStart

Updated Tables

Table Remarks Details

SPSComputerClassBase

DNSServerList

Length changed from 100 to 255

Version 9.0 Update 2

Deleted Tables

Table

SPSScRoleType

TmpDisabledCustomTriggers

Deleted Attributes

Table Attribute

LCMLicensePoolClassBase

RestrictedByCostCenter

LCMLicensePoolClassBase

RestrictedByLocation

LCMLicensePoolClassBase

RestrictedByOU

LCMLicensePoolClassBase

ValidFrom

LCMLicensePoolClassBase

ValidUntil

SPSScRoleClassBase

UsedInTypeSPSScRoleType

SPSSecurityClassRole

UsedInTypeSPSScRoleType

SVCApprovalTaskClassBase

CustomFormUXBase

New Tables

Table

ReplaceComplianceRulesIDs

SchemaRelation-LCMLicensePoolClassBase2SPSCostCenterClassBase

SchemaRelation-LCMLicensePoolClassBase2SPSLocationClassBase

SchemaRelation-LCMLicensePoolClassBase2SPSOrgUnitClassBase

SchemaRelation-SPSActivityClassBase2SvcServiceFormBase

SPSActivityClassBase-SimpleServiceForms

uvw_PLSC_Sute_Software_Relations

New Attributes

Table Attribute

LCMLicensePoolClassBase

FullHierarchyLocation

LCMLicensePoolClassBase

FullHierarchyOU

LCMLicensePoolClassBase

ObjectId

PDRContentWidgetClassBase

Tag

PDRContentWidgetClassBase

VisibleByCondition

PDRContentWidgetClassDialog

VisibilityCondition

PDRDataQueryClassBase

Tag

PDRLocalizationStringClass

FrontendKey

SPSAssetClassLicense

DelayedLicensePool

SPSComplianceRuleClassBase

UseEmailEngine

SPSGlobalConfigurationClassServiceCatalog

OrderRecipientFilter

SPSGlobalConfigurationClassServiceCatalog

TechnicalTargetFilterAccounts

SPSGlobalConfigurationClassServiceCatalog

TechnicalTargetFilterAllComputers

SPSGlobalConfigurationClassServiceCatalog

TechnicalTargetFilterComputers

SPSGlobalConfigurationClassServiceCatalog

TechnicalTargetFilterMobileDevices

SPSInventoryClassApplication

Manufacturer

SPSInventoryClassApplication

Name

SPSInventoryClassApplication

Version

SVCApprovalTaskClassBase

CustomFormUX

Updated Tables

Table Attribute Details

PDRActionClassBase

ImplementationType

Character Length changed from 1 to 2

SPSArticleClassBase

Description

Length changed from 1500 to 4000

SPSContractClassBase

Description

Length changed from 200 to 2000

SPSContractItemClassBase

Description

Length changed from 1000 to 2000

Version 9.0 Update 1

Deleted Tables

Table

PDRContentWidgetTemplateClassView

PDRContentWidgetTemplateClassView-CI

SPSContractTypeAdobeClpAgreement

SPSContractTypeLicense

SPSContractTypeMSEnterpriseAgreement

SPSContractTypeMSEnterpriseEnrollment

SPSContractTypeMSSelectAgreement

SPSContractTypeMSSelectEnrollment

TmpDisabledCustomTriggers

Deleted Attributes

Table Attribute

PDRContentWidgetTemplateClassViewCustom

UsedInTypePDRContentWidgetTemplateType

SPSContractClassBase

UsedInTypeSPSContractTypeAdobeClpAgreement

SPSContractClassBase

UsedInTypeSPSContractTypeLicense

SPSContractClassBase

UsedInTypeSPSContractTypeMSEnterpriseAgreement

SPSContractClassBase

UsedInTypeSPSContractTypeMSEnterpriseEnrollment

SPSContractClassBase

UsedInTypeSPSContractTypeMSSelectAgreement

SPSContractClassBase

UsedInTypeSPSContractTypeMSSelectEnrollment

SPSContractClassLicense

UsedInTypeSPSContractTypeAdobeClpAgreement

SPSContractClassLicense

UsedInTypeSPSContractTypeLicense

SPSContractClassLicense

UsedInTypeSPSContractTypeMSEnterpriseAgreement

SPSContractClassLicense

UsedInTypeSPSContractTypeMSEnterpriseEnrollment

SPSContractClassLicense

UsedInTypeSPSContractTypeMSSelectAgreement

SPSContractClassLicense

UsedInTypeSPSContractTypeMSSelectEnrollment

SPSContractClassMilestone

UsedInTypeSPSContractTypeAdobeClpAgreement

SPSContractClassMilestone

UsedInTypeSPSContractTypeMSEnterpriseAgreement

SPSContractClassMilestone

UsedInTypeSPSContractTypeMSEnterpriseEnrollment

SPSContractClassMilestone

UsedInTypeSPSContractTypeMSSelectAgreement

SPSContractClassMilestone

UsedInTypeSPSContractTypeMSSelectEnrollment

SPSContractClassObligationLicensePoints

UsedInTypeSPSContractTypeLicense

SPSContractClassObligationLicenses

UsedInTypeSPSContractTypeLicense

SPSContractClassObligationPurchase

UsedInTypeSPSContractTypeLicense

SVCApprovalTaskClassBase

CustomFormUX

New Tables

Table

LCMCloudSubscriptionClassAccount

LCMCloudSubscriptionClassBase

LCMCloudSubscriptionPickupCapabilityStatus

LCMCloudSubscriptionPickupCapabilityStatus-CI

PDRContentWidgetClassEmail

PDRContentWidgetClassEmailProperty

PDRContentWidgetClassEmailProperty-CI

PDRContentWidgetClassEmailTypePickup

PDRContentWidgetClassEmailTypePickup-CI

PDRContentWidgetTemplateView

PDRContentWidgetTemplateView-CI

PDRContentWidgetTypeEmail

PDRControlDescriptorClassBase-CI

QueueTask

ReplaceComplianceRulesIDs

SPSUserStorage

New Attributes

Table Attribute

LCMLicenseDemandClassSource

SourceCloudSubscriber

LCMLicenseDemandPickupSource

MainClassName

PDRActionClassBase

OpenDialogOnSuccess

PDRAudienceClass

UsedInTypePDRContentWidgetTemplateViewType

PDRAudienceClass

UsedInTypeSVMEmailSignatureType

PDRContentStructureClassBase-CI

Name

PDRContentWidgetClassBase

UsedInTypePDRContentWidgetTypeEmail

PDRContentWidgetTemplateClassViewCustom

OriginalBase

PDRContentWidgetTemplateClassViewCustom

UsedInTypePDRContentWidgetTemplateViewType

SPSAssetPickupLicenseType

IsCloudSubscription

SPSQuickCallClassBase

Asset

SPSQuickCallClassBase

Service

SVCApprovalTaskClassBase

CustomFormUXBase

SVMEmailSignatureClassBase

IsEnabled

Updated Tables

Table Attribute Details

SPSComputerClassNetworkCard

Model

Length has been changed From 255 to 1000

SPSComputerClassNetworkCard

WindowsDescription

Length has been changed From 255 to 1000

Version 9.0

Deleted Tables

Table

PLSLOperationSecurity

PLSLServiceClassOperation

ReplaceComplianceRulesIDs

New Tables

Table

PDRQuickFilterTypePickup

PDRQuickFilterTypePickup-CI

PLSLWebServiceOperation

SchemaRelation-PDRAudienceClass2PDRAudienceClass

SPSTicketPickupType

SPSTicketPickupType-CI

TmpDisabledCustomTriggers

New Attributes

Table Attribute

LCMLicenseDemandClassLicenseAssignment

LicensePriority

LCMLicenseDemandClassLicenseAssignment

Priority

PDRActionClassBase

Workflow

PDRApplicationClassBase

HelpSourceType

PDRApplicationClassBase

HelpValue

PDRAudienceClass

ConsiderRelated

PDRAudienceClass

UsedInTypePLSLServiceTypeWebAPI

PDRAudienceClass

UsedInTypePLSLWebServiceOperationType

PDRContentWidgetClassBase

UsedInTypePDRControlDescriptorType

PDRContentWidgetClassDialog

ShowAsWizard

PDRContentWidgetTemplateClassViewCustom

Position

PDRControlDescriptorClassBase

CustomTemplate

PDRDataQueryClassFilter

QuickFilter

PDRDataQueryFilterClassBase

UseAsQuickFilter

PLBEEngineClassBase

ActivationParametersType

PLBEEngineClassBase

ActivationParametersWidget

PLSLComponentPickupType

Icon

PLSLServiceClassBase

Documentation

PLSLXamlComponentClassStep

Icon

SPSComplianceRulePickupOperators

SupportedTriggers

SPSComplianceRulePickupOperators

SupportedTypes

SPSGlobalConfigurationClassServiceDesk

UsePrefillAsset

SPSLisUpdateConnectorConfigurationClassBase

OperationId

Updated Tables

Table Attribute Details

SPSActivityClassBase

NotificationMode

NotificationMode changed FROM 2 TO 1

  • Was this article helpful?