Query to list fields used in each request template.

Query to list fields used in each request template.

Go to Reports-New Query Report and execute this query.

POSTGRES

select sd.name "Service Catalog Name",rt.templatename "Template name",fc.field_name "Fields" from requesttemplate_list rt
left join servicedefinition sd on sd.serviceid = rt.parent_service
left join form_customizer fc on fc.form_name = ('WorkOrder_' || rt.templatename)  order by 1,2


MSSQL

select sd.name "Service Catalog Name",rt.templatename "Template name",fc.field_name "Fields" from requesttemplate_list rt left join servicedefinition sd on sd.serviceid = rt.parent_service left join form_customizer fc on fc.form_name = ('WorkOrder_' + rt.templatename) where  fc.index_tech >= 0 
order by 1

      New to ADSelfService Plus?

        Resources