viewTddQueueHistory
- Last UpdatedNov 22, 2017
- 1 minute read
This view returns a record- set of any requests that have finished processing. It also includes those requests that have started processing.
Note: This view will only have data if EnableQueueHistory is set to true in EMIRuntimeConfigurator.xml, located at Intelligence/bin. For more information, refer to the Performance Settings.
|
Column |
Description |
|---|---|
|
ID |
The autogenerated History-ID |
|
TDD Queue-Id |
The auto-generated Queue ID |
|
(Target) Measure |
The Guid of the Data Item (Measure) |
|
(Target) Measure DataItem Guid |
The name of the DataItem Measure which is targeted to be updated |
|
(Source) Dimension |
The Guid of the DataItem Measure which is targeted to be updated |
|
(Source) Dimension |
The name of the DataItem Dimension which is the TDD source that requested the Measure update. |
|
DataItem Guid |
The Guid of the DataItem Dimension which is the TDD source that requested the Measure update. |
|
TDD Start-time (UTC) |
The earliest calculated start date and time of the update to the target |
|
TDD End-time (UTC) |
The earliest calculated end date and time of the update to the target |
|
Processing Status |
The current status (Pending) |
|
TDD Queue TimeStamp |
The date and time when the TDD measure update was requested |
|
History TimeStamp |
The date and time when the row was added to the History table |
Example:
Select * from [dbo].[viewTddQueueHistory]