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.
Have you tried using the Execution Log Fields filter in the saved search Criteria/Results? It offers Date and Time fields
- Reports > Saved Searches > All Saved Searches > New
- Results (TAB) > Execution Log Fields…. > Date | Time