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'