Reports on system tables

[msm4]

Hello,

Can we create reports on system tables like user preference table?.. I didnt find the table for creating the report.

It is possible to pull a report?

Thanks,

msm

[Ali Shaikh1]

Hi msm,

By default you are not permitted to create reports on system tables, but still if you do want to do that there there is a property where you will have to add the system table name and then you will be able to report on this table.

Property Name: glide.ui.permitted_tables

I am sure you have analyzed the risks of creating reports on these tables as it has the potential to harm the performance drastically.

Kindly mark the answer Correct and Helpful if this answers your question.

Thanks,

Ali.

[Mark Roethof · Accepted solution]

Hi there,

Navigate to:
System Properties > UI Properties.

On the System Properties page shown, search for "List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable."

Add your table here > "sys_user_preference".

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[msm4]

Thank you 🙂

[Jaspal Singh]

Hi,

Reporting on system table is permitted. You may follow link incase if it is to be used for reporting.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.