Below SQL query will give you a relation of items that pretty cloesely matches the control room.
Recommend setting up a mirror of the PROD database BP uses and querying that instead of the live PROD tables.
------------START of SQL
declare @LoadFromDate as datetime
set @LoadFromDate = getdate(); -- gets everything from today
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 and see if there is any invalid inpouts
,WQI.SessionID
,WQI.[Status]
,WQI.ExceptionReason
from XXXXXX.dbo.BPAWorkQueueItem as WQI with (nolock) -- Replace XXXX with your DB name
where WQI.LastUpdated >= @LoadFromDate
;