topic How many VDI running on one Process? SQL Query in Product Forum

How many VDI running on one Process? SQL Query

HamzaSiddiq — Mon, 04 Sep 2023 00:12:00 GMT

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,

Re: How many VDI running on one Process? SQL Query

harish.mogulluri — Mon, 04 Sep 2023 03:56:30 GMT

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)

Re: How many VDI running on one Process? SQL Query

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

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