Jump to content

QEHNick

Hornbill Users
 View Profile  See their activity

  • Posts

    402

  • Joined

  • Last visited

  • Days Won

    4

 Content Type 

Everything posted by QEHNick

  1. QEHNick
    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"?
  2. QEHNick
    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.
  3. QEHNick
    Yeah, my desk is somewhat littered with paperwork at the moment, it was probably resting on the keyboard.
  4. QEHNick
    Hahhaha, love that movie.
  5. QEHNick
    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!
  6. QEHNick
    Weirdly, removing it made the figures go way high! More than the number of emails we had in. I'll keep it in...
  7. QEHNick
    Ah that would make some sense. Cheers @Met, I'll remove that statement as it's not relevant.
  8. QEHNick
    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.
  9. QEHNick
    Yeah I think it's h_msg_status code "1" for received.
  10. QEHNick
    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?
  11. QEHNick
    @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.
  12. QEHNick
    @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?
  13. QEHNick
    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?
  14. QEHNick
    Bingpot! That's exactly what it is.
  15. QEHNick
    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.
  16. QEHNick
    So when I say emails received by our local users, I mean to say those sent to us FROM those users....
  17. QEHNick
    If it helps, the "From" content appears to be the persons surname a comma then a space and their first name. Perhaps some statement to match that against h_sys_accounts? h_sys_accounts.surname & ", " & h_sys_accounts.firstname Tried this, no joy.. Will keep fiddling.
  18. QEHNick
    I'd like to create a report which shows emails received by our local customers (those which are "Basic" users in SM). Which tables etc do I need to link together to make that happen? Many thanks everyone.
  19. QEHNick
    My apologies, I'm in the inbox. Creating a response template from the compose section.
  20. QEHNick
    Good day everyone, Is there a reason why I do not see all of my "groups" in the "Add To: section of templates when creating or editing a new email template? I see 9 out of 23 possibilities.
  21. QEHNick
    Your image shows it being associated with SSO profiles, indeed, SSO Profiles falls under "Security" and there's nothing much there to do with Audit. And when you attempt to go to it via the link you have shown, "Oops this page could not be loaded correctly".
  22. QEHNick
    I wonder if this has been replaced by "Sessions"? Platform Configuration -> "Monitor" -> Sessions The wiki for is is a little dry...
  23. QEHNick
    +1 I'd add more if I could as this is a feature (printing) we would utilise if we could.
  24. QEHNick
    Here you go. changeprocess.draft.bpm.txt chg-capture.pcf.txt
  25. QEHNick
    +1
×
×
  • Create New...