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
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 ...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 ...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 ...Technician notification based on the site
This KB will help you to get the notification about based on the site to a technician. Please follow the below instructions. Please navigate to Admin >> Request timer action >> Add new timer action. Please configure the below in the application. ...