Building reports - All WI by Support Group

I tried to produce this information by a simple saved search, however the columns are limited. I need the report to include resolution/results and the date it was completed. Can I do this with some SQL in the Analytics section. I had such report written in SQL Server Report Builder on our original Service Manager install but cannot seem to match the tables/views in our new database.