Report to get list of Requesters with Requester created time and created by

Report to get list of Requesters with Requester created time and created by

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 ADManager Plus?

          New to ADSelfService Plus?

            • Related Articles

            • Query to show technician created time

              PGSQL & MSSQL: SELECT AaaUser.FIRST_NAME "Technician Name", aci.emailid "Email ID", LONGTODATE(AaaUser.createdtime)  "Technician Created Time", SDUSER.STATUS "Status(Active/Inactive)" FROM AaaUser left JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID ...
            • Query to list the custom and query reports and the technician created

              Use case The query displays the custom reports and query reports saved by technicians. Query SELECT custrepdet.report_name "Report Name",               au.first_name"Created By" from customreportquery custrep LEFT JOIN customreport_details custrepdet ...
            • API -Listing Account Specific Requesters

              1. Encode (Used for GET calls alone) the below values thereby replacing the Account Name as per yours : { "operation":{ "details":{ "accountname": "Sample Account", "sitename": "0" } } } 2. The site name value is set as "0", which will list the ...
            • Query to find the time taken to assign a field

              Use case The query will pull a report of when an additional field was first assigned a value DB: MSSQL Query  Please replace additional field name with the Field Name Here. SELECT "wo"."WORKORDERID" AS "Request ID",  "ad"."ORG_NAME" AS "Account",  ...
            • Query to find out who created Accounts (MSSQL & PGSQL)

              Tested in build PGSQL (14300) and MSSQL (14306) Execute the below queries under Reports->New Query Report. select org_id, org_name from accountdefinition ad where ad.org_name in('Requester Name', 'Palanivel Palras','Muhammad Nadeem Khan') Note down ...