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.
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.
