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?

[shloke04]

Then what is the issue. Can you explain in detail?

Regards,

Shloke

[shloke04]

Hi,

This is because even after givin the required access for sys_email table, users should be able to have access for the Target table as well. Say for example an email Notification got trigger for HR record so the user should have access to HR table also in order for the report to be displayed correctly .

And as suggested by abhishek above, you can go ahead and create a Scheduled report and shoudl solve your query.

Hope this help. Please mark the answer as helpful/correct based on impact.

Regards,

Shloke

[mjl]

My issue is that whilst I can select fields for reporting that display contents in the list as visible in System Logs - Emails, the values of those fields (To and Type) do not display in the report (as seen in the screenshot).

At present, I am still developing the report using my Admin account, so scheduling the report to run as a certain user is not relevant at this point.

I need to know why the contents of those fields aren't visible within reporting when they are visible in the table, and resolve it.

[shloke04]

Hi,

If your query is resolved, kindly mark the answer as correct and close the thread.

Regards,

Shloke

[The SN Nerd · Accepted solution]

There must have been some configuration done to your system for this to happen, as I am not seeing this behaviour with scoped tables and sys_email_log in my system. Making sure there is a report_on for sys_email should solve this as others have mentioned.

I don't think you even need sys_email_log for this, sys_email table would do just fine.