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
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 : ...How to create service requests through email using Business Rule
Note: Template can be modified directly using BR from build 11.3 This post describes the use of a python script to create a service request through email based on keywords in the subject. When a request is created with specific keywords in the ...Email Commands Not working when Mail is sent from user to Application through a Technician Mailbox by Autoforwarding
Issue : Email Command expected to behave such that email command parameters specified only in the latest message is considered for Request Creation Previously before 14001, Email command utilizes whole message content instead of only latest message ...Disabling Email Notifications when new request creation via mail is restricted
Issue When new request creation through mail is restricted a email notification will be sent to the requester as below. We does not have option to disable this email notification. Fix Apply the attached fix jar to disable the notification. Note ...Zia Approval / Request Reopen prediction fails due to the presence of Email Classification Headers
Issue: Zia Approval / Request Reopen prediction fails when the reply mails have Email Classification Header contents in it. Disclaimer: For eliminating Email Classification Headers while processing approval / reopen reply mails for Zia prediction, we ...