Process Status/Last Run Time

[Rebecca1990]

Is it possible to get the latest status of the last time a specific Process ran, so if it Terminated, Completed etc... and the time the process started? 

I need to be able to confirm a process fully completed and the time it started to ensure another process can start and trying to avoid putting this as a manual task on the Controllers. 

I know I could use the Work Queue to check last completion/exception time and if there's any pending cases but the queue can load cases and still terminate without completing the cases it has to load and this figure can vary day to dau 

[david.l.morris · Accepted solution]

You'd have to do a SQL query on the Blue Prism database for that information. It would involve some joins involving at least the BPAProcess and BPASession tables.

[Neel1 · Accepted solution]

another option is if you are set up on BP API which eventually query the DB

You can run a GET API call on the resource endpoint to determine whether any process is currently running on a specific resource.

Also, you can query for a specific process on a specific resource as well.

https://api.yourcompany.com/api/v7/sessions?sessionParameters.sortBy=SessionNumberDesc&sessionParameters.itemsPerPage=1&sessionParameters.resourceName.strtw=Resourcename

[Rebecca1990]

Thanks Dave and for replying so quick. I thought that might be case - I was living in hope there might have been an internal object I was missing! 

[Rebecca1990]

I'm trying to determine if we have the authentication server as part of our software which is what I believe is needed to use the BP APIs. fingers crossed