How to get timestamp of the last job or process

Help Insights
1

Hello,

I want to have the last date in Dashborad UiPath. Is it possible ? I don’t want to count twice the same process.

image

Thank you.

Alexis

2

Hi @Alexis_DELEPIERRE

As per my knowledge , apply filters to select your specific process or robot – sort the job list by the End Time column in descending order – the first entry will show the most recent execution date and time.
OR Check- How to get timestamp of the last (specific) job or process (failed or successful) - #2 by supermanPunch

Happy Automation

3

hi, @Alexis_DELEPIERRE How to get timestamp of the last (specific) job or process (failed or successful) - #2 by supermanPunch refer to this link

4

Hello @Alexis_DELEPIERRE Go to your dashboard and add a Table visualization.
From your dataset, use Dimension: Process Name or Robot Logs ECN in your case and measure: Max
This gives you the latest execution date per process.
And optionally add a filter as Robot Logs Status = "Success" and Robot Logs Timestamp is not null

Cheers

5

Hello @Alexis_DELEPIERRE,

Use Linq Query:- dtLogs is your DataTable

(From row In dtLogs.AsEnumerable()
Group row By ECN = row(“Robot Log ECN #”).ToString() Into Group
Let lastDate = Group.Max(Function(r) DateTime.Parse(r(“Robot Logs Timestamp Month”).ToString()))
Select dtLogs.Clone().LoadDataRow(New Object() {ECN, “Success”, lastDate}, False)).CopyToDataTable()