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
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 whom service request approvals are sent and how does it works.
There is a settings in Admin-Self Service Portal Settings to choose restriction type while sending request approval emails. Lets see in detail how it works: SSP configuration "Choose restriction type to be made while sending Request approval mails" ...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_UserList and custom triggers - Deluge
This is a sample script written in Deluge to handle Conditional Approvals for Incident \ Service Requests, through Custom Triggers using Field and Form Rules. One of the advantages of using this script that no modification in the script is required ...