How many VDI running on one Process? SQL Query

[HamzaSiddiq]

Hi Team,

I'm looking to create a query which return Number of BOTs running for a given process.

Eg. Process A = 10 Bots running

is there a way to achieve this via SQL Query from BP dB ?

Thanks,

[harish.m]

Hi Hamza SIddiq,

It is definatley possible, but before creating SQL it would be ideal to verify the same capability is present in Blue prism dashboard(Since there are couple of stored procedyre), My guess its not available.

The other option is check whether you are able to pull that information from datagateway.

If none of the above option works I would suggest creating  custom stored procedure ( IN general its not recommend to directly connect to Prod Database and querying it  will impact the performance of BP)

[LeonardoSQueiroz]

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

SELECT COUNT(*) AS RunningBots

FROM [Database_BP].[dbo].[Audit]

WHERE ProcessName = 'Name_Process'

AND Status = 'Running';