topic Re: Where is the image that can be obtained by "Show latest screen capture" saved on the database? in University Forum

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

TetsuoKin — Thu, 13 Oct 2022 09:18:12 GMT

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

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

devneetmohanty07 — Thu, 13 Oct 2022 11:27:59 GMT

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]

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

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

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

TetsuoKin — Fri, 14 Oct 2022 01:23:38 GMT

Hi, @Devneet Mohanty

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