Reporting on emails sent by technician?

Reporting on emails sent by technician?

I have built a report to provide a listing of notes added to requests in the past 7 days, but have identified a gap where emails sent via the system are not recorded. How can I report on emails a given technician sends?

Incase it helps anyone else, here is the query Ive constructed to pull down the work notes:
  1. SELECT wo.WORKORDERID "Request ID",aaauser.first_name "Note Added By",  note.NOTESTEXT "Notes", longtodate(notesdate) "Note Added date",  std.STATUSNAME "Request Status", sdo.NAME "Site", qd.QUEUENAME "Group", longtodate(wo.COMPLETEDTIME) "Completed", longtodate(wos.LAST_TECH_UPDATE) "Last Update" FROM WorkOrder wo
  2. LEFT JOIN Notes note ON wo.WORKORDERID=note.WORKORDERID
  3. LEFT JOIN aaauser ON note.userid=aaauser.user_id
  4. LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
  5. LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
  6. LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
  7. LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
  8. LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID
  9. LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID

  10. WHERE dateadd(s, datediff(s, GETUTCDATE(), getdate()) + (wos.LAST_TECH_UPDATE/1000), '1970-01-01 00:00:00') >= DATEADD(day, DATEDIFF(day, 0, GETDATE())-7, 0) 
  11. AND dateadd(s, datediff(s, GETUTCDATE(), getdate()) + (notesdate/1000), '1970-01-01 00:00:00') >= DATEADD(day, DATEDIFF(day, 0, GETDATE())-7, 0) 
  12. Order By 2 DESC

                New to ADSelfService Plus?