Database Schema Changes 10.0.x
List of database schema changes for Enterprise Service Management 10.0.x
Version 10.0.4
Version 10.0.4.3240
New Attributes
| Table | Attribute |
|---|---|
| PLBEActivationClassTask | DoNotRun |
Version 10.0.4.3235
New Attributes
| Table | Attribute |
|---|---|
| SPSGlobalConfigurationClassServiceDesk | KeepResponsibleRoleOnEmptyDefaultsFromChangedItem |
Version 10.0.4.3226
Deleted Tables
| Table | Remarks |
|---|---|
| ReplaceComplianceRulesIDs |
Deleted Attributes
| Table | Attribute |
|---|---|
| ReplaceComplianceRulesIDs | NewTypeId |
| ReplaceComplianceRulesIDs | OldTypeId |
Version 10.0.4.3212
New Attributes
| Table | Attribute |
|---|---|
| PLBEActivationClassTask | DoNotRun |
Version 10.0.4.3183 - Technical Release
Deleted Tables
| Table | Remarks |
|---|---|
| LCMOracleProcessorCoreFactorClassBase |
New Tables
| Table name |
|---|
| DWPPushNotificationsSettingsClass |
| DWPPushNotificationSubscriptionModePickup |
| DWPPushNotificationSubscriptionModePickup-CI |
| DWPUserPushNotificationsClass |
| PDRConfigurationPackageLicensingStatus |
| PDRConfigurationPackageLicensingStatus-CI |
| PDRServiceConnectionAppClass |
| PDRServiceConnectionClass |
| PDRServiceConnectionPickupGrantType |
| PDRServiceConnectionPickupGrantType-CI |
| PDRServiceConnectionPickupType |
| PDRServiceConnectionPickupType-CI |
| PDRServiceConnectionProviderClass |
| PDRServiceConnectionScopeClass |
Deleted Attributes
| Table | Attribute |
|---|---|
| WFPPromotionsTable | Culture |
New Attributes
| Table | Attribute |
|---|---|
| GDIEImportClassSourceFile | ServiceConnection |
| PDRConfigurationPackageClassBase | LicensingStatus |
| PDRConfigurationPackageClassBase | RequiredLicenses |
| SPSPushNotificationEventPickupType | Icon |
| SPSActivityClassBase | SDDMEventID |
Updated Tables
| Table | Attribute | Remarks |
|---|---|---|
| SPSPushNotificationEventPickupType | Color | Default value changed from '0xff808080' TO '#0399d7' |
Version 10.0.4.3159 - Technical Preview 1
Deleted Tables
| Table | Remarks |
|---|---|
| SPSConnectorPackageItemPickupType-CI | |
| LCMOracleProcessorCoreFactorClassBase |
New Tables
| Table name |
|---|
| SPSGlobalConfigurationClassDependencyObjectDisplay |
New Attributes
| Table | Attribute |
|---|---|
| PLBEActivationClassTask | RunAfter |
| PLBEEngineClassBase | IsEndCallbackSupported |
Version 10.0.3
Version 10.0.3.3162
New Tables
| Table name |
|---|
|
PDRConfigurationPackageLicensingStatus |
|
PDRConfigurationPackageLicensingStatus-CI |
|
SPSGlobalConfigurationClassDependencyObjectDisplay |
New Attributes
| Table | Attribute |
|---|---|
| PDRConfigurationPackageLicensingStatus |
DisplayString |
| PDRConfigurationPackageLicensingStatus |
Hidden |
| PDRConfigurationPackageLicensingStatus |
ID |
| PDRConfigurationPackageLicensingStatus |
Position |
| PDRConfigurationPackageLicensingStatus |
TimeStamp |
| PDRConfigurationPackageLicensingStatus |
Value |
|
PDRConfigurationPackageLicensingStatus-CI |
DisplayString |
|
PDRConfigurationPackageLicensingStatus-CI |
ID |
|
PDRConfigurationPackageLicensingStatus-CI |
LCID |
| PDRConfigurationPackageLicensingStatus-CI |
Owner |
| PDRConfigurationPackageLicensingStatus-CI |
TimeStamp |
|
SPSGlobalConfigurationClassDependencyObjectDisplay |
Color |
|
SPSGlobalConfigurationClassDependencyObjectDisplay |
ConfigurationItem |
|
SPSGlobalConfigurationClassDependencyObjectDisplay |
DisplayExpression |
|
SPSGlobalConfigurationClassDependencyObjectDisplay |
Enabled |
|
SPSGlobalConfigurationClassDependencyObjectDisplay |
Expression-ObjectID |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
Icon |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
ID |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
TimeStamp |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
UsedInTypeSPSGlobalConfigurationType |
|
PDRConfigurationPackageClassBase |
LicensingStatus |
| PDRConfigurationPackageClassBase |
RequiredLicenses |
|
SPSActivityClassBase |
SDDMEventID |
Version 10.0.3.3138
New Tables
| Table name |
|---|
|
SPSGlobalConfigurationClassDependencyObjectDisplay |
New Attributes
| Table | Attribute |
|---|---|
| SPSGlobalConfigurationClassDependencyObjectDisplay |
Color |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
ConfigurationItem |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
DisplayExpression |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
Enabled |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
Expression-ObjectID |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
Icon |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
ID |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
TimeStamp |
| SPSGlobalConfigurationClassDependencyObjectDisplay |
UsedInTypeSPSGlobalConfigurationType |
|
SPSActivityClassBase |
SDDMEventID |
Version 10.0.3.3108 (10.12.2020) - Release Candidate 2
New Tables
| Table name |
|---|
| SPSGlobalConfigurationClassDependencyDefinition |
| SVCServicePickupDependencyDirection |
| SVCServicePickupDependencyDirection-CI |
New Attributes
| Table | Attribute |
|---|---|
| SPSGlobalConfigurationClassDependencyDefinition | AllowedCIs |
| SPSGlobalConfigurationClassDependencyDefinition | ColumnExpression |
| SPSGlobalConfigurationClassDependencyDefinition | DataDefinition |
| SPSGlobalConfigurationClassDependencyDefinition | Direction |
| SPSGlobalConfigurationClassDependencyDefinition | Enabled |
| SPSGlobalConfigurationClassDependencyDefinition | Expression-ObjectID |
| SPSGlobalConfigurationClassDependencyDefinition | ID |
| SPSGlobalConfigurationClassDependencyDefinition | System |
| SPSGlobalConfigurationClassDependencyDefinition | TimeStamp |
| SPSGlobalConfigurationClassDependencyDefinition | Type |
| SPSGlobalConfigurationClassDependencyDefinition | UsedInTypeSPSGlobalConfigurationType |
| SPSGlobalConfigurationClassDependencyDefinition | WhereExpression |
| SVCServicePickupDependencyDirection | DisplayString |
| SVCServicePickupDependencyDirection | Hidden |
| SVCServicePickupDependencyDirection | ID |
| SVCServicePickupDependencyDirection | Position |
| SVCServicePickupDependencyDirection | TimeStamp |
| SVCServicePickupDependencyDirection | Value |
| SVCServicePickupDependencyDirection-CI | DisplayString |
| SVCServicePickupDependencyDirection-CI | ID |
| SVCServicePickupDependencyDirection-CI | LCID |
| SVCServicePickupDependencyDirection-CI | Owner |
| SVCServicePickupDependencyDirection-CI | TimeStamp |
| SPSArticleClassBase | SDDMConfigurationItemID |
| SPSGlobalConfigurationClassMailBox | ClientID |
| SPSGlobalConfigurationClassMailBox | ClientSecret |
| SPSGlobalConfigurationClassMailBox | ProcessUndeliveredReports |
| SPSGlobalConfigurationClassMailBox | TenantID |
| SPSGlobalConfigurationClassServiceDesk | AllowedTypesForObjectClassDependency |
| SPSObjectClassDependency | Direction |
| SPSObjectClassDependency | UsedInTypeSPSArticleTypeGroup |
| SPSObjectClassDependency | UsedInTypeSVCServiceTypeBundle |
| SPSObjectClassDependency | UsedInTypeSVCServiceTypeConfigGroup |
| SVCServicePickupDependencyType | Opposite |
| WFPPromotionsTable | Culture |
Changed Attributes
| Table | Attribute | Change |
|---|---|---|
| SPSGlobalConfigurationClassMailBox | Password | Allow Nulls Changed from False to True |
| SPSGlobalConfigurationClassMailBox | ServerName | Allow Nulls Changed from False to True |
Version 10.0.3.3089 (13.10.2020) - Release Candidate 1
New Tables
| Table name |
|---|
| PDRConfigurationProjectClassPackage |
| SchemaRelation-PDRConfigurationPackageClassBase2PDRConfigurationPackageClassBase |
Changed Attributes
| Table | Attribute | Change |
|---|---|---|
| SPSGenericConnectorConfigurationClassSilverback | ApiKey | Length changed from 2000 to 4000 |
New Attributes
| Table | Attribute |
|---|---|
| PDRConfigurationProjectClassBase |
MinimalRequiredProductVersion |
| SPSAssetClassBase | SDDMConfigurationItemID |
| SPSComputerClassBase | VmWareUUID |
| SPSGlobalConfigurationClassSecurity | AllowExtensionGalleryToInstallPackages |
| SPSSecurityGroupClassMember | Sid-Calc |
| WFPPromotionsTable | Culture |
Version 10.0.3.3048 (13.10.2020) - Technical Preview 1
New Attributes
| Table | Attribute |
|---|---|
|
SPSGenericConnectorConfigurationClassAzureAD |
ExtensionApplicationID |
|
SPSGenericConnectorConfigurationClassAzureAD |
ExtensionApplicationIDIsAppClientID |
Version 10.0.2
Version 10.0.2.3127 (12.05.2022)
No database schema changes have been made in this version
Version 10.0.2.3110 (10.06.2021)
Deleted Tables
| Table | Attribute |
|---|---|
| ReplaceComplianceRulesIDs | NewTypeId |
| ReplaceComplianceRulesIDs | OldTypeId |
Version 10.0.2.3107 (13.04.2021)
New Tables
| Table name |
|---|
| PDRConfigurationPackageLicensingStatus |
New Attributes
| Table | Attribute |
|---|---|
| PDRConfigurationPackageLicensingStatus | DisplayString |
| PDRConfigurationPackageLicensingStatus | Hidden |
| PDRConfigurationPackageLicensingStatus | ID |
| PDRConfigurationPackageLicensingStatus | Position |
| PDRConfigurationPackageLicensingStatus | TimeStamp |
| PDRConfigurationPackageLicensingStatus | Value |
| PDRConfigurationPackageLicensingStatus-CI | DisplayString |
| PDRConfigurationPackageLicensingStatus-CI | ID |
| PDRConfigurationPackageLicensingStatus-CI | LCID |
| PDRConfigurationPackageLicensingStatus-CI | Owner |
| PDRConfigurationPackageLicensingStatus-CI | TimeStamp |
| PDRConfigurationPackageClassBase | LicensingStatus |
| PDRConfigurationPackageClassBase | RequiredLicenses |
Version 10.0.2.3099 (15.02.2021)
New Attributes
| Table | Attribute |
|---|---|
|
SPSComputerClassBase |
VmWareUUID |
Version 10.0.2.3081 (26.11.2020)
Deleted Tables
| Table | Attribute |
|---|---|
| LCMSoftwareProductClassBase_Temp | AllowExtensionGalleryToInstallPackages |
Version 10.0.2.3077 (16.11.2020)
New Attributes
| Table | Attribute |
|---|---|
| SPSGlobalConfigurationClassSecurity | AllowExtensionGalleryToInstallPackages |
Version 10.0.2.3047 (01.10.2020)
Updated Attributes
| Table | Attribute | Details |
|---|---|---|
| SPSCurrencyExchangeRateClassItem | Ask | Precision changed FROM 11 TO 22 |
| SPSCurrencyExchangeRateClassItem | Bid | Precision changed FROM 11 TO 22 |
Version 10.0.2.3011 Release Candidate 1 (21.08.2020)
Deleted Tables
| Table name |
|---|
| TmpDisabledCustomTriggers |
Deleted Attributes
| Table | Attribute |
|---|---|
| PLSLWorkerClassBase | DataProvidersAppState |
| PLSLWorkerClassBase | WorkflowsAppState |
New Tables
| Table name |
|---|
| PDRConfigurationProjectClassAssembly |
| PDRConfigurationProjectClassFile |
| PDRConfigurationProjectPickupFilesFolders |
| ReplaceComplianceRulesIDs |
New Attributes
| Table | Attribute |
|---|---|
| ITSMEQMClassBase | Category |
| LCMLicenseDemandClassBase | LCMLicenseDemandClassBase |
| LCMLicenseDemandRuleClassBase | Enabled |
| LCMLicenseModelClassBase | ObsoleteCRRaised |
| PDRConfigurationProjectClassBase | InstallationPSScript |
| PDRConfigurationProjectClassBase | InstallationSQLScript |
| PDRConfigurationProjectClassBase | MaintenanceMode |
| PDRConfigurationProjectClassBase | RecycleWebApplication |
| PDRConfigurationProjectClassBase | RestartM42WindowsServices |
| PDRConfigurationProjectClassBase | PDRConfigurationProjectClassBase |
| PDRConfigurationProjectClassBase | UninstallationSQLScript |
| PDRConfigurationProjectClassBase | UUXWorkspaces |
| PDRConfigurationProjectClassChange | AlwaysFullImport |
| PDRConfigurationProjectClassChange | FullExport |
| PLSLWorkerClassBase | ApplicationsState |
| QueueTask | Worker |
| SPSADDomainClassBase | LdapPort |
| SPSADDomainClassBase | UseSsl |
| SPSAlertingConfiguration | DefaultHeaderFooter |
| SPSGlobalConfigurationClassMailBox | EQMProfile |
| SPSGlobalConfigurationClassSecurity | Saml2LogoutSign |
| WFPPromotionsTable | Culture |
Updated Attributes
| Table | Attribute | Details |
|---|---|---|
| SchemaScripts | Name | Length was changed FROM 200 TO 400 |
| SPSComputerClassBase | DataStoresNames | Length was changed FROM 4000 TO -1 |
| SPSGlobalConfigurationClassServiceCatalog | OrderRecipientFilter | Length was changed FROM 500 TO 1000 |
Version 10.0.1
Version 10.0.1.3050 (12.10.2020)
New Attributes
| Table | Attribute |
|---|---|
| SPSGenericConnectorConfigurationClassAzureAD | ExtensionApplicationID |
| SPSGenericConnectorConfigurationClassAzureAD | ExtensionApplicationIDIsAppClientID |
Version 10.0.1.3025 (19.07.2020)
Updated Tables
| Table | Column | Details |
|---|---|---|
|
SPSComputerClassBase |
DataStoresNames |
Character Length from 4000 to max |
Version 10.0.1.2990 Release Candidate 3 (22.06.2020)
Updated Tables
| Table | Column | Details |
|---|---|---|
|
ITSMEQMClassBase |
Default |
Deleted |
|
SPSGenericConnectorClassBase |
AppName |
Value has changed from '' to Matrix42.DataGateway.Workflow |
Version 10.0.1. 2970 Release Candidate 2 (27.05.2020)
New Tables
| Table |
|---|
| PLSLConnectionTypePickup |
| PLSLConnectionTypePickup-CI |
| ReplaceComplianceRulesIDs |
| PLSLWorkerClassBase |
New Attributes
| Table | Attribue |
|---|---|
| PLSLConnectionTypePickup | DisplayString |
| PLSLConnectionTypePickup | Hidden |
| PLSLConnectionTypePickup | ID |
| PLSLConnectionTypePickup | TimeStamp |
| PLSLConnectionTypePickup | Value |
| PLSLConnectionTypePickup-CI | DisplayString |
| PLSLConnectionTypePickup-CI | ID |
| PLSLConnectionTypePickup-CI | LCID |
| PLSLConnectionTypePickup-CI | Owner |
| PLSLConnectionTypePickup-CI | TimeStamp |
| ReplaceComplianceRulesIDs | NewTypeId |
| ReplaceComplianceRulesIDs | OldTypeId |
Updated Tables
| Table | Column | Details |
|---|---|---|
| PLSLWorkerClassBase | DataProvidersAppState | Added |
| PLSLWorkerClassBase | ProductionDBConnection | Added |
| PLSLWorkerClassBase | WFInstanceDBConnection | Added |
| PLSLWorkerClassBase | WFMonitoringDBConnection | Added |
| PLSLWorkerClassBase | WorkflowsAppState | Added |
Version 10.0.1. 2956 Release Candidate 1 (21.05.2020)
Deleted Tables
| Table |
|---|
| SVCOperationLevelAgreementType |
| SVCUnderpinningContractType |
Updated Tables
| Table | Column | Details |
|---|---|---|
| SPSContractClassBase | UsedInTypeSVCOperationLevelAgreementType | Deleted |
| SPSContractClassBase | UsedInTypeSVCUnderpinningContractType | Deleted |
| SVCServiceLevelAgreementClassBase | UsedInTypeSVCOperationLevelAgreementType | Deleted |
| SVCServiceLevelAgreementClassBase | UsedInTypeSVCUnderpinningContractType | Deleted |
| SVCServiceLevelAgreementClassServiceLevels | UsedInTypeSVCOperationLevelAgreementType | Deleted |
| SVCServiceLevelAgreementClassServiceLevels | UsedInTypeSVCUnderpinningContractType | Deleted |
| SPSSerialNumberClassBase | Key | Character Length from 100 to 500 |
| SPSSerialNumberClassBase | SerialNumber | Character Length from 100 to 500 |
| LCMLicenseDemandRuleClassBase | CombineCondition | Added |
| LCMLicenseDemandRuleClassBase | DataQuery | Added |
| LCMLicenseDemandRuleClassBase | EffectiveStatuses | Added |
| LCMLicenseDemandRuleClassBase | QuerySchemaType | Added |
| PDRApplicationClassBase | PrintLayout | Added |
| PLSLWorkerClassBase | IsDefault | Added |
| PLSLWorkerClassBase | IsLocal | Added |
| PLSLWorkerClassBase | LastHostAddress | Added |
| PLSLWorkerClassBase | LocationHash | Added |
| PLSLWorkerClassBase | RemoteAgent | Added |
| PLSLWorkerClassBase | Trusted | Added |
| PLSLWorkerClassBase | UpdateInterval | Added |
| PLSLWorkflowProcessInstanceClassBase | HasPersistencePoint | Added |
| PLSLWorkflowProcessInstanceClassBase | WorkerName | Added |
| SPSActivityClassBase | Queue | Added |
| SPSADDomainClassBase | DirectoryType | Added |
| SPSComputerClassBase | IsVirtual | Added |
| SPSComputerClassBase | VmType | Added |
| SPSGenericConnectorConfigurationClassAzureAD | SkipImportDeletedObjects | Added |
| SPSGenericConnectorConfigurationClassBase | PasswordPhrase | Added |
| SPSGenericConnectorConfigurationClassBase | PrivateKey | Added |
| SPSGenericConnectorConfigurationClassBase | UsePubkeyAuth | Added |
| SPSGlobalConfigurationClassBase | DefaultPrintLayout | Added |
| SPSGlobalConfigurationClassBase | InMaintenance | Added |
| SPSGlobalConfigurationClassBase | CallTrackerAdditionalPhoneAttributes | Added |
| SPSUserClassBase | ActiveConfigurationProject | Added |
| SVCServiceLevelAgreementClassBase | SLA_Type | Added |
New Tables
| Table |
|---|
| ASMVirtualMachineTypePickup |
| ASMVirtualMachineTypePickup-CI |
| ITSMEQMClassBase |
| ITSMEQMClassBase-CI |
| ITSMEQMProfileStatusPickup |
| ITSMEQMProfileStatusPickup-CI |
| ITSMEQMType |
| LCMOracleProcessorCoreFactorClassBase |
| PDRConfigurationPackageClassBase |
| PDRConfigurationProjectClassBase |
| PDRConfigurationProjectClassChange |
| PDRConfigurationProjectPickupOperation |
| PDRConfigurationProjectPickupOperation-CI |
| PDRDirectoryClassAuth |
| PDRDirectoryClassAuth-CI |
| PDRDirectoryTypePickup |
| PDRDirectoryTypePickup-CI |
| PDRPrintLayoutClassBase |
| SchemaRelation-ITSMEQMClassBase2SPSSecurityClassRole |
| SchemaRelation-ITSMEQMClassBase2SPSUserClassBase0 |
| SchemaRelation-ITSMEQMClassBase2SPSUserSkillGroupsClassBase |
| SPSActivityAgileTypePickup |
| SPSActivityAgileTypePickup-CI |
| SPSActivityClassAgile |
| SPSGlobalConfigurationClassEQM |
| SVCServiceLevelAgreementTypePickup |
| SVCServiceLevelAgreementTypePickup-CI |
New Attributes
| Table | Attribue |
|---|---|
| ASMVirtualMachineTypePickup | Color |
| ASMVirtualMachineTypePickup | DisplayString |
| ASMVirtualMachineTypePickup | Hidden |
| ASMVirtualMachineTypePickup | ID |
| ASMVirtualMachineTypePickup | Image |
| ASMVirtualMachineTypePickup | Position |
| ASMVirtualMachineTypePickup | TimeStamp |
| ASMVirtualMachineTypePickup | Value |
| ASMVirtualMachineTypePickup-CI | DisplayString |
| ASMVirtualMachineTypePickup-CI | ID |
| ASMVirtualMachineTypePickup-CI | LCID |
| ASMVirtualMachineTypePickup-CI | Owner |
| ASMVirtualMachineTypePickup-CI | TimeStamp |
| ITSMEQMClassBase | Color |
| ITSMEQMClassBase | CostCenter |
| ITSMEQMClassBase | Default |
| ITSMEQMClassBase | Description |
| ITSMEQMClassBase | Expression-ObjectID |
| ITSMEQMClassBase | ID |
| ITSMEQMClassBase | Location |
| ITSMEQMClassBase | Name |
| ITSMEQMClassBase | NeedApproveOnUnassign |
| ITSMEQMClassBase | OU |
| ITSMEQMClassBase | Status |
| ITSMEQMClassBase | TimeStamp |
| ITSMEQMClassBase | UsedInTypeITSMEQMType |
| ITSMEQMClassBase-CI | Description |
| ITSMEQMClassBase-CI | ID |
| ITSMEQMClassBase-CI | LCID |
| ITSMEQMClassBase-CI | Name |
| ITSMEQMClassBase-CI | Owner |
| ITSMEQMClassBase-CI | TimeStamp |
| ITSMEQMProfileStatusPickup | DisplayString |
| ITSMEQMProfileStatusPickup | Hidden |
| ITSMEQMProfileStatusPickup | ID |
| ITSMEQMProfileStatusPickup | Position |
| ITSMEQMProfileStatusPickup | TimeStamp |
| ITSMEQMProfileStatusPickup | Value |
| ITSMEQMProfileStatusPickup-CI | DisplayString |
| ITSMEQMProfileStatusPickup-CI | ID |
| ITSMEQMProfileStatusPickup-CI | LCID |
| ITSMEQMProfileStatusPickup-CI | Owner |
| ITSMEQMProfileStatusPickup-CI | TimeStamp |
| ITSMEQMType | ID |
| ITSMEQMType | TimeStamp |
| LCMOracleProcessorCoreFactorClassBase | CPUType |
| LCMOracleProcessorCoreFactorClassBase | ID |
| LCMOracleProcessorCoreFactorClassBase | MatchingExpr |
| LCMOracleProcessorCoreFactorClassBase | OracleCoreFactor |
| LCMOracleProcessorCoreFactorClassBase | TimeStamp |
| LCMOracleProcessorCoreFactorClassBase | Vendor |
| PDRConfigurationPackageClassBase | Description |
| PDRConfigurationPackageClassBase | Expression-ObjectID |
| PDRConfigurationPackageClassBase | FileName |
| PDRConfigurationPackageClassBase | ID |
| PDRConfigurationPackageClassBase | InstalledDate |
| PDRConfigurationPackageClassBase | LastUpdatedDate |
| PDRConfigurationPackageClassBase | Name |
| PDRConfigurationPackageClassBase | PackageID |
| PDRConfigurationPackageClassBase | TimeStamp |
| PDRConfigurationPackageClassBase | TypeID |
| PDRConfigurationPackageClassBase | UpdatedBy |
| PDRConfigurationPackageClassBase | Vendor |
| PDRConfigurationPackageClassBase | Version |
| PDRConfigurationProjectClassBase | CreatedDate |
| PDRConfigurationProjectClassBase | Description |
| PDRConfigurationProjectClassBase | Expression-ObjectID |
| PDRConfigurationProjectClassBase | ID |
| PDRConfigurationProjectClassBase | LastUpdateDate |
| PDRConfigurationProjectClassBase | MajorCurrentVersion |
| PDRConfigurationProjectClassBase | MajorReleaseVersion |
| PDRConfigurationProjectClassBase | MinorCurrentVersion |
| PDRConfigurationProjectClassBase | MinorReleaseVersion |
| PDRConfigurationProjectClassBase | Name |
| PDRConfigurationProjectClassBase | Owner |
| PDRConfigurationProjectClassBase | TechnicalName |
| PDRConfigurationProjectClassBase | TimeStamp |
| PDRConfigurationProjectClassBase | TypeID |
| PDRConfigurationProjectClassChange | ArtifactType |
| PDRConfigurationProjectClassChange | ChangedBy |
| PDRConfigurationProjectClassChange | Date |
| PDRConfigurationProjectClassChange | Descriptor |
| PDRConfigurationProjectClassChange | Expression-ObjectID |
| PDRConfigurationProjectClassChange | ID |
| PDRConfigurationProjectClassChange | MajorPackageVersion |
| PDRConfigurationProjectClassChange | MinorPackageVersion |
| PDRConfigurationProjectClassChange | ObjectID |
| PDRConfigurationProjectClassChange | ObjectName |
| PDRConfigurationProjectClassChange | Operation |
| PDRConfigurationProjectClassChange | SchemaName |
| PDRConfigurationProjectClassChange | SchemaScriptBuild |
| PDRConfigurationProjectClassChange | SchemaScriptMajor |
| PDRConfigurationProjectClassChange | SchemaScriptMinor |
| PDRConfigurationProjectClassChange | SchemaScriptName |
| PDRConfigurationProjectClassChange | SchemaScriptType |
| PDRConfigurationProjectClassChange | TimeStamp |
| PDRConfigurationProjectClassChange | UsedInTypePDRConfigurationProjectType |
| PDRConfigurationProjectPickupOperation | DisplayString |
| PDRConfigurationProjectPickupOperation | Hidden |
| PDRConfigurationProjectPickupOperation | ID |
| PDRConfigurationProjectPickupOperation | Position |
| PDRConfigurationProjectPickupOperation | TimeStamp |
| PDRConfigurationProjectPickupOperation | Value |
| PDRConfigurationProjectPickupOperation-CI | DisplayString |
| PDRConfigurationProjectPickupOperation-CI | ID |
| PDRConfigurationProjectPickupOperation-CI | LCID |
| PDRConfigurationProjectPickupOperation-CI | Owner |
| PDRConfigurationProjectPickupOperation-CI | TimeStamp |
| PDRDirectoryClassAuth | Expression-ObjectID |
| PDRDirectoryClassAuth | ID |
| PDRDirectoryClassAuth | IdentityProviderCertificate |
| PDRDirectoryClassAuth | NameIdAllowCreate |
| PDRDirectoryClassAuth | NameIdPolicy |
| PDRDirectoryClassAuth | Saml2IdentityProviderID |
| PDRDirectoryClassAuth | ServiceProviderIssuerName |
| PDRDirectoryClassAuth | ShowLoginButton |
| PDRDirectoryClassAuth | SignInButtonTitle |
| PDRDirectoryClassAuth | SingleSignOnUriEndpoint |
| PDRDirectoryClassAuth | SingleSignOutUriEndpoint |
| PDRDirectoryClassAuth | TenantId |
| PDRDirectoryClassAuth | TimeStamp |
| PDRDirectoryClassAuth | UsedInTypeSPSADDomainType |
| PDRDirectoryClassAuth-CI | ID |
| PDRDirectoryClassAuth-CI | LCID |
| PDRDirectoryClassAuth-CI | Owner |
| PDRDirectoryClassAuth-CI | SignInButtonTitle |
| PDRDirectoryClassAuth-CI | TimeStamp |
| PDRDirectoryTypePickup | DisplayString |
| PDRDirectoryTypePickup | Hidden |
| PDRDirectoryTypePickup | ID |
| PDRDirectoryTypePickup | Position |
| PDRDirectoryTypePickup | TimeStamp |
| PDRDirectoryTypePickup | Value |
| PDRDirectoryTypePickup-CI | DisplayString |
| PDRDirectoryTypePickup-CI | ID |
| PDRDirectoryTypePickup-CI | LCID |
| PDRDirectoryTypePickup-CI | Owner |
| PDRDirectoryTypePickup-CI | TimeStamp |
| PDRPrintLayoutClassBase | Expression-ObjectID |
| PDRPrintLayoutClassBase | Footer |
| PDRPrintLayoutClassBase | Header |
| PDRPrintLayoutClassBase | ID |
| PDRPrintLayoutClassBase | Name |
| PDRPrintLayoutClassBase | TimeStamp |
| PDRPrintLayoutClassBase | TypeID |
| SchemaRelation-ITSMEQMClassBase2SPSSecurityClassRole | ID |
| SchemaRelation-ITSMEQMClassBase2SPSSecurityClassRole | Queue |
| SchemaRelation-ITSMEQMClassBase2SPSSecurityClassRole | Role |
| SchemaRelation-ITSMEQMClassBase2SPSSecurityClassRole | TimeStamp |
| SchemaRelation-ITSMEQMClassBase2SPSUserClassBase0 | ID |
| SchemaRelation-ITSMEQMClassBase2SPSUserClassBase1 | ManagedBy |
| SchemaRelation-ITSMEQMClassBase2SPSUserClassBase2 | ManageQueue |
| SchemaRelation-ITSMEQMClassBase2SPSUserClassBase3 | TimeStamp |
| SchemaRelation-ITSMEQMClassBase2SPSUserSkillGroupsClassBase | ID |
| SchemaRelation-ITSMEQMClassBase2SPSUserSkillGroupsClassBase | QueueRequirements |
| SchemaRelation-ITSMEQMClassBase2SPSUserSkillGroupsClassBase | RequiredSkills |
| SchemaRelation-ITSMEQMClassBase2SPSUserSkillGroupsClassBase | TimeStamp |
| SPSActivityAgileTypePickup | DisplayString |
| SPSActivityAgileTypePickup | Hidden |
| SPSActivityAgileTypePickup | ID |
| SPSActivityAgileTypePickup | Image |
| SPSActivityAgileTypePickup | Position |
| SPSActivityAgileTypePickup | TimeStamp |
| SPSActivityAgileTypePickup | Value |
| SPSActivityAgileTypePickup-CI | DisplayString |
| SPSActivityAgileTypePickup-CI | ID |
| SPSActivityAgileTypePickup-CI | LCID |
| SPSActivityAgileTypePickup-CI | Owner |
| SPSActivityAgileTypePickup-CI | TimeStamp |
| SPSActivityClassAgile | BusinessValue |
| SPSActivityClassAgile | Effort |
| SPSActivityClassAgile | ID |
| SPSActivityClassAgile | Sprint |
| SPSActivityClassAgile | StackRank |
| SPSActivityClassAgile | TimeStamp |
| SPSActivityClassAgile | Type |
| SPSGlobalConfigurationClassEQM | Enabled |
| SPSGlobalConfigurationClassEQM | Expression-ObjectID |
| SPSGlobalConfigurationClassEQM | ID |
| SPSGlobalConfigurationClassEQM | TimeStamp |
| SPSGlobalConfigurationClassEQM | UsedInTypeSPSGlobalConfigurationType |
| SVCServiceLevelAgreementTypePickup | DisplayString |
| SVCServiceLevelAgreementTypePickup | Hidden |
| SVCServiceLevelAgreementTypePickup | ID |
| SVCServiceLevelAgreementTypePickup | Position |
| SVCServiceLevelAgreementTypePickup | TimeStamp |
| SVCServiceLevelAgreementTypePickup | Value |
| SVCServiceLevelAgreementTypePickup-CI | DisplayString |
| SVCServiceLevelAgreementTypePickup-CI | ID |
| SVCServiceLevelAgreementTypePickup-CI | LCID |
| SVCServiceLevelAgreementTypePickup-CI | Owner |
| SVCServiceLevelAgreementTypePickup-CI | TimeStamp |
Version 10.0
Version 10.0.0.2944 (04.04.2020)
New Attributes
| Table | Attribute |
|---|---|
|
SPSGlobalConfigurationClassServiceDesk |
CallTrackerAdditionalPhoneAttributes |
Version 10.0.0.2934 (General Availability)
New Tables
| Table |
|---|
| PLSLProcessPickupStateReason |
| PLSLProcessPickupStateReason-CI |
| WFPBookmarks |
| WorkerQueueStatistics |
New Attributes
| Table | Attribute |
|---|---|
| PLSLProcessPickupStateReason | Color |
| PLSLProcessPickupStateReason | DisplayString |
| PLSLProcessPickupStateReason | Hidden |
| PLSLProcessPickupStateReason | ID |
| PLSLProcessPickupStateReason | Image |
| PLSLProcessPickupStateReason | Position |
| PLSLProcessPickupStateReason | TimeStamp |
| PLSLProcessPickupStateReason | Value |
| PLSLProcessPickupStateReason-CI | DisplayString |
| PLSLProcessPickupStateReason-CI | ID |
| PLSLProcessPickupStateReason-CI | LCID |
| PLSLProcessPickupStateReason-CI | Owner |
| PLSLProcessPickupStateReason-CI | TimeStamp |
| WFPBookmarks | BookmarkName |
| WFPBookmarks | InstanceId |
| WFPBookmarks | Type |
| WFPBookmarks | Value |
| WorkerQueueStatistics | Count |
| WorkerQueueStatistics | Interval |
| WorkerQueueStatistics | LastUpdated |
| WorkerQueueStatistics | TotalTimeSec |
| LISApplicationMatchEntryClassBase | StandardSLA |
| LISLicenseCatalogItemClassBase | StandardSLA |
| PLSLProcessInstanceClassBase | StateReason |
| PLSLWorkerClassBase | StateDescription |
| PLSLWorkflowProcessInstanceClassBase | BookmarkInputArguments |
| PLSLWorkflowProcessInstanceClassBase | BookmarkName |
| QueueTask | StatusDescription |
| SPSComputerClassBase | ConnectionState |
| SPSComputerClassBase | DataCenter |
| SPSComputerClassBase | DataStoresNames |
| SPSComputerClassBase | inMaintenanceMode |
| SPSComputerClassBase | IsStandalone |
| SPSComputerClassBase | VCenterServerName |
| SPSComputerClassBase | VCenterVersion |
| SPSComputerClassBase | VmotionEnabled |
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 |
| SPSAssetClassBase | Name | Updated length FROM 150 to 300 |
| VirtualComputerAssignedUserProposal | Name | Updated length FROM 100 to 255 |
Version 10.0.0.2846 (Technical Preview 1)
New Attributes
| Table | Attribute |
|---|---|
| LISApplicationMatchEntryClassBase |
StandardSLA |
|
LISLicenseCatalogItemClassBase |
StandardSLA |
Version 9.1
Database schema changes of version 9.0 can be found here.