BP SQL Query - Load Queue Process and Pending Items

[HamzaSiddiq]

Hi,

I'm looking to run a query to see

1. If Load Queue Process has run for today
2. And how many cases are pending in the Queue for that particular process.

This will be run every 1 hour (example)

Is there a way we can run this query and fetch from BP Db (blue Prims 6.4 Version)?

Thanks, 

[harish.mogulluri]

HI Hamza Siddiq,

In general what ever we do in Blue Prism client   in data point of view, You are able to pull the data from database in my opnion

Regarding your query - Yes definatley able to pull how many  process ran today and  not sure about the pending items but those data will definatley will be available in database table.

[LeonardoSQueiroz]

Hello, replace the following query with the respective Database, table and process name.

If Load Queue Process has run for today

SELECT TOP 1 1 FROM [BP_DB].[dbo].[Audit]

WHERE ProcessName = 'ProcessName'

AND CAST(StartTime AS DATE) = CAST(GETDATE() AS DATE);

And how many cases are pending in the Queue for that particular process.

SELECT COUNT(*) AS PendingCS

FROM [BP_DB].[dbo].[QueueItems]

WHERE ProcessName = 'Process_Name'

AND [State] = 'Pending';