Control Room Process session log

[vigneshShankar]

Hi All,

Is there any way we could export session log data via excel/csv from control room without using the default functionalities like

• Data Gateway
• Command Line (CMD prompt methodology)
• Lastly, directly export session log in control room.

My requirement is can we automate this task via in process or code analysis in bp inter active client.

For instance:  when the process Terminated/completed in the control room without entering the session log , we would directly go to particular folder directory for that day process folder in session log data excel/csv list.


Thanks
Vignesh.S

------------------------------
vignesh Shankar
------------------------------

[devneetmohanty07 · Accepted solution]

Hi Vignesh,

As you already mentioned the approaches that you could have taken for exporting the logs, some additional approaches I would like to mention.

- Not definitely a recommended one but of you have the access to the database directly, then you can fire SQL queries to the following tables: 'BPASessionLog_NonUnicode' and 'BPASession'. You can join the tables based on the 'sessionnumber' column to get a even precise level of detail with respect to different runtime resources, logging level etc. If it is just a SELECT query there should not be much of an issue depending on your IT privileges and infrastructure set up at your organisation.

- Next approach that you can go for is only possible via Blue Prism API's which are available from version 7.0. You have a direct endpoint to export the sessions logs based on a given 'session id' . For more details, please follow the given URL: Export Session Logs Via Blue Prism API

NOTE: The above two approaches can be either triggered independently via an external Powershell script and be scheduled accordingly, or you can create a separate Blue Prism process to develop your own workflow which can interact with either SQL Server database or REST API's.

With this being said, you can also go for the command line approach if you can call the same via any process. There are VBO's which can help you to trigger CMD based commands if the above two approaches are not feasible. Let us know if that helps to resolve your doubts.


------------------------------
----------------------------------
Hope it helps you and if it resolves you 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

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