Know the number of sessions for a particular process for a particular day

[YashaswiniB]

Hi All, 
How do we know  the number of sessions of a particular process for a particular day?
Is there any way to know it from control room ?
If we have to query the DB, may I know the query please

------------------------------
Yashaswini B
------------------------------

[devneetmohanty07]

Hi Yashaswini,

The following query can help you to get the number of sessions being run on any particular date and for any particular process:

SELECT B.[name] AS process_name, COUNT(A.[processid]) AS session_count
FROM [Blue Prism].[dbo].[BPASession] A INNER JOIN [Blue Prism].[dbo].[BPAProcess] B
ON A.processid = B.processid
WHERE CAST(A.[startdatetime] AS DATE) = '<DATE_VALUE>'
AND B.name = '<PROCESS_NAME>'
GROUP BY B.[name]

Substitute the highlighted text as per your requirement. Below is a sample query being run:



------------------------------
----------------------------------
Hope it helps you and if it resolves your query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

[YashaswiniB]

Thank you so much, I will try this

Get Outlook for iOS