topic How to find out the retire date of a process? in Product Forum https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67920#M20525 In the Control Room, is there a way to find out when a particular process was retired and when it was last run?&nbsp; Thanks!<BR /><BR />------------------------------<BR />John L<BR />------------------------------<BR /> Fri, 24 Jan 2020 21:09:00 GMT JohnLee 2020-01-24T21:09:00Z How to find out the retire date of a process? https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67920#M20525 In the Control Room, is there a way to find out when a particular process was retired and when it was last run?&nbsp; Thanks!<BR /><BR />------------------------------<BR />John L<BR />------------------------------<BR /> Fri, 24 Jan 2020 21:09:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67920#M20525 JohnLee 2020-01-24T21:09:00Z RE: How to find out the retire date of a process? https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67921#M20526 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.<BR /><BR />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.<BR /><BR />------------------------------<BR />John Carter<BR />Professional Services<BR />Blue Prism<BR />------------------------------<BR /> Tue, 28 Jan 2020 10:14:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67921#M20526 John__Carter 2020-01-28T10:14:00Z RE: How to find out the retire date of a process? https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67922#M20527 Thanks John!<BR /><BR />------------------------------<BR />John L<BR />------------------------------<BR /> Wed, 29 Jan 2020 20:59:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67922#M20527 JohnLee 2020-01-29T20:59:00Z RE: How to find out the retire date of a process? https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67923#M20528 If you are good with SQL, You can probably write a SQL query on [BPAAuditEvents] table&nbsp;<BR /><BR /><BR />SELECT [eventdatetime]<BR /> ,[sNarrative]<BR /> ,[comments]<BR />FROM [dbo].[BPAAuditEvents] where sNarrative like '%retired%' order by [eventdatetime] desc<BR /><BR /> <DIV class="media" style="overflow: hidden;"> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="14255.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/14419iBEFBF297C1C0073C/image-size/large?v=v2&amp;px=999" role="button" title="14255.png" alt="14255.png" /></span></DIV> </DIV> <BR /><BR />------------------------------<BR />Vivek Goel<BR />CoE Lead Architect<BR />Asia/Singapore<BR /><A href="http://www.rpatools.com/" target="test_blank">http://www.rpatools.com/</A><BR />"If you like this post, please press the "Recommend" Button.<BR />------------------------------<BR /> Tue, 04 Feb 2020 08:40:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67923#M20528 vivek.kumar.goel 2020-02-04T08:40:00Z RE: How to find out the retire date of a process? https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67924#M20529 Thanks Vivek!<BR /><BR />------------------------------<BR />John Lee<BR />------------------------------<BR /> Tue, 04 Feb 2020 14:19:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-find-out-the-retire-date-of-a-process/m-p/67924#M20529 JohnLee 2020-02-04T14:19:00Z