topic save list of sessins in Product Forum

save list of sessins

sumire — Fri, 10 Jan 2020 05:58:00 GMT

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
------------------------------

RE: save list of sessins

nobu — Mon, 13 Jan 2020 01:18:00 GMT

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
------------------------------

RE: save list of sessins

sumire — Tue, 14 Jan 2020 04:46:00 GMT

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

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