Need help on reporting on a system table (sys_email_log)

[mjl]

On my admin account, I have a personal filter on System Logs - Emails set up to show me inbound emails that don't get HR cases created for them:

• Created On: yesterday
• Type: received-ignored
• To: hr@acme.co.uk

This works fine, showing me spam/autoreplies/etc that get ignored (and also those people legitimately emailing in but whose SN user accounts are marked as "inactive"). But what I'd like to do is have the equivalent as a report run early morning and going to key Team Members so that legitimate cases don't slip through any gaps.

HOWEVER, after making making the sys_email_log successfully available for reporting in the UI Properties - Reporting on System Tables (ServiceNow docs) - I can't see all the field contents in my report:

Can anyone offer any assistance on this?

[AbhishekGardade]

I guess, You have scheduled a report daily morning. Make sure that you will run report as Admin Account,

EDIT:

I have created and scheduled a report on emails table. I got the expected result. email sent to users with all COLUMN Data available.

Check if any ACL is making any impact on it.
Please mark as Correct Answer/Helpful, if applicable.
Thanks!
Abhishek Gardade

[AbhishekGardade]

Check out this:

[AbhishekGardade]

Any updates on this?

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you, Abhishek

[mjl]

Sorry, no - this isn't my issue.