why some table can not selected in report? (london)

[Wu Weikai1]

I want create a report to show "skiped upgrade history", but the table "Upgrade Details"( sys_upgrade_history_log) is not a choice in report. And I find the table which can select in report is different form which in sys_db_object.

report choice:

table in sys_db_object:

I want select the table "Upgrade Details" in report.

Can any one tell me how to do?

[The SN Nerd]

The process I have shown you will work for most tables in ServiceNow.

In this instance, there appears to be something at a system level preventing you from reporting on this table. I have not been able to get this to work either.

You will need to log a ticket with the ServiceNow via the HI portal for a resolution.
They may say that reporting on this table is not supported.

As a workaround, navigate to nav_to.do?uri=%2Fsys_upgrade_history_log_list.do in your instance and filter as desired. Export your desired list to Excel.

[Wu Weikai1]

Thank you for your advice!

[Community Alums · Accepted solution]

Hi Wu,

Some of the system tables are not opened for reporting.

You will have follow 2 steps:

1) Firstly, open the system properties and search for 'glide.ui.permitted_tables' property and then remove your table from the list.

2) Secondly, create an ACL with operation as 'report_on'.

These are system table so proceed carefully.

https://docs.servicenow.com/bundle/geneva-performance-analytics-and-reporting/page/administer/report_administration/concept/c_ReportOnSystemTables.html

Let me know in case of any issues.

Cheers,

Hardit Singh

[Wu Weikai1]

Hi Hardit,

Thank you for your answer!

After set property 'glide.ui.permitted_tables', the table "sys_upgrade_history_log" can selected in report.

Thank you very much!