Database Schema Changes 10.0.x
Table of Contents
List of database schema changes for Enterprise Service Management 10.0.x
Version 10.0.4
Version 10.0.4.3279
Version 10.0.4.3273
Version 10.0.4.3252
Version 10.0.4.3240
Version 10.0.4.3235
Version 10.0.4.3226
Version 10.0.4.3222
Version 10.0.4.3212
Version 10.0.4.3206
Version 10.0.4.3202
Version 10.0.4.3183 - Technical Release
Version 10.0.4.3159 - Technical Preview 1
Version 10.0.3
Version 10.0.3.3162
Version 10.0.3.3150
Version 10.0.3.3138
Version 10.0.3.3129
Version 10.0.3.3127 - GA
Version 10.0.3.3123 - Release Candidate 5
Version 10.0.3.3120 - Release Candidate 4
Version 10.0.3.3119 - Release Candidate 3
Version 10.0.3.3108 (10.12.2020) - Release Candidate 2
Version 10.0.3.3089 (13.10.2020) - Release Candidate 1
Version 10.0.3.3048 (13.10.2020) - Technical Preview 1
Version 10.0.2
Version 10.0.2.3127 (12.05.2022)
Version 10.0.2.3123 (12.01.2022)
Version 10.0.2.3120 (04.11.2021)
Version 10.0.2.3110 (10.06.2021)
Version 10.0.2.3107 (13.04.2021)
Version 10.0.2.3099 (15.02.2021)
Version 10.0.2.3081 (26.11.2020)
Version 10.0.2.3077 (16.11.2020)
Version 10.0.2.3047 (01.10.2020)
Version 10.0.2.3011 Release Candidate 1 (21.08.2020)
Version 10.0.1
Version 10.0.1.3050 (12.10.2020)
Version 10.0.1.3025 (19.07.2020)
Version 10.0.1.2990 Release Candidate 3 (22.06.2020)
Version 10.0.1. 2970 Release Candidate 2 (27.05.2020)
Version 10.0.1. 2956 Release Candidate 1 (21.05.2020)
Version 10.0
Version 10.0.0.2944 (04.04.2020)
Version 10.0.0.2934 (General Availability)
Version 10.0.0.2846 (Technical Preview 1)
Version 9.1
List of database schema changes for Enterprise Service Management 10.0.x
Version 10.0.4
Version 10.0.4.3279
No database schema changes have been made in this version
Version 10.0.4.3273
No database schema changes have been made in this version
Version 10.0.4.3252
No database schema change have been made in this version
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.3222
No database schema changes have been made in this version
Version 10.0.4.3212
New Attributes
| able | Attribute |
|---|---|
| PLBEActivationClassTask | DoNotRun |
Version 10.0.4.3206
Version 10.0.4.3202
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.3150
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.3129
No database schema changes have been made in this version
Version 10.0.3.3127 - GA
No database schema changes have been made in this version
Version 10.0.3.3123 - Release Candidate 5
No database schema changes have been made in this version
Version 10.0.3.3120 - Release Candidate 4
No database schema changes have been made in this version
Version 10.0.3.3119 - Release Candidate 3
No database schema change have been made in this version
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.3123 (12.01.2022)
No database schema changes have been made in this version
Version 10.0.2.3120 (04.11.2021)
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.