Top Requester based on Request

Top Requester based on Request

This report is used to get the top 10 requesters count based on the request.


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
WHERE (wo.ISPARENT='1')
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.