Control Room - Work Queue View

[RatnaRatna]

I wanted to know if there is a  view or a stored procedure by which BP is pulling the information on the front end Control Room Queue View . 

[TomCirone]

All the information is stored in tables starting with BPAWorkQueue.  BPAWorkQueue table is the queue information, BPAWorkQueueItem is most of the information on the an item in the queue, BPAWorkQueueItemTag links the tags with the items, etc.

[BenKirimlidis]

declare         @LoadFromDate as datetime set               @LoadFromDate = convert(date,getdate()-30);   -- gets everything from last 30 days select                             WQI.KeyValue                   ,WQI.LastUpdated                   ,WQI.Loaded                   ,WQI.Completed                      ,WQI.Exception                            ,WQI.Deferred                        ,WQI.Worktime                       ,WQI.Data           -- Might not be needed but handy if you can extract the data                   ,WQI.SessionID                   ,WQI.[Status]                   ,WQI.ExceptionReason from        XXXXXX.dbo.BPAWorkQueueItem as WQI with (nolock)    -- Replace XXXX with your DB name where       WQI.LastUpdated >= @LoadFromDate ;