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,

Create Report on System Table.

Please go through this you can able to create reports on system table.

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

Thanks,

Ali.

[Chuck Tomasi]

Another trick is to just go to the system table (example: sys_user), and use the column menu to start making a pie or bar chart, then continue from there.

[Ishita Shrivast]

Hi there,

System tables are, by default, restricted from the Reporting module.The reason for this is because sys_audit is typically the largest table in any instance. It is not unusual for the audit table, in even a mid-sized instance, to be several gigabytes. In a large installation, this table can be 50GB or more.

If you must report on a system table, you can add it to the glide.ui.permitted_tables property. Navigate to System Properties > UI Properties and locate the property labeled List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable.

If my answer was helpful, then please mark it as helpful and correct.

Thanks and regards,

Ishita Shrivastava

[Hemant Goldar]

hi 

Please follow the link https://docs.servicenow.com/bundle/madrid-performance-analytics-and-reporting/page/use/reporting/con... its all about how to add report on System table.

Thanks and Regards,

Hemant