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 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.
New to ADSelfService Plus?
Related Articles
How to populate requester details in request additional field
Requirement: Populate requester additional field information into request additional field. Usecase: Let us consider a scenario where certain employee details are imported from the Active Directory into User - Additional Fields. The business ...How to send periodic notifications to requester(s) about their pending requests and accordingly update their status.
This post describes the use of a python script to notify requester(s) about their requests through email and move those to a specific status. Use Case: Let us assume a scenario where the technicians reply to a request and put it in a custom status ...How to update a request based on certain field values.
This post describes the use of a python script to update requests based on values in other fields ,in the same request.This action can be performed using Custom Triggers. UseCase: There are three Levels setup in the application and there are 2 ...How to update a request based on certain values.
This post describes the use of a python script to update requests based on values given in the request_properties.json file. This action can be performed using Custom Triggers. UseCase: We have a Service template for account lockout/password reset. ...Update Requester from Request Description
Usecase: When a request is submitted on behalf of a user via email, the request description includes the requester's full name. This must be parsed in order to update the ticket requester. Steps to follow: Goto Admin > Request Custom Functions > ...