Need a report with category, subcategory, alert types by support group

Need a report with category, subcategory, alert types by support group

Hi

Need a report with alert types, category, subcategory by support group.

Cant seem to find or make it myself..

I need the report to list all the available cats and sub cats by group but the same as they are on the template

This gets me close but needs group:
  1. select cat.categoryname 'Category', sub.name 'Subcategory' from categorydefinition cat left join subcategorydefinition sub on cat.categoryid=sub.categoryid where cat.isdeleted !=1 and sub.isdeleted !=1 order by 1,2