Database Schema Changes 9.0.x
Table of Contents
List of database schema changes for Software Asset & Service Management 9.0 including all updates.
Version 9.0 Update 4
Deleted Tables
| Table |
|---|
| TmpDisabledCustomTriggers |
New Tables
| Table |
|---|
| PDRLocalizationStringTypePickup |
| PDRLocalizationStringTypePickup-CI |
| ReplaceComplianceRulesIDs |
New Attributes
| Table | Attribute |
|---|---|
| LCMDemandEntityClassBase | AssetState |
| PDRApplicationClassBase | ShowFavorites |
| PDRApplicationClassBase | ShowNotificationMonitor |
| PDRApplicationClassBase | ShowRecent |
| PDRApplicationClassBase | SimpleNavigation |
| PDRAudienceClass | StrictAdminControl |
| PDRContentWidgetClassList | CalendarDescriptionField |
| PDRContentWidgetClassList | CalendarSubjectField |
| PDRNavigationItemClassBase | HideIfNoChildAvailable |
| PDRNavigationItemClassBase | HideLeftSideNavigation |
| SchemaVersion | CustomPickupVersionDate |
| SPSAssetClassBase | SourceProcess |
| SPSGlobalConfigurationClassBase | LocalizationExcludedClasses |
| SPSGlobalConfigurationClassBase | LocalizationIncludedClasses |
| SPSGlobalConfigurationClassLicenseManagement | RelevantForCompliancePersonStatuses |
| SPSGlobalConfigurationClassServiceDesk | DisableAutoTimetrackingForMultiObjects |
| SPSGlobalConfigurationClassServiceDesk | SendEmailRecipientsSplitting |
| SPSGlobalConfigurationClassServiceDesk | SetNewInfoOnNewJournalEntryAdd |
| SPSGlobalConfigurationClassServiceDesk | SetNewInfoOnNewJournalEntryResponsibleAdd |
| SPSQuickCallClassBase | Classification |
| SPSSystemCultureClassBase | IsBaseLanguageInGroup |
Updated Tables
| Table | Attribute | Details |
|---|---|---|
| SPSComputerClassBase | BIOSManufacturer | Length has changed from 200 to 900 |
| SPSComputerClassBase | BIOSVersion | Length has changed from 100 to 900 |
| SPSComputerClassBase | DNSServerList | Length has changed from 255 to 900 |
| SPSComputerClassBase | IPGateway | Length has changed from 100 to 900 |
| SPSComputerClassBase | NT4DomainName | Length has changed from 64 to 256 |
| SPSComputerClassBase | WindowsDomainName | Length has changed from 255 to 256 |
Version 9.0 Update 3
Deleted Tables
| Table |
|---|
| PLSTSApiTokens |
| ReplaceComplianceRulesIDs |
Deleted Attributes
| Table | Attribute |
|---|---|
| PDRContentWidgetTemplateClassViewCustom | OriginalBase |
| SPSAssetClassLicense | AllowInheritanceByLocation |
| SPSAssetClassLicense | AllowInheritanceByOrgUnit |
| SPSAssetClassLicense | DelayedAllowInheritanceByLocation |
| SPSAssetClassLicense | DelayedAllowInheritanceByOrgUnit |
| SPSAssetClassLicense | DelayedUsageCostCenter |
| SPSAssetClassLicense | DelayedUsageLocation |
| SPSAssetClassLicense | DelayedUsageOrgUnit |
| SPSAssetClassLicense | UsageCostCenter |
| SPSAssetClassLicense | UsageLocation |
| SPSAssetClassLicense | UsageOrgUnit |
| TimeZoneOffsets | DaylightDateEnd |
| TimeZoneOffsets | DaylightDateStart |
| TimeZoneOffsets | DaylightDeltaMinutes |
| TimeZoneOffsets | SupportsDaylightSavingTime |
| TimeZoneOffsets | Year |
New Tables
| Table |
|---|
| PDRContentWidgetTemplateCustom |
| PLSTSApiTokenBase |
| PLSTSApiTokenPickupExpirationType |
| PLSTSApiTokenPickupExpirationType-CI |
| TmpDisabledCustomTriggers |
New Attributes
| Table | Attribute |
|---|---|
| CTMDocumentClassBase | UsedInTypeSPSContractTypeVolumeLicenseAgreement |
| PDRContentWidgetClassList | defaultBoardGroupingAttribute |
| PDRContentWidgetClassList | IsBoardDragAndDropEnabled |
| PDRContentWidgetClassList | isBoardModeEnabled |
| PDRContentWidgetTemplateClassViewCustom | Order |
| PDRContentWidgetTemplateClassViewCustom | PartnerCustomization |
| PDRContentWidgetTemplateView | PartnerCustomization |
| PLSLBinaryComponentClassBase | WorkerCompatible |
| PLSLXamlComponentClassBase | UseWorkflowWorker |
| SPSAccountClassAD | UserPrincipalName |
| SPSAlertingConfiguration | SuiteUuxUrl |
| SPSGlobalConfigurationClassContractManagement | DocumentsDirectory |
| SPSGlobalConfigurationClassSecurity | Saml2LogoutDisabled |
| TimeZoneOffsets | LocalDateEnd |
| TimeZoneOffsets | LocalDateStart |
| TimeZoneOffsets | UtcDateEnd |
| TimeZoneOffsets | UtcDateStart |
Updated Tables
| Table | Remarks | Details |
|---|---|---|
| SPSComputerClassBase | DNSServerList | Length changed from 100 to 255 |
Version 9.0 Update 2
Deleted Tables
| Table |
|---|
| SPSScRoleType |
| TmpDisabledCustomTriggers |
Deleted Attributes
| Table | Attribute |
|---|---|
| LCMLicensePoolClassBase | RestrictedByCostCenter |
| LCMLicensePoolClassBase | RestrictedByLocation |
| LCMLicensePoolClassBase | RestrictedByOU |
| LCMLicensePoolClassBase | ValidFrom |
| LCMLicensePoolClassBase | ValidUntil |
| SPSScRoleClassBase | UsedInTypeSPSScRoleType |
| SPSSecurityClassRole | UsedInTypeSPSScRoleType |
| SVCApprovalTaskClassBase | CustomFormUXBase |
New Tables
| Table |
|---|
| ReplaceComplianceRulesIDs |
| SchemaRelation-LCMLicensePoolClassBase2SPSCostCenterClassBase |
| SchemaRelation-LCMLicensePoolClassBase2SPSLocationClassBase |
| SchemaRelation-LCMLicensePoolClassBase2SPSOrgUnitClassBase |
| SchemaRelation-SPSActivityClassBase2SvcServiceFormBase |
| SPSActivityClassBase-SimpleServiceForms |
| uvw_PLSC_Sute_Software_Relations |
New Attributes
| Table | Attribute |
|---|---|
| LCMLicensePoolClassBase | FullHierarchyLocation |
| LCMLicensePoolClassBase | FullHierarchyOU |
| LCMLicensePoolClassBase | ObjectId |
| PDRContentWidgetClassBase | Tag |
| PDRContentWidgetClassBase | VisibleByCondition |
| PDRContentWidgetClassDialog | VisibilityCondition |
| PDRDataQueryClassBase | Tag |
| PDRLocalizationStringClass | FrontendKey |
| SPSAssetClassLicense | DelayedLicensePool |
| SPSComplianceRuleClassBase | UseEmailEngine |
| SPSGlobalConfigurationClassServiceCatalog | OrderRecipientFilter |
| SPSGlobalConfigurationClassServiceCatalog | TechnicalTargetFilterAccounts |
| SPSGlobalConfigurationClassServiceCatalog | TechnicalTargetFilterAllComputers |
| SPSGlobalConfigurationClassServiceCatalog | TechnicalTargetFilterComputers |
| SPSGlobalConfigurationClassServiceCatalog | TechnicalTargetFilterMobileDevices |
| SPSInventoryClassApplication | Manufacturer |
| SPSInventoryClassApplication | Name |
| SPSInventoryClassApplication | Version |
| SVCApprovalTaskClassBase | CustomFormUX |
Updated Tables
| Table | Attribute | Details |
|---|---|---|
| PDRActionClassBase | ImplementationType | Character Length changed from 1 to 2 |
| SPSArticleClassBase | Description | Length changed from 1500 to 4000 |
| SPSContractClassBase | Description | Length changed from 200 to 2000 |
| SPSContractItemClassBase | Description | Length changed from 1000 to 2000 |
Version 9.0 Update 1
Deleted Tables
| Table |
|---|
| PDRContentWidgetTemplateClassView |
| PDRContentWidgetTemplateClassView-CI |
| SPSContractTypeAdobeClpAgreement |
| SPSContractTypeLicense |
| SPSContractTypeMSEnterpriseAgreement |
| SPSContractTypeMSEnterpriseEnrollment |
| SPSContractTypeMSSelectAgreement |
| SPSContractTypeMSSelectEnrollment |
| TmpDisabledCustomTriggers |
Deleted Attributes
| Table | Attribute |
|---|---|
| PDRContentWidgetTemplateClassViewCustom | UsedInTypePDRContentWidgetTemplateType |
| SPSContractClassBase | UsedInTypeSPSContractTypeAdobeClpAgreement |
| SPSContractClassBase | UsedInTypeSPSContractTypeLicense |
| SPSContractClassBase | UsedInTypeSPSContractTypeMSEnterpriseAgreement |
| SPSContractClassBase | UsedInTypeSPSContractTypeMSEnterpriseEnrollment |
| SPSContractClassBase | UsedInTypeSPSContractTypeMSSelectAgreement |
| SPSContractClassBase | UsedInTypeSPSContractTypeMSSelectEnrollment |
| SPSContractClassLicense | UsedInTypeSPSContractTypeAdobeClpAgreement |
| SPSContractClassLicense | UsedInTypeSPSContractTypeLicense |
| SPSContractClassLicense | UsedInTypeSPSContractTypeMSEnterpriseAgreement |
| SPSContractClassLicense | UsedInTypeSPSContractTypeMSEnterpriseEnrollment |
| SPSContractClassLicense | UsedInTypeSPSContractTypeMSSelectAgreement |
| SPSContractClassLicense | UsedInTypeSPSContractTypeMSSelectEnrollment |
| SPSContractClassMilestone | UsedInTypeSPSContractTypeAdobeClpAgreement |
| SPSContractClassMilestone | UsedInTypeSPSContractTypeMSEnterpriseAgreement |
| SPSContractClassMilestone | UsedInTypeSPSContractTypeMSEnterpriseEnrollment |
| SPSContractClassMilestone | UsedInTypeSPSContractTypeMSSelectAgreement |
| SPSContractClassMilestone | UsedInTypeSPSContractTypeMSSelectEnrollment |
| SPSContractClassObligationLicensePoints | UsedInTypeSPSContractTypeLicense |
| SPSContractClassObligationLicenses | UsedInTypeSPSContractTypeLicense |
| SPSContractClassObligationPurchase | UsedInTypeSPSContractTypeLicense |
| SVCApprovalTaskClassBase | CustomFormUX |
New Tables
| Table |
|---|
| LCMCloudSubscriptionClassAccount |
| LCMCloudSubscriptionClassBase |
| LCMCloudSubscriptionPickupCapabilityStatus |
| LCMCloudSubscriptionPickupCapabilityStatus-CI |
| PDRContentWidgetClassEmail |
| PDRContentWidgetClassEmailProperty |
| PDRContentWidgetClassEmailProperty-CI |
| PDRContentWidgetClassEmailTypePickup |
| PDRContentWidgetClassEmailTypePickup-CI |
| PDRContentWidgetTemplateView |
| PDRContentWidgetTemplateView-CI |
| PDRContentWidgetTypeEmail |
| PDRControlDescriptorClassBase-CI |
| QueueTask |
| ReplaceComplianceRulesIDs |
| SPSUserStorage |
New Attributes
| Table | Attribute |
|---|---|
| LCMLicenseDemandClassSource | SourceCloudSubscriber |
| LCMLicenseDemandPickupSource | MainClassName |
| PDRActionClassBase | OpenDialogOnSuccess |
| PDRAudienceClass | UsedInTypePDRContentWidgetTemplateViewType |
| PDRAudienceClass | UsedInTypeSVMEmailSignatureType |
| PDRContentStructureClassBase-CI | Name |
| PDRContentWidgetClassBase | UsedInTypePDRContentWidgetTypeEmail |
| PDRContentWidgetTemplateClassViewCustom | OriginalBase |
| PDRContentWidgetTemplateClassViewCustom | UsedInTypePDRContentWidgetTemplateViewType |
| SPSAssetPickupLicenseType | IsCloudSubscription |
| SPSQuickCallClassBase | Asset |
| SPSQuickCallClassBase | Service |
| SVCApprovalTaskClassBase | CustomFormUXBase |
| SVMEmailSignatureClassBase | IsEnabled |
Updated Tables
| Table | Attribute | Details |
|---|---|---|
| SPSComputerClassNetworkCard | Model | Length has been changed From 255 to 1000 |
| SPSComputerClassNetworkCard | WindowsDescription | Length has been changed From 255 to 1000 |
Version 9.0
Deleted Tables
| Table |
|---|
| PLSLOperationSecurity |
| PLSLServiceClassOperation |
| ReplaceComplianceRulesIDs |
New Tables
| Table |
|---|
| PDRQuickFilterTypePickup |
| PDRQuickFilterTypePickup-CI |
| PLSLWebServiceOperation |
| SchemaRelation-PDRAudienceClass2PDRAudienceClass |
| SPSTicketPickupType |
| SPSTicketPickupType-CI |
| TmpDisabledCustomTriggers |
New Attributes
| able | Attribute |
|---|---|
| LCMLicenseDemandClassLicenseAssignment | LicensePriority |
| LCMLicenseDemandClassLicenseAssignment | Priority |
| PDRActionClassBase | Workflow |
| PDRApplicationClassBase | HelpSourceType |
| PDRApplicationClassBase | HelpValue |
| PDRAudienceClass | ConsiderRelated |
| PDRAudienceClass | UsedInTypePLSLServiceTypeWebAPI |
| PDRAudienceClass | UsedInTypePLSLWebServiceOperationType |
| PDRContentWidgetClassBase | UsedInTypePDRControlDescriptorType |
| PDRContentWidgetClassDialog | ShowAsWizard |
| PDRContentWidgetTemplateClassViewCustom | Position |
| PDRControlDescriptorClassBase | CustomTemplate |
| PDRDataQueryClassFilter | QuickFilter |
| PDRDataQueryFilterClassBase | UseAsQuickFilter |
| PLBEEngineClassBase | ActivationParametersType |
| PLBEEngineClassBase | ActivationParametersWidget |
| PLSLComponentPickupType | Icon |
| PLSLServiceClassBase | Documentation |
| PLSLXamlComponentClassStep | Icon |
| SPSComplianceRulePickupOperators | SupportedTriggers |
| SPSComplianceRulePickupOperators | SupportedTypes |
| SPSGlobalConfigurationClassServiceDesk | UsePrefillAsset |
| SPSLisUpdateConnectorConfigurationClassBase | OperationId |
Updated Tables
| Table | Attribute | Details |
|---|---|---|
| SPSActivityClassBase | NotificationMode | NotificationMode changed FROM 2 TO 1 |