Database Schema Changes 9.1.x
Table of Contents
Version 9.1.3
Version 9.1.3.2920
Version 9.1.3.2917
Version 9.1.3.2845
Release Candidate 9.1.3.2816
Release Candidate 9.1.3.2807
Technical Preview 9.1.3.2754
Version 9.1.2
Version 9.1.2.2790
Version 9.1.2.2762
Version 9.1.2.2757
Version 9.1.2.2737
Version 9.1.2.2729
Version 9.1.2.2707 (General Availability)
Version 9.1.2.2686 (Release Candidate 1)
Version 9.1.2.2584 (Technical Preview 1)
Version 9.1.1
Version 9.1.1.2613
Version 9.1.1.2596
Version 9.1.1.2577
Version 9.1.1.2540
Version 9.1.1.2528
Version 9.1
Version 9.1.0.2524
Version 9.1.0.2502
Version 9.0
List of database schema changes for Software Asset & Service Management 9.1.x
Version 9.1.3
Version 9.1.3.2920
No database schema change have been made in this version
Version 9.1.3.2917
New Attributes
| Table | Attribute |
|---|---|
| SPSComputerClassBase | VmWareUUID |
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.