User email count

[tghadage124]

Hi guys , 

I have requirement where I need a count for all the email sent to user Abraham Lincoln , can I use Fix script for this.

please guide !

Thanks!!

[Robbie]

Hi @tghadage124,

No Fix Script needed here. You can simply view (and report on) to the 'sys_email' table by typing 'Emails' into the Navigation menu found under 'System Logs'.

Change the filter as required - for example the date range such as sent this year or this week etc and update the Recipient to reflect the name(s) required.

See below example for Abel Tuter (abel.tuter@example.com) but you can adjust accordingly.

You'll notice the Type field shows 'send-ready' as this is a screen shot from my PDI. In your customer/org instance, make sure the type is set to 'sent'.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie

[tghadage124]

Hi @Robbie , 

Actually I need to know every time as new email bounce in for the that one user  if it works well then I need to know for particular group of users. how many mail has been sent and received for those users.

thanks!!

[Robbie]

Hi @tghadage124,

If you want to check to see if an email has 'bounced' - based on the assumption the 'bounced email' sends a reply, you'll need to run a similar report on the same table ('sys_email'), however checking where the type is 'received-ignored'

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie

[Mark Manders]

Is this just a one time thing that you need to know this, or a recurring one? 

You can query on the 'sys_email' table with an encoded query of 'mailbox=sent^recipientsLIKEabraham.lincoln@example.com'. You can do a count on that.