I need a query that I can run that will provide me the list of template names, active and disabled, with the template description. That is all, I have 5 instances with over 500 templates and we're trying to audit them and I have no way to just export a list of the templates for each portal built into the GUI.

I have tried the few suggestions from these forums and none of them show all of the templates.