I’m trying to get a saved search to display the date/time and status of the last execution of a few scripts to show on a dashboard search.

I’ve created a script instance search, with date (last 5 days) and deployment ID criteria.

On the results page, I’m displaying:

Script Deployment : Title    (Summary : Group)
Formula (Date/Time) nl_tz.convert({datecreated})     (Summary : Maximum)
Status    (Summary : Maximum)
Percent Complete     (Summary : Minimum)

This generally works, but if the script has failed at any time in the last 5 days, status shows as failed, even if subsequent executions have completed successfully.

Can anyone suggest a simple way to display JUST the last log entry. I presume there’s a simple way to use a summary criteria to achieve this, but haven’t quite grasped how this works as yet.