Request recipient email

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. 




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. 

          • Related Articles

          • How to create service requests through email using Business Rule

            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 subject of a incoming mail , the Business Rule will be invoked. The ...
          • How to create service requests through email

            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 subject of a incoming mail , the custom trigger will be invoked.The ...
          • Debug jar for Formatting issue in request while processing via email

            Debug jar for finding the actual root cause for the formatting issue in requests created via Mail. Added debug log prints to troubleshoot the issue Reference Ticket:  ...
          • How to send custom email notifications from a request with a configurable XML file.

            This sample python script is used for sending custom notifications from ServiceDesk Plus when a criteria  is met.You all know that ServiceDesk Plus has notification rules and customizable templates to notify requesters, technicians, and other stake ...
          • Service request approvers

             This report helps to find the who all the service request approvers in the application.  SELECT aaauser.first_name "Approver Name", dpt.deptname "Department", sdo.name "Site", sd.jobtitle "Job Title" FROM srapproverdetails LEFT JOIN aaauser ON ...