Query to get Template list with fields mapped to it and default values.
Version : 14000
DB : PGSQL
OUTPUT :
select sd.name "Service Catalog Name",rt.templatename "Template name",fc.field_name "Fields",fc.default_value "Field Value" 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)
left join servicedefinition sd on sd.serviceid = rt.parent_service
left join form_customizer fc on fc.form_name = ('WorkOrder_' || rt.templatename)
Topic Participants
abdul samad
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?