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