Show Active Templates only

Show Active Templates only

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

                  New to ADSelfService Plus?