Hello I am trying to see a turn around time from when an email is received to when we reply on it. When I pull the MS outlook exchange data, I see when the email is sent, recieved, but I do not see a date of (if we replied on it). I tried to look by id column but didn't find any relationship between the emails. Any other thoughts?
Solved! Go to Solution.
@jcastr02 - I think you would need to duplicate the original 'Mail' table and then filter the result to ([Folder Path] = "\Sent Items\").
Then you can Merge both tables where you join 'Mail Sent' with 'Mail' on [Id].
Proud to be a Super User!
@ChrisMendoza Thanks that helps - do you know where the actual Sent time would be captured for that email?
@jcastr02 - I was wrong, sorry I didn't test a little more thoroughly. This is actually not as easy as I had thought. You'll actually need to expand [Attributes] to get to [InternetMessageId]. Also in [Attributes] is [InReplyTo] which I'm sure you'll find useful. I chose this sample to show how difficult this may become:
Here are teh queries and the join:
Proud to be a Super User!
Thanks @ChrisMendoza it looks though as the reply email has the same sent/received date/time as the original email. I am looking for the time the email was replied to (sent back). Any ideas?
@jcastr02 - I don't understand what you mean? In this sample, the incoming mail was sent 3/25 and the reply was 3/27.
Proud to be a Super User!
User | Count |
---|---|
142 | |
85 | |
63 | |
63 | |
55 |
User | Count |
---|---|
210 | |
108 | |
88 | |
75 | |
70 |