QEHNick
-
Posts
402 -
Joined
-
Last visited
-
Days Won
4
Recent Profile Visitors
589 profile views
QEHNick's Achievements
-
For those who may have missed it, the banner ad was inserted into the top section of the employee portal. What's next? Adverts for "Go Pro"?
-
Really Hornbill? Is this absolutely necessary? It makes the product look tawdry and cheap. I get it, you want to engage with us, but there are more professional ways of doing this.
-
Yeah, my desk is somewhat littered with paperwork at the moment, it was probably resting on the keyboard.
-
Hahhaha, love that movie.
-
So this is odd, I just had this appear on my login screen. Never seen it before. The even stranger thing is, when I refreshed the browser window - it vanished!
-
Weirdly, removing it made the figures go way high! More than the number of emails we had in. I'll keep it in...
-
Ah that would make some sense. Cheers @Met, I'll remove that statement as it's not relevant.
-
Ok, after much fiddling about I have used the following. For Internal emails - h_msg_rfc822_hdr NOT LIKE '%Return-path% %@OUR_DOMAIN_NAME%' AND h_msg_status = 1 For Internal emails - h_msg_rfc822_hdr LIKE '%Return-path% %@OUR_DOMAIN_NAME%' AND h_msg_status = 1 Since there is no column entry for sender domain I have to look through the HDR content to find the necessary info to filter on. So far, the output compares to the emails in the Inbox (and other) folders.
-
Yeah I think it's h_msg_status code "1" for received.
-
Ah, good point @Steve Giller. I'm just looking at the mailbox. What would I need to use there then? One of the h_msg_status codes?
-
@Steve Giller yeah, I narrowed it down to the actual domain ('%@domainname.co.uk') however it's producing ridiculously high figures now. We have never had 100+ emails in a week. So I tried replacing "LIKE" for "=" and "NOT LIKE" for "<>"; this then tells me we had over 4000 emails from external sources and zero from internal in a month. That's nowhere near reality.
-
@Steve Giller Yeah, I can't find a row which would have what I need to determine it. Ah! I suppose if h_msg_from had sender address which had "somethingsomething@DOMAIN.com", that would be my external since internals do not show the email address, just the senders name. So something like... h_msg_from NOT LIKE '%@%' for internal emails?
-
Hello, I'm trying to put together some "measures" to record how many emails come through the mailbox from INTERNAL and EXTERNAL sources. I've tried several different ways, most recently..... ...using a "Query where clause" in this vein. h_msg_rfc822_hdr LIKE '%From%OURDOMAINNAME%' ..or.. h_msg_rfc822_hdr NOT LIKE '%From%OURDOMAINNAME%' The results are incorrect, too low to match what is actually coming through. Does anyone have a way of doing this?
-
Bingpot! That's exactly what it is.
-
I discovered it was easier to simply report on those which did not have the "@" symbol in the "From" field, those internally received emails were showing the "From" field contents as Surname, Forename. Thank you all.
