https://community.blueprism.com/t5/Product-Forum/Reporting-on-Deferred-Items/m-p/54061#M8652 /* Your DB name will be different, log into your MS SQL DB (ideally the mirror not the production DB) Substitute in your DB name for 'DATABASE_NAME' in the SQL query below. You can add to the WHERE clause to get only the records you are interested in Change up the query below to fit your needs */ declare     @LoadFromDate as datetime set            @LoadFromDate = getdate()-30;   -- gets everything from last 30 days select                             WQI.KeyValue                   ,WQI.LastUpdated                   ,WQI.Loaded                   ,WQI.Completed    ​​​​​​​                  ,WQI.Exception          ​​​​​​​                  ,WQI.Deferred     -- This is the field you are interested in ​​​​​​​                  ,WQI.Worktime     ​​​​​​​                  ,WQI.Data           -- Might not be needed but handy if you can extract the data ​​​​​​​                  ,WQI.SessionID  -- Useful to each action to a session ​​​​​​​                  ,WQI.[Status] ​​​​​​​                  ,WQI.ExceptionReason  from           [DATABASE_NAME].dbo.BPAWorkQueueItem as WQI with (nolock)    -- Your DB name is different where        WQI.LastUpdated >= @LoadFromDate ; Sun, 27 Jan 2019 05:33:00 GMT BenKirimlidis 2019-01-27T05:33:00Z https://community.blueprism.com/t5/Product-Forum/Reporting-on-Deferred-Items/m-p/54060#M8651 Hello,   I am looking for a way to report on deferred items. My use case is as below:   I have worked an item today, but have deferred the item for 10 days. The business would like to see a daily report that details out cases that have been deferred that day. IE say I worked 10 items today, but deferred 3 of them for 10 days, they would like a report to showing the 3 items that were deferred in addition to the others that were completed/excepted.    Thanks in advance!   Fri, 28 Dec 2018 19:50:00 GMT https://community.blueprism.com/t5/Product-Forum/Reporting-on-Deferred-Items/m-p/54060#M8651 Anonymous 2018-12-28T19:50:00Z https://community.blueprism.com/t5/Product-Forum/Reporting-on-Deferred-Items/m-p/54061#M8652 /* Your DB name will be different, log into your MS SQL DB (ideally the mirror not the production DB) Substitute in your DB name for 'DATABASE_NAME' in the SQL query below. You can add to the WHERE clause to get only the records you are interested in Change up the query below to fit your needs */ declare     @LoadFromDate as datetime set            @LoadFromDate = getdate()-30;   -- gets everything from last 30 days select                             WQI.KeyValue                   ,WQI.LastUpdated                   ,WQI.Loaded                   ,WQI.Completed    ​​​​​​​                  ,WQI.Exception          ​​​​​​​                  ,WQI.Deferred     -- This is the field you are interested in ​​​​​​​                  ,WQI.Worktime     ​​​​​​​                  ,WQI.Data           -- Might not be needed but handy if you can extract the data ​​​​​​​                  ,WQI.SessionID  -- Useful to each action to a session ​​​​​​​                  ,WQI.[Status] ​​​​​​​                  ,WQI.ExceptionReason  from           [DATABASE_NAME].dbo.BPAWorkQueueItem as WQI with (nolock)    -- Your DB name is different where        WQI.LastUpdated >= @LoadFromDate ; Sun, 27 Jan 2019 05:33:00 GMT https://community.blueprism.com/t5/Product-Forum/Reporting-on-Deferred-Items/m-p/54061#M8652 BenKirimlidis 2019-01-27T05:33:00Z