How to find out the retire date of a process?

[JohnLee]

In the Control Room, is there a way to find out when a particular process was retired and when it was last run?  Thanks!

------------------------------
John L
------------------------------

[John__Carter]

The last run date will be in the list of session in control room, assuming the last session record has not been archived. You can apply a filter on the process name to list all the sessions for that process.

Retirement is a status rather than a date, so you won't find a date in control room, or as far as I can see, in the DB.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

[JohnLee]

Thanks John!

------------------------------
John L
------------------------------

[vivek.kumar.goel]

If you are good with SQL, You can probably write a SQL query on [BPAAuditEvents] table 


SELECT [eventdatetime]
,[sNarrative]
,[comments]
FROM [dbo].[BPAAuditEvents] where sNarrative like '%retired%' order by [eventdatetime] desc

------------------------------
Vivek Goel
CoE Lead Architect
Asia/Singapore
http://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------

[JohnLee]

Thanks Vivek!

------------------------------
John Lee
------------------------------