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
Custom script to skip approval if the requester is a VIP user
User based approvals When a requester creates a new request, the system should check if the requester is a VIP (Top Management) user : If the requester is a VIP , then skip approval workflow related to the service ; Else, trigger the approval ...Account specific request template: Redirection to requester's account based template from default template using FAFR
Tested in builds 14000, 14200 and 14201 (Global FAFR): Step 1: In Global FAFR, on form load, configure an FAFR and execute the below script under Action as shown below, try{ $req.form.destroyForm(undefined, false); }catch(err){} ...Account based outgoing mail sever settings post build 14001
ACCOUNT-BASED OUTGOING MAIL SERVER FEATURE: Introduction: Account-based outgoing mail server feature was introduced in build 14001. This feature ensures that users receive notifications and responses from the specific email address associated with ...Import and update Requester from CSV (Comma Separated Value) Files
Import Requester from CSV (Comma Separated Value) Files You can also add requesters by importing from CSV files. To import requesters from CSV file Step 1: Locate the CSV file Click Import from CSV link in the Requester List page. The Import ...Update Requester from Request Description
Use case: When a request is submitted on behalf of a user via email, the request description contains the requester's full name. Script to update the ticket requester accordingly. Tested on builds: 14306,14500. Steps to follow: Go to Admin > Request ...