Service request approvers
This report helps to find the who all the service request approvers in the application.
SELECT aaauser.first_name "Approver Name", dpt.deptname "Department", sdo.name "Site", sd.jobtitle "Job Title" FROM srapproverdetails LEFT JOIN aaauser ON aaauser.user_id = srapproverdetails.approver LEFT JOIN aaacontactinfo ON aaauser.user_id = aaacontactinfo.contactinfo_id LEFT JOIN sduser sd ON aaauser.user_id=sd.userid LEFT JOIN userdepartment ud ON aaauser.user_id=ud.userid LEFT JOIN DepartmentDefinition dpt ON ud.DEPTID=dpt.DEPTID LEFT JOIN SDOrganization sdo ON dpt.SITEID=sdo.ORG_ID WHERE sd.status='Active';
New to ADSelfService Plus?
Related Articles
Query to list Service Request Approver and Purchase Request Approver (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) Select aau.first_name "Name", po.approverstatus "Purchase Request Approver", sr.approverstatus "Service Request Approver", adef.org_name "Account" from aaauser aau left join POApproverDetails po on ...Convert Incident to Service Request
For builds before 10536 The option will be available at: open the respective request > Actions > Convert incident to service request For builds after 10600. Edit the respective request > click on the Template dropdown [top-right corner] > Choose the ...How to implement dynamic request approval using FAFR and custom triggers.
This is a sample script written in Python to handle Conditional Approvals for Incident \ Service Requests, through Custom Triggers using Field and Form Rules. One of the advantages of using this script is that there is no modification of the script ...To make SLA mandatory while creating a service request
The steps mentioned below make the SLA selection mandatory for any service request creation. Tested in builds : 14000 and 14301. Script: if(!jQuery("#servicesla-selected").attr("data-association-id") || ...Set SLA automatically for a service request using FAFR
Note: The below FAFR script will work only on 10600 MSP and above Requirement: Set SLA automatically for a service request depending on the Priority. Usecase: Let us consider a scenario where SLA has to be set depending on the requester's associated ...