topic How to get Session Logs in Blue Prism of a particular item key in an excel from command line parameters in Product Forum

How to get Session Logs in Blue Prism of a particular item key in an excel from command line parameters

Digital_WorkerB — Sat, 25 Jul 2020 07:03:00 GMT

Im working on a project on Blue Prism and I would want to fetch Session logs and export to an excel file in my local Machine.

I want to achieve this functionality from Command Prompt. Kindly help me out if there is any solution.

--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by gautham lg.

RE: How to get Session Logs in Blue Prism of a particular item key in an excel from command line parameters

hossein.azimi — Sun, 26 Jul 2020 23:19:00 GMT

Hi there,

You can not export a session log via the command line, but you can use the SQL database to get information about it.

------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Sydney NSW
------------------------------

RE: How to get Session Logs in Blue Prism of a particular item key in an excel from command line parameters

PankajNaik — Mon, 27 Jul 2020 04:41:00 GMT

Hi,

You can explore Data Gateway feature in BP , but it is available after 6.5 version . Using this you can export session log anywhere out side blue prism. Once you get outside then you can play with that file according to your need.

------------------------------
Pankaj Naik
------------------------------

RE: How to get Session Logs in Blue Prism of a particular item key in an excel from command line parameters

MindaugasBresku — Mon, 27 Jul 2020 06:54:00 GMT

Hi,

actually you can do it trough command line but the SQL is preferable if available because cmd line has its limitations

cmd line scenario:
1. you need to have Blue Prism session id (might be get in the process calculation with standard Blue Prism GetSessionId() ) and saved for later usage of getting session log
2. run automatec with <..commection/login...> /getlog "session ID from 1st stage" > c:\temp\exported_log.csv
3. get that csv read into excel

limitations that I know (might be wrong here as not used this feature extensively):
- only standard fields in log (Date, Stage ID, Stage Name, Parameters)
- no parameters if they are not explicit (if they have a "View" expansion in log)

------------------------------
Mindaugas Breskus
Software engineer
Swedbank
Europe/Vilnius
------------------------------