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.