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';