Straightforward report that shows the last time a node tried to backup and its failure message. I also included the vendor and machine type so you can see at a glance if a particular model is causing issues.
Due to our environment being large (in excess of 10K nodes) and covering multiple clients I have also done a JOIN to Orion.NodesCustomProperties so that we can pull in the Client and Client_Site custom properties. We then sort by client and client site. As you will likely not have these then simply remove, comment out, or change to one of your own.
You will also need to edit the ORDER BY(s) to suit.