I have seen a couple of questions recently on reporting on system tables. Though, it is not recommended by ServiceNow, there is a way to achieve it. The reason for this is system tables are typically largest tables in any instance. The result of querying such a big file may result in slowness of instance or even become unavailable.
Please follow below steps to report on system tables:
1) Go to System Properties or type sys_properties.list in the Application Navigator
2) Search for the property name 'glide.ui.permitted_tables'
3) Open this record for editing and the 'Value' field in the record signifies the system tables that are available for reporting
4) You will have to add the table name(on which you have to report) and save the System property record
5) Then, elevate your role as 'security_admin'
6) Open the Access Control List(ACL) and create a new record
7) Select the Operation as 'report_on' and table name as the name of the table you added in step 4 (in my case sys_user_grmember). Select the role if you want any specific role to access the report else everyone will be able to report on this table
๐ Go to report, create a new report with the system table you added in the system property and bingo, you will be able to create a report on that system table.
Please mark this article helpful if it helped you or bookmark it for your future reference.
Cheers,
Hardit Singh
