I manage over 50 automatic patch deployment tasks, each with varying success and failure statuses. I've noticed that some machines have failures associated with multiple tasks. To streamline troubleshooting, I need a report that lists all machines with a "Failed" deployment status, aggregated across all tasks.

This would be especially helpful because any failed deployment typically requires manual intervention on the affected machine. Having a comprehensive list of failed machines along with the specific tasks that failed on each one would allow me to address all issues on a machine at once, rather than piecemeal.