topic BP SQL Query - Load Queue Process and Pending Items in Product Forum

BP SQL Query - Load Queue Process and Pending Items

HamzaSiddiq — Mon, 04 Sep 2023 00:09:29 GMT

Hi,

I'm looking to run a query to see

If Load Queue Process has run for today
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,

Re: BP SQL Query - Load Queue Process and Pending Items

harish.mogulluri — Mon, 04 Sep 2023 04:05:40 GMT

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.

Re: BP SQL Query - Load Queue Process and Pending Items

LeonardoSQueiroz — Mon, 04 Sep 2023 04:07:38 GMT

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';