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
Set Backup Approvers using Request
This is a sample script that triggers BackUp Approver API, using request information. Use Case: Different users are provided for each role in many organisations. ...
How to create service requests through email
This post describes the use of a python script to create a service request through email , based on keywords in the subject.When a request is created with specific keywords in the subject of a incoming mail , the custom trigger will be invoked.The ...
How to create service requests through email using Business Rule
Note: Template can be modified directly using BR from build 11.3 This post describes the use of a python script to create a service request through email based on keywords in the subject. When a request is created with specific keywords in the ...
Automatically close request after successive approval reminders.
This post describes the use of a python script to close requests after successive approval reminders using Custom Schedules. Use Case: We have an option under the self-service portal in order to send reminders mail for the approvals, what would be ...
How to update a request based on certain field values.
This post describes the use of a python script to update requests based on values in other fields ,in the same request.This action can be performed using Custom Triggers. UseCase: There are three Levels setup in the application and there are 2 ...