Custom Report Generation Query Help

Hello everyone.

I want to generate two custom reports, all about Remediation Plan.

1- The first report will have to be grouped by the [Remediation Solution and the hosts that requires such a solution] since the normal Remediation Plan report groups them by host, I will have multiple duplicate solutions. If I can make such custom report I will remove any duplicated solutions.

2- The Second report, i want to do it the same as the one before but with the ability to exclude any solution that has the terms [ Upgrade or Update ]. Basically I wan to exclude solutions that are related to an App or OS old versions that requires updates.

Am not sure how I can create these types of report or if its even possible. Any insight on this is much apperciated.

Thank you