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

New Attributes

Table Attribute

SPSComputerClassProcessor

AmountProcessorCores

SPSComputerClassProcessor

LogicalCPUCores

Release Candidate 9.1.3.2816

Updated Tables

Table Attribute Details
SPSUserSkillGroupsClassBase DisplayString Updated length FROM 50 TO 255
SPSUserSkillGroupsClassBase-CI DisplayString Updated length FROM 50 TO 255

Release Candidate 9.1.3.2807

New Tables

Table
LCMLicenseDemandPickupProcessingStatus
LCMLicenseDemandPickupProcessingStatus-CI
LISSoftwareProductClassExecutable
PLSLCloudWorkerRingPickupType
PLSLCloudWorkerRingPickupType-CI
PLSLWorkflowMonitoringLevelPickupType
PLSLWorkflowMonitoringLevelPickupType-CI
SchemaRelation-PDRAsyncOperationClass2SPSSecurityClassRole
SPSGenericConnectorConfigurationClassAzureAD
SPSGenericConnectorConfigurationTypeAAD
SPSGenericConnectorTypeAAD
SPSGlobalConfigurationClassWorkflowEngine

New Attributes

Table Attribute
LCMLicenseDemandPickupProcessingStatus DisplayString
LCMLicenseDemandPickupProcessingStatus Hidden
LCMLicenseDemandPickupProcessingStatus ID
LCMLicenseDemandPickupProcessingStatus Position
LCMLicenseDemandPickupProcessingStatus TimeStamp
LCMLicenseDemandPickupProcessingStatus Value
LCMLicenseDemandPickupProcessingStatus-CI DisplayString
LCMLicenseDemandPickupProcessingStatus-CI ID
LCMLicenseDemandPickupProcessingStatus-CI LCID
LCMLicenseDemandPickupProcessingStatus-CI Owner
LCMLicenseDemandPickupProcessingStatus-CI TimeStamp
LISSoftwareProductClassExecutable AddDate
LISSoftwareProductClassExecutable ChangeDate
LISSoftwareProductClassExecutable Expression-ObjectID
LISSoftwareProductClassExecutable FileName
LISSoftwareProductClassExecutable FileVersion
LISSoftwareProductClassExecutable ID
LISSoftwareProductClassExecutable TimeStamp
LISSoftwareProductClassExecutable UsedInTypeLISSoftwareProductType
PLSLCloudWorkerRingPickupType DisplayString
PLSLCloudWorkerRingPickupType Hidden
PLSLCloudWorkerRingPickupType ID
PLSLCloudWorkerRingPickupType Position
PLSLCloudWorkerRingPickupType TimeStamp
PLSLCloudWorkerRingPickupType Value
PLSLCloudWorkerRingPickupType-CI DisplayString
PLSLCloudWorkerRingPickupType-CI ID
PLSLCloudWorkerRingPickupType-CI LCID
PLSLCloudWorkerRingPickupType-CI Owner
PLSLCloudWorkerRingPickupType-CI TimeStamp
PLSLWorkflowMonitoringLevelPickupType DisplayString
PLSLWorkflowMonitoringLevelPickupType Hidden
PLSLWorkflowMonitoringLevelPickupType ID
PLSLWorkflowMonitoringLevelPickupType Position
PLSLWorkflowMonitoringLevelPickupType TimeStamp
PLSLWorkflowMonitoringLevelPickupType Value
PLSLWorkflowMonitoringLevelPickupType-CI DisplayString
PLSLWorkflowMonitoringLevelPickupType-CI ID
PLSLWorkflowMonitoringLevelPickupType-CI LCID
PLSLWorkflowMonitoringLevelPickupType-CI Owner
PLSLWorkflowMonitoringLevelPickupType-CI TimeStamp
SchemaRelation-PDRAsyncOperationClass2SPSSecurityClassRole AsyncOperation
SchemaRelation-PDRAsyncOperationClass2SPSSecurityClassRole ID
SchemaRelation-PDRAsyncOperationClass2SPSSecurityClassRole TimeStamp
SchemaRelation-PDRAsyncOperationClass2SPSSecurityClassRole UserRole
SPSGenericConnectorConfigurationClassAzureAD ClientID
SPSGenericConnectorConfigurationClassAzureAD ClientSecret
SPSGenericConnectorConfigurationClassAzureAD Expression-ObjectID
SPSGenericConnectorConfigurationClassAzureAD GroupFilter
SPSGenericConnectorConfigurationClassAzureAD ID
SPSGenericConnectorConfigurationClassAzureAD ImportGroups
SPSGenericConnectorConfigurationClassAzureAD ImportUsers
SPSGenericConnectorConfigurationClassAzureAD Tenant
SPSGenericConnectorConfigurationClassAzureAD TimeStamp
SPSGenericConnectorConfigurationClassAzureAD UsedInTypeSPSGenericConnectorConfigurationTypeAAD
SPSGenericConnectorConfigurationClassAzureAD UserFilter
SPSGenericConnectorConfigurationTypeAAD ID
SPSGenericConnectorConfigurationTypeAAD TimeStamp
SPSGenericConnectorTypeAAD ID
SPSGenericConnectorTypeAAD TimeStamp
SPSGlobalConfigurationClassWorkflowEngine ActivityLoopLimit
SPSGlobalConfigurationClassWorkflowEngine AppServerToken
SPSGlobalConfigurationClassWorkflowEngine AppServerTokenUserId
SPSGlobalConfigurationClassWorkflowEngine AppServerUrl
SPSGlobalConfigurationClassWorkflowEngine CloudWorkerAccessUrl
SPSGlobalConfigurationClassWorkflowEngine CloudWorkerClientKey
SPSGlobalConfigurationClassWorkflowEngine CloudWorkerClientSecret
SPSGlobalConfigurationClassWorkflowEngine CloudWorkerConnectorId
SPSGlobalConfigurationClassWorkflowEngine CloudWorkerEnabled
SPSGlobalConfigurationClassWorkflowEngine CloudWorkerEnterpriseId
SPSGlobalConfigurationClassWorkflowEngine CloudWorkerExecutionRing
SPSGlobalConfigurationClassWorkflowEngine Expression-ObjectID
SPSGlobalConfigurationClassWorkflowEngine ID
SPSGlobalConfigurationClassWorkflowEngine MonitoringLevel
SPSGlobalConfigurationClassWorkflowEngine MonitoringMaxTableSize
SPSGlobalConfigurationClassWorkflowEngine TimeStamp
SPSGlobalConfigurationClassWorkflowEngine UsedInTypeSPSGlobalConfigurationType
LCMLicenseDemandClassState ProcessingStatus
LISSoftwareProductClassBase Discontinued
LISSoftwareProductClassBase ECCN
LISSoftwareProductClassBase ECLASS_ID
LISSoftwareProductClassBase ECLASS_Text
LISSoftwareProductClassBase EndOfLife
LISSoftwareProductClassBase EndOfSupport
LISSoftwareProductClassBase LicenseLibrary
LISSoftwareProductClassBase ReleaseDate
LISSoftwareProductClassBase UNSPSC_ID
LISSoftwareProductClassBase UNSPSC_Text
PLSLXamlComponentClassBase AllowCloudWorker
PLSLXamlComponentClassBase MonitoringLevel
QueueTask Params
SPSActivityClassTimeTracking ManuallyChanged
SPSGenericConnectorClassBase UsedInTypeSPSGenericConnectorTypeAAD
SPSGenericConnectorClassLDAP UsedInTypeSPSGenericConnectorTypeAAD
SPSGenericConnectorClassResult UsedInTypeSPSGenericConnectorConfigurationTypeAAD
SPSGenericConnectorClassWorkflow UsedInTypeSPSGenericConnectorTypeAAD
SPSGenericConnectorConfigurationClassAirWatch EnableDeviceUserAutoAssignment
SPSGenericConnectorConfigurationClassBase UsedInTypeSPSGenericConnectorConfigurationTypeAAD
SPSGenericConnectorConfigurationClassLDAP UsedInTypeSPSGenericConnectorConfigurationTypeAAD
SVCServiceProvisioningClassBaseCreateWFChange ADGroup
WFPInstancesTable Resuming
WFPInstancesTable State
WFPPromotionsTable BinariesHash
WFPPromotionsTable MonitoringLevel

Updated Tables

Table Attribute Details
PDRAsyncOperationClass InitiatedBy Default value has changed from NO to YES
SPSComputerClassBase ClusterName Default value has changed from 100 to 4000

Deleted Attributes

Table  Attribute 
SPSComputerClassBase ClusterNames

Technical Preview 9.1.3.2754

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

New Tables

Table

ReplaceComplianceRulesIDs

New Attributes

Table  Attribute 
ReplaceComplianceRulesIDs

NewTypeId

ReplaceComplianceRulesIDs

OldTypeId

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?