topic @John__Carter : Thanks for… in Product Forum

Copying process ran details from control room

UvarajThangavel — Wed, 21 Mar 2018 16:37:00 GMT

Hi, I wanted to copy the complete information from control room like Process id, processname, status, Startime and End time. Could anyone suggest how to do it. Regards Uvaraj

There's no way to do it…

John__Carter — Wed, 21 Mar 2018 18:07:00 GMT

There's no way to do it using the application, the only way is to query the DB directly.

@John__Carter : Thanks for…

UvarajThangavel — Thu, 22 Mar 2018 12:43:00 GMT

@John__Carter : Thanks for your reply

RE: There's no way to do it…

Dinesh_Kumar_M — Wed, 17 Feb 2021 10:20:00 GMT

@John Carter, Could you please help with the query to fetch data from DB, it would be of great help, thanks in advance.

------------------------------
Dinesh Kumar Mathireddi
------------------------------

RE: @John__Carter : Thanks for…

Dinesh_Kumar_M — Wed, 17 Feb 2021 10:21:00 GMT

@Uvaraj Thangavel, if you have implemented it, could you please help with the query to fetch data from DB / Control Room, it would be of great help, thanks in advance.

------------------------------
Dinesh Kumar Mathireddi
------------------------------

RE: @John__Carter : Thanks for…

IshanMahajan — Thu, 18 Feb 2021 05:38:00 GMT

Hi Dinesh,

If you have access to Blueprism Database, BPASesssion table and BPAPRocess table would have all details.

------------------------------
Ishan Mahajan
India
------------------------------

RE: Copying process ran details from control room

vinodchinthakin — Thu, 18 Feb 2021 06:53:00 GMT

Hi. You can use Process Info VBO. which provides information of processes available in Blue Prism.

------------------------------
vinod chinthakindi
------------------------------

RE: Copying process ran details from control room

SusheelMaurya — Thu, 18 Feb 2021 07:03:00 GMT

Hi,

You can use the below query to get the details you want from db. I have added few fields as you have mentioned in your query.

select P.ProcessID, P.Name,ST.description,S.startdatetime ,s.enddatetime from BPAsession S
INNER JOIN BPAProcess P ON S.processid = P.processid
LEFT JOIN BPAStatus ST ON ST.statusid = S.statusid
--Where name = 'process123' -- you can use where condition for any specific process

------------------------------
Susheel Maurya
Team Leader - Process Excellence
Metlife
Noida
------------------------------

RE: @John__Carter : Thanks for…

Dinesh_Kumar_M — Thu, 18 Feb 2021 07:08:00 GMT

Hi Ishan, Thank you, I am aware of the DB tables and tried to have the query and as only few people have limited access to DB, so I have suggested an Idea in Ideation page/Ideas portal, please click on below link to upvote and add your comments

https://community.blueprism.com/get-involved/ideas/viewidea?IdeationKey=dfc2fac3-8d6f-4407-8258-32c5bdbba4de

Thanks,
Dinesh M

------------------------------
Dinesh Kumar Mathireddi
------------------------------

RE: Copying process ran details from control room

Ashis_KumarRay — Fri, 19 Feb 2021 11:00:00 GMT

Hi,

@SusheelMaurya, I have also received some SQL queries (Same as above) from BP tech team to extract data from BPASession table. But I just wanted to know how do you use these queries to get the data from BP Table?

Are you using a separate Macro which contains these SQL queries and running from outside of BP or using "Data - SQL Server" object to extract data? If possible please let me know all the required steps to get the data from BP Tables.

Thanks
Ashis

------------------------------
Ashis Kumar Ray
RPA Developer
TCS
Europe/London
------------------------------

RE: Copying process ran details from control room

Dinesh_Kumar_M — Fri, 19 Feb 2021 12:11:00 GMT

Hi Ashis,

If you have access to DB (at least read), you can query and fetch the details and export to excel / copy and paste to excel, as per BP Tech team, querying frequently may also have performance issues, to avoid all this I have suggested an Idea in the Idea portal to implement but they require more than 20 votes it seems (Thanks for voting).

Regards,
Dinesh M

------------------------------
Dinesh Kumar Mathireddi
------------------------------

RE: Copying process ran details from control room

Ashis_KumarRay — Fri, 19 Feb 2021 13:16:00 GMT

Hi Dinesh,

Thanks for your effort to suggest a wonderful idea and yes, I have voted as well.

But till then the idea would be considered by BP, I need to use the query to extract data from DB as it is now demand from customer side. Thus I just wanted to know how do you use the query it means from where e.g. to write a Macro and run from outside or from BP Object etc. I am completely aware that to fetch data from DB we need certain level of access and we will get those if we request to infra team. Please share with me the method if you are currently using anything in your project.

Thanks
Ashis

------------------------------
Ashis Kumar Ray
RPA Developer
TCS
Europe/London
------------------------------