Report for Notifications table

[SR2]

Hello everyone,

I have a small doubt.

we need an report on notification(sysevent_email_action) table to show all the notifications which are created in 2022.

When I try to select the table name from data in report, the table name is not visible.

Can we create a report on Notifications table, if yes, how can we create it. 

can you please help me with this.

Thankyou.

[Saranya K]

Hi @SR2 ,

Yes we can't able to create the report for system table, table starts with 'sys'.

Please find link below:

https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/concept/c_ReportO...

If I answered the question please mark helpful.

Thanks,

[SatyakiBose · Accepted solution]

Hello @SR2 

You need to perform the below steps to be able to report on the sysevent_email_action table.

1. Navigate to the system property - glide.ui.permitted_tables
2. In the value field, you need to add the table name.
3. Now navigate to the sysevent_email_action.list
4. Here right click on the list header and you would see 2 reporting options:
   • Bar Chart
   • Pie Chat
5. You can select either of these options and configure your report.

However, if you try to create a report from the reporting module from scratch, you will not be able to see the table.

You will have to go via the .list and then run your report.

[SR2]

Thanks @SatyakiBose and @Saranya K for your immediate response.

helped me a lot.