Request recipient email
This report is used to find the recipient email address.
Some requests are forward to others through the mail, this report helps to find the statistics how many requests are forward to others using the email address filter.
To make any changes to a query, refer to the KB article below.
SELECT wo.workorderid "RequestID", wo.title "Subject", wor.to_cc_bcc "Parent Request", wor.recipient_email "Parent request email ", cr.TO_CC_BCC " In conversations", cr.recipient_email "Conversation email", nr.TO_CC_BCC "Sent mails", nr.recipient_email "Sent mail email" FROM workorder wo LEFT JOIN conversation c ON wo.workorderid=c.workorderid LEFT JOIN conversationrecipients cr ON c.conversationid=cr.conversationid LEFT JOIN notify_workorder nw ON nw.workorderid=wo.workorderid LEFT JOIN notification_recipients nr ON nw.notificationid=nr.notificationid LEFT JOIN workorder_recipients wor ON wo.workorderid=wor.workorderid WHERE wo.CREATEDTIME >= <from_lastweek> AND wo.CREATEDTIME <= <to_lastweek> ORDER BY 1
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 flag a request and receive email email notification on every updates of the request.
Requirement : To flag a request and receive email notification on every update of the request. Solution : Add an additional field as 'Flag' with options Yes and No I have split the solution 2 ways 1. Receive notifications when there is an update in ...Email Command Replacement Issue : Replying with 'EditRequest' creates new request
Refernce Ticket : #8115154 Reference Issue : SD-105028 ISSUE : When the user tries to editRequest using email command by replying to the mail received from technician, A new request is added instead of updating the old request. Cause : ...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 ...Custom Script to Trigger an Alert if there is no email address associated with Requester (using FAFR)
Working on Builds: 14500 too Scenario: Request should not be created if there is no email address associated with the requester. Instead it should prompt and alert stating there is no email address associated with the requester. The above requirement ...Restrict Ticket creation from external email sender- Unknown Users
To parse the email from external email address. Follow the below configuration. We have to enable this option to accept "unknown email" (not setup on the system), under Admin > Self-service Portal. Also, select the below option as per your ...