scriptactivity failures to show last successes of the given script

[Steve McInerney]

Almost every time we have a reported failure via scriptactivity, one of the very first steps I'll do in the initial triage is "when was the script last successful; and how long did it take to run".
Which is achieved via SQL on the prod database.

It seems it would be most useful to avoid this manual step, and have this information pre-provided in the initial report.

eg https://pastebin.canonical.com/38362/ for a current error.
Suggest that the columns needed are: hostname, date_started, date_completed and time taken (for the math challenged).
A limit of 5 or 10 should generally be enough information to get a feel for previous runs and establish a level of "what is normal".

[Gary Poster (gary)]

Thanks to Diogo, here's some background to the request.

Steve is probably talking about the emails with the subjects like "Scripts failed to run: ..."

These emails are generated by scripts/script-monitor.py (and maybe scripts/script-monitor-nagios.py is related?)

Sounds like a good idea.