topic Re: Cannot see the entire history of robot runs in the Control Room in Product Forum

Cannot see the entire history of robot runs in the Control Room

WojciechRogmanStuffAutomation — Wed, 05 May 2021 15:08:28 GMT

Hi,

1. I have problem with Control Room and controlling runs of the processes. No filter apllied.
I cannot see the history. The only thing which shows up are random runs from past (sometimes last one).

Is this TAB responsible for it?:

2. Do you know where (which table) in BluePrism database I can find data related to 1. question? (the history of runs?)

Thanks

Re: Cannot see the entire history of robot runs in the Control Room

PabloSarabia — Wed, 05 May 2021 15:33:35 GMT

Hello!!

I don't know exactly why it is not working but here is a query to retrieve it by database

SELECT sessionnumber
, PROCESS.name
, RESOUR.name
, CASE WHEN SES.statusid = 1 AND DATEDIFF(minute,SES.lastupdated,getdate()) >= 5 THEN 'Warning' ELSE STAT.description END AS [status]
, startdatetime
, enddatetime
, SES.lastupdated
, SES.laststage
FROM BPASession SES
INNER JOIN BPAResource RESOUR WITH(NOLOCK) ON SES.runningresourceid = RESOUR.resourceid
INNER JOIN BPAStatus STAT WITH(NOLOCK) ON SES.statusid = STAT.statusid
INNER JOIN BPAProcess PROCESS WITH(NOLOCK) ON SES.processid = PROCESS.processid

Hope this helps you

Bye 🙂

Re: Cannot see the entire history of robot runs in the Control Room

WojciechRogmanStuffAutomation — Wed, 05 May 2021 15:44:21 GMT

Thank you @PabloSarabia but the problem is that in my BP database there is no data from runs which I was describing. So your query exposes the same lacks as control room 😞

Re: Cannot see the entire history of robot runs in the Control Room

PabloSarabia — Wed, 05 May 2021 16:16:01 GMT

Oh! Can you check how you have set up automatic archiving?

You will probably have it in place for a short period of time.

Bye 🙂

Re: Cannot see the entire history of robot runs in the Control Room

WojciechRogmanStuffAutomation — Wed, 05 May 2021 18:58:53 GMT

@PabloSarabia I think that it is the problem. I noticed that after posting this question. I changed it already and I'm waiting for results 🙂 Thank for help. I will mark your answer as a solution after checking.