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 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 ...