save list of sessins

[sumire]

Hi,

I want to save list of sessions displayed on current screen of control room.
csv, excel, text, any file type ok, please tell me how to save.

Thanks in advance

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

[nobu · Accepted solution]

Hi Mitsuko,

You can't export the list of sessions displayed on Session Management page. However, you can export the data from Report page (Control --> Scheduler --> Report) with the similar condition in Session management page. 

If you prefer the same data structure (ID, Process, Resource, User, Status, Start Time, End Time.....), it can be done by SQL script if you have a access to the database. If you don't have access, admin user in your company could create a process to call "Data - SQL Server" VBO with Credential manager to run the SQL script to get the data. Actually we don't recommend the direct access to the database but if your company allows you to do this, please consider this option. The related tables would be "BPASession" and "BPASession_Unicode" or "BPASession_NonUnicode". 

Regards,

Nobu


 



------------------------------
Nobuhiro Tokushige
Product Specialist
Blue Prism
Australia/Sydney
------------------------------

[sumire]

Thanks Mr Tokushige
I am too cowardly to access to database directly, so I get data form report page.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------