Tables [dbo].[ConsolidationProcessInfo]
PropertyValue
Row Count (~)0
Created1:20:01 AM Thursday, March 21, 2019
Last Modified1:20:01 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDescription
Cluster Primary Key PK_ConsolidationProcessInfo_ID: IDIDint4
False
1 - 1
Enabledbit1
True
ProcessStatustinyint1
True
StartDatedatetime8
True
RunningTimebigint8
True
RunTime in seconds
ResumeCountsint4
True
ProcessedAccountsint4
True
ProcessedDevicesint4
True
FirstConsolidationOccurredbit1
True
FirstConsolidationAdminNotificationShownbit1
True
FirstConsolidationAdminNotificationDismissedbit1
True
CurrentDataRetentionPoliciesxmlmax
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_ConsolidationProcessInfo_ID: IDPK_ConsolidationProcessInfo_IDID
True
CREATE TABLE [dbo].[ConsolidationProcessInfo]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[Enabled] [bit] NULL,
[ProcessStatus] [tinyint] NULL,
[StartDate] [datetime] NULL,
[RunningTime] [bigint] NULL,
[ResumeCounts] [int] NULL,
[ProcessedAccounts] [int] NULL,
[ProcessedDevices] [int] NULL,
[FirstConsolidationOccurred] [bit] NULL,
[FirstConsolidationAdminNotificationShown] [bit] NULL,
[FirstConsolidationAdminNotificationDismissed] [bit] NULL,
[CurrentDataRetentionPolicies] [xml] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ConsolidationProcessInfo] ADD CONSTRAINT [PK_ConsolidationProcessInfo_ID] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'RunTime in seconds', 'SCHEMA', N'dbo', 'TABLE', N'ConsolidationProcessInfo', 'COLUMN', N'RunningTime'
GO