May I suggest importing these reports, authored by Bryan Dam?
https://damgoodadmin.com/2018/01/24/yet-another-software-update-dashboard/
One of them seems to be close to what you want.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I want a sccm report or query output which has list of all servers which are non-compliant due to failed Office and Visual Studio updates.
Columns should have : Servername | Failed update Title| KB number
May I suggest importing these reports, authored by Bryan Dam?
https://damgoodadmin.com/2018/01/24/yet-another-software-update-dashboard/
One of them seems to be close to what you want.
First off have you looked at the built in reports for this.
Secondly, if you want a custom report, what do you have for a query now and what isn't working with it?