Requester Details
Use the query below to generate the report, to list the requester details in ServiceDesk Plus.
SELECT AaaUser.FIRST_NAME "User NAme",AaaContactInfo.EMAILID "Email", AaaContactInfo.LANDLINE "Phone", SDUser.EMPLOYEEID "Employee ID",SDUser.JOBTITLE "Job Title",AaaLogin.NAME "Login Name", dept.DEPTNAME "Department", sdo.NAME "Site",AaaLogin.DOMAINNAME "Domain Name" FROM AaaUser INNER JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID LEFT JOIN UserDepartment udept On SDUser.USERID=udept.USERID LEFT JOIN DepartmentDefinition dept ON udept.DEPTID=dept.DEPTID LEFT JOIN SDOrganization sdo ON dept.SITEID=sdo.ORG_ID WHERE SDUser.STATUS='ACTIVE' AND AaaUser.USER_ID not in (Select TechnicianID from HelpDeskCrew)
ORDER BY 1
Regards,
Stephen
SELECT AaaUser.FIRST_NAME "User NAme",AaaContactInfo.EMAILID "Email", AaaContactInfo.LANDLINE "Phone", SDUser.EMPLOYEEID "Employee ID",SDUser.JOBTITLE "Job Title",AaaLogin.NAME "Login Name", dept.DEPTNAME "Department", sdo.NAME "Site",AaaLogin.DOMAINNAME "Domain Name" FROM AaaUser INNER JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID LEFT JOIN UserDepartment udept On SDUser.USERID=udept.USERID LEFT JOIN DepartmentDefinition dept ON udept.DEPTID=dept.DEPTID LEFT JOIN SDOrganization sdo ON dept.SITEID=sdo.ORG_ID WHERE SDUser.STATUS='ACTIVE' AND AaaUser.USER_ID not in (Select TechnicianID from HelpDeskCrew)
ORDER BY 1
Regards,
Stephen