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.