Create report based on sys_report_users_groups table

[Danielle25]

We are trying to do an audit on report access and I've found that the best table to use is sys_report_users_groups . The only issue with this is that the table visibility is only available for admins. We were able to create a database view joining sys_report and sys_report_users_groups so that we can create a report on these tables; however, users who are not admins cannot access the report or the database view.

Any suggestions on how to make this accessible? Would this require a new ACL?

We really would only need admins and report_admins to have access to this database view.

Thanks!

[Prateek kumar · Accepted solution]

You can add report_admin role in the role section of ACL.

And forgot to mention in my earlier post, since sys_report_users_groups is a system table you won't be able to find it in the dropdown table selection.

Follow the below doc to add this table available for reporting.

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/co...

[Adam Stout]

This is a better approach than a view that is just bypassing this restriction.