https://community.blueprism.com/t5/Product-Forum/Know-the-number-of-sessions-for-a-particular-process-for-a/m-p/61327#M14643 Hi All,&nbsp;<BR />How do we know &nbsp;the number of sessions of a particular process for a particular day?<BR />Is there any way to know it from control room ?<BR />If we have to query the DB, may I know the query please<BR /><BR />------------------------------<BR />Yashaswini B<BR />------------------------------<BR /> Sat, 12 Mar 2022 07:22:00 GMT YashaswiniB 2022-03-12T07:22:00Z https://community.blueprism.com/t5/Product-Forum/Know-the-number-of-sessions-for-a-particular-process-for-a/m-p/61327#M14643 Hi All,&nbsp;<BR />How do we know &nbsp;the number of sessions of a particular process for a particular day?<BR />Is there any way to know it from control room ?<BR />If we have to query the DB, may I know the query please<BR /><BR />------------------------------<BR />Yashaswini B<BR />------------------------------<BR /> Sat, 12 Mar 2022 07:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Know-the-number-of-sessions-for-a-particular-process-for-a/m-p/61327#M14643 YashaswiniB 2022-03-12T07:22:00Z https://community.blueprism.com/t5/Product-Forum/Know-the-number-of-sessions-for-a-particular-process-for-a/m-p/61328#M14644 Hi Yashaswini,<BR /><BR />The following query can help you to get the number of sessions being run on any particular date and for any particular process:<BR /><BR /><CODE>SELECT B.[name] AS process_name, COUNT(A.[processid]) AS session_count </CODE><BR /><CODE>FROM [Blue Prism].[dbo].[BPASession] A INNER JOIN [Blue Prism].[dbo].[BPAProcess] B</CODE><BR /><CODE>ON A.processid = B.processid</CODE><BR /><CODE>WHERE CAST(A.[startdatetime] AS DATE) = '<SPAN style="background-color: #ffff00;">&lt;DATE_VALUE&gt;</SPAN>' </CODE><BR /><CODE>AND B.name = '<SPAN style="background-color: #ffff00;">&lt;PROCESS_NAME&gt;</SPAN>'</CODE><BR /><CODE>GROUP BY B.[name]<BR /><BR /></CODE>Substitute the highlighted text as per your requirement. Below is a sample query being run:<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="20926.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/21070i465D2978DDB48D6A/image-size/large?v=v2&amp;px=999" role="button" title="20926.png" alt="20926.png" /></span><BR /><BR />------------------------------<BR />----------------------------------<BR />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<BR /><BR />Regards,<BR />Devneet Mohanty<BR />Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,<BR />Wonderbotz India Pvt. Ltd.<BR />Blue Prism Community MVP | Blue Prism 7x Certified Professional<BR />Website: <A href="https://devneet.github.io/" target="test_blank">https://devneet.github.io/</A><BR />Email: devneetmohanty07@gmail.com<BR /><BR />----------------------------------<BR />------------------------------<BR /> Sat, 12 Mar 2022 09:02:00 GMT https://community.blueprism.com/t5/Product-Forum/Know-the-number-of-sessions-for-a-particular-process-for-a/m-p/61328#M14644 devneetmohanty07 2022-03-12T09:02:00Z https://community.blueprism.com/t5/Product-Forum/Know-the-number-of-sessions-for-a-particular-process-for-a/m-p/61329#M14645 <DIV class="uconBody"><DIV> <DIV> <DIV style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" dir="ltr"> Thank you so much, I will try this</DIV> </DIV> <DIV> <DIV><BR /> </DIV> Get <A href="https://aka.ms/o0ukef">Outlook for iOS</A></DIV> </DIV></DIV><BR /><BR /> Sat, 12 Mar 2022 09:07:00 GMT https://community.blueprism.com/t5/Product-Forum/Know-the-number-of-sessions-for-a-particular-process-for-a/m-p/61329#M14645 YashaswiniB 2022-03-12T09:07:00Z