Jump to content

QEHNick

Hornbill Users
 View Profile  See their activity

  • Posts

    402

  • Joined

  • Last visited

  • Days Won

    4

 Content Type 

Posts posted by QEHNick

    Passcode Login???

    in Employee Portal

    Posted

    On 6/13/2023 at 1:14 PM, Gerry said:

    @QEHNick

    As mentioned above, if you provide our support team with a passcode to access your system to aid with a support issue, this is the button they will use to enter the passcode you provided.  By default this button is not visible because its not very useful to users generally - but, you can make it appear when you are on the login screen by pressing the SHIFT key.  I expect you did that accidentally which made the button appear. 

    Gerry

    Yeah, my desk is somewhat littered with paperwork at the moment, it was probably resting on the keyboard.

    • Like 1

    Messages Measures (Inbox)

    in Reporting

    Posted

    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.

    Messages Measures (Inbox)

    in Reporting

    Posted

    @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.

    Messages Measures (Inbox)

    in Reporting

    Posted

    @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?

    Messages Measures (Inbox)

    in Reporting

    Posted

    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.....

    image.png.68411b6400a529791d380c1b30479946.png

    ...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?

    Reporting on Emails

    in Service Manager

    Posted

    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.

    Reporting on Emails

    in Service Manager

    Posted

    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.

    Reporting on Emails

    in Service Manager

    Posted

    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.

×
×
  • Create New...