I have the following query that lists all Incident Templates we've created.
SELECT rtl.Templatename "Template Name", rtf.Resolution "Default Resolution" FROM RequestTemplate_list rtl
LEFT JOIN RequestTemplate_Fields rtf ON rtl.TEMPLATEID=rtf.TEMPLATEID
ORDER BY 1
However, some of these are inactive. Is there a way of filtering these out, or at least showing "active" or "inactive" next to each one?
Database: MSSQL
Version and Build: 9.2 Build 9221