Reports | How to limit ALL tables to be reported on and just allow a smaller subset

[George Cutrell]

When our end users go to Reports > Create New, and go to select a table form the Table dropdown, they see ALL tables within the platform.  Our users don't need to see all those tables and we don't really want them creating or attempting to create reports on them as it could lead to unnecessary questions that we'd rather not field.  Basically, we'd like to box the users into just the tables they need to see and have access to for reporting.

The analogy that comes to mind is a firewall.  I want to first deny all but then selectively choose the tables that I want to be reported on.  What is the best way to achieve that?

[Ravi Chandra_K]

Hello @George Cutrell 

Greetings!

OOB report_on ACL precisely does that.

refer below doc which clearly explains about this 

https://docs.servicenow.com/en-US/bundle/vancouver-now-intelligence/page/use/reporting/task/t_Restri...

please mark the answer as correct and helpful if helped!

Kind Regards,

Ravi Chandra.

[George Cutrell]

I was looking at that but am still confused.  Would I need to create a report_on ACL for each table I do NOT want to be allowed for reporting by an end user?  If so, there are a ton of OOTB tables.  

[Ravi Chandra_K]

Hi @George Cutrell 

write ACL on the [sys_report] table controls write access for all reports.

and try giving report on access for few selective tables.

please mark the answer as correct and helpful if helped!

Kind Regards,

Ravi Chandra.

[ersureshbe]

Hi, I doubt most of the time end user will be restricted to use Platform login and allow to login in portal. If end users request the report it should come via support team not direct access to end users. I feel, you should restict the platform feature for end users.