Ok, this is really something I don't quite know how to do.

My boss wants a report daily that has the name of nodes that failed on their
last backup attempt, and and the last time they has a successful completion
(or when the first started failing).

And, for those that failed last in their previous backup attempt, but were
successful on the latest backup, when did they first fail (in a row) and
when were they successful finally.

Of course I want to automate it so I don't want to pass any parameters and I
will be running it as a saved query (administrative script) from the command
line, so I can pipe the output to a mail client.

What I have is what failed during the last night, but this is beyond my SQL
basis.