KACE Product Support

I'm looking to build a patching report in SMA 10.0 that will yield me the following information. The report should be able to list out devices in a specific patch schedule, and per device, what patches are scheduled to be deployed. Including the status of whether or not the patch was successfully installed or ran into an error would be even better but it's not a necessity.

My knowledge of SQL is not very strong and KACE Support says this would be a professional services case for them so I'm just looking to see if anyone was doing something similar or had some thoughts here. I didn't see much in the pre-created reports on the SMA that would get me close to this.

Thank you all as always.