Report to get list of Requesters with Requester created time and created by (MSSQL & PGSQL)

Report to get list of Requesters with Requester created time and created by (MSSQL & PGSQL)


Tested in builds from PGSQL (14300) or MSSQL (14306)


Kindly execute the report under Report -> New Query Report. 

SELECT AaaUser.FIRST_NAME "FullName",
AaaLogin.NAME "LoginName", 
longtodate(aaauser.createdtime) "Created time",  
AaaContactInfo.EMAILID "Email", 
DepartmentDefinition.DEPTNAME "Department", 
SDOrganization.NAME "Site", 
aaau .FIRST_NAME "Created by" FROM AaaUser  
LEFT JOIN Portaltechnicians pt on pt.userid=aaauser.user_id
LEFT JOIN UserDepartment ON AaaUser.USER_ID=UserDepartment.USERID  
LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID  
LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID  
LEFT JOIN DepartmentDefinition ON UserDepartment.DEPTID=DepartmentDefinition.DEPTID  
LEFT JOIN SiteDefinition ON DepartmentDefinition.SITEID=SiteDefinition.SITEID  
LEFT JOIN SDOrganization ON SiteDefinition.SITEID=SDOrganization.ORG_ID  
LEFT JOIN SDUser ON AaaUser.USER_ID=SDUser.userid
LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID 
LEFT JOIN aaauser aaau on aaau.user_id=sduser.created_by
where pt.userid is null and sduser.status='ACTIVE'

                  New to ADSelfService Plus?