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

[WojciechRogmanStuffAutomation]

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

[PabloSarabia]

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 🙂

[WojciechRogmanStuffAutomation]

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 😞

[PabloSarabia · Accepted solution]

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 🙂

[WojciechRogmanStuffAutomation]

@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. ​