Database Schema Changes 9.0.x
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
| Table | 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 |