viewEventQueueHistory
- Last UpdatedJan 30, 2019
- 1 minute read
This view returns a record-set of all requests that have been processed, consolidated, purged, cleared, or are currently processing in the Event Queue.
Note: This view will only have data if EnableEventQueueHistory 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 |
|
Event Queue-Id |
The autogenerated Queue-ID |
|
DataItem |
The name of the Data Item (Dimension or Measure) |
|
DataItem Guid |
The Guid of the Data Item (Dimension or Measure) |
|
Event Start-time (UTC) |
The start date and time for the requested event |
|
Event End-time (UTC) |
The end date and time for the requested event. |
|
Comment |
Optional comment value. Runtime service may utilize this field when resetting event. |
|
Processing Status |
The current status of the event |
|
Event Queue TimeStamp |
The date and time when the event was added to the Queue |
|
Last Modified Time |
The last time that the row was modified by the runtime service. |
|
History TimeStamp |
The date and time when the row was added to the History table |
Example:
Select * from [dbo].[viewEventQueueHistory]