cancel
Showing results for 
Search instead for 
Did you mean: 

Where is the image that can be obtained by "Show latest screen capture" saved on the database?

TetsuoKin
Level 2

Hi, 

I want to get the screen capture from Blue Prism Database. (and want to reuse it)

Is there anyone kindly tell me where I can get it?( table name or something...)

(I know I can get screen capture from BP's Control, but I wonder if I can get itdirectly  from Database)  

Sorry for my poor English.

It is very appriciated your kind reply.

Thanks in advance.

Tetsu

1 BEST ANSWER

Helpful Answers

Hi @TetsuoKin1,

Once you have enabled the necessary setting and user role to allow you to view screen captures on your resource from control room, you can get the same screenshot byte code from the 'screenshot' column in the 'BPAScreenshot' table in your SQL Server database as shown below:

SELECT TOP (1000) [id]
      ,[resourceid]
      ,[stageid]
      ,[processname]
      ,[lastupdated]
      ,[timezoneoffset]
      ,[screenshot]
      ,[encryptid]
  FROM [Blue Prism].[dbo].[BPAScreenshot]​


37040.png

37041.png

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

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

----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.

View answer in original post

2 REPLIES 2

Hi @TetsuoKin1,

Once you have enabled the necessary setting and user role to allow you to view screen captures on your resource from control room, you can get the same screenshot byte code from the 'screenshot' column in the 'BPAScreenshot' table in your SQL Server database as shown below:

SELECT TOP (1000) [id]
      ,[resourceid]
      ,[stageid]
      ,[processname]
      ,[lastupdated]
      ,[timezoneoffset]
      ,[screenshot]
      ,[encryptid]
  FROM [Blue Prism].[dbo].[BPAScreenshot]​


37040.png

37041.png

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

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

----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.

TetsuoKin
Level 2

Hi, @Devneet Mohanty

Thanks for quick Responce! I think your answer helps me to solve the prolem.