Query to display additional field associations with templates

Query to display additional field associations with templates

Use case

The reports shows in which templates the created additional fields are associated 


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 and fc.field_name='udf_sline_901'
order by 1

Go to Admin >> Service Catalog - Additional Fields/Incident - Additional Fields >> Note the API name for the additional field and replace it with the highlighted text in the query

Filter: None

Sample Table

        New to ADManager Plus?

          New to ADSelfService Plus?

            • Related Articles

            • Script to Populate User Additional Field under Incident Template using FAFR

              The script load the Requester Name under Incident Additional field ( As a pick list), by choosing the requester name under additional field the script populates the user additional field value. * Kindly create two additional fields under Admin -> ...
            • Query to find the time taken to assign a field

              Use case The query will pull a report of when an additional field was first assigned a value DB: MSSQL Query  Please replace additional field name with the Field Name Here. SELECT "wo"."WORKORDERID" AS "Request ID",  "ad"."ORG_NAME" AS "Account",  ...
            • Query to show account additional fields _ Details required

              We Need to know whether that is a common account additional fields or add attribute under individual account. So please send us the following screenshots. 1. Admin-> Account additional fields list view page. 2. Accounts->Edit account and show the ...
            • Query to fetch the fields in the templates

              The query fetches all the fields with display name used across Request templates PQSQL: select Distinct (CASE when fc.field_name like 'udf_%' then ca.aliasname else fc.field_name END) "Fields", rt.templatename "Template name" , sd.name "Service ...
            • Query to show difference between current and previous value of a Date additional field

              MSSQL: SELECT "wo"."WORKORDERID" AS "Request ID",  "mdd"."MODENAME" AS "Request Mode",   "qd"."QUEUENAME" AS "Group",   "aau"."FIRST_NAME" AS "Requester",   "cd"."CATEGORYNAME" AS "Category",   "scd"."NAME" AS "Subcategory",   "wo"."TITLE" AS ...