Top Requester based on Request
This report is used to get the top 10 requesters count based on the request.
To make any changes to a query, refer to the KB article below.
SELECT aau.FIRST_NAME "Requester",
count(wo.workorderid) "Count" FROM WorkOrder wo
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
GROUP BY aau.first_name
ORDER BY 2 DESC
Note : Login to ServiceDesk Plus, go to Reports tab > New Query Report > Copy the query to the query editor and run the report.