Hi,

I was given the below query to pull Requester details off the system:

SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", SDOrganization.NAME "Site", AaaContactInfo.LANDLINE "Phone", SDUser.JOBTITLE "JobTitle", AaaContactInfo.MOBILE "Mobile" FROM AaaUser AaaUser LEFT JOIN UserDepartment UserDepartment ON AaaUser.USER_ID = UserDepartment.USERID LEFT JOIN AaaUserContactInfo AaaUserContactInfo ON AaaUser.USER_ID = AaaUserContactInfo.USER_ID LEFT JOIN AaaContactInfo AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID = AaaContactInfo.CONTACTINFO_ID LEFT JOIN DepartmentDefinition DepartmentDefinition ON UserDepartment.DEPTID = DepartmentDefinition.DEPTID LEFT JOIN SiteDefinition SiteDefinition ON DepartmentDefinition.SITEID = SiteDefinition.SITEID LEFT JOIN SDOrganization SDOrganization ON SiteDefinition.SITEID = SDOrganization.ORG_ID INNER JOIN SDUser SDUser ON AaaUser.USER_ID = SDUser.USERID LEFT JOIN portaltechnicians HelpDeskCrew ON SDUser.USERID = HelpDeskCrew.userid LEFT JOIN AaaLogin AaaLogin ON AaaUser.USER_ID = AaaLogin.USER_ID WHERE ((HelpDeskCrew.userid IS NULL) AND (SDUser.STATUS = 'ACTIVE')) 

However this no longer works since we've moved to ESM, please can I get an updated version to work with ESM setup?

Many thanks

Lisa

SQL