RE: Saved Search Last Script Execution

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.

dominicb Beginner Asked on October 10, 2019 in Saved Searches.
Add Comment
4 Answers

Thank both. We’re using this on a dashboard view, so need it to display single lines immediately without external manipulation. We have a custom warehouse order fulfilment system, which prepares various stages of pick batches using a  number of scheduled scripts. The search on the user’s dashboard allows them to see when the process for each stage has completed. It’s pretty close to working – it’s just the fact that a failed script keeps displaying ‘Failed’ despite subsequent successful runs which is an annoyance at the moment.

Beginner Answered on October 11, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.