Issue with Reports on a Dashbord

terrieb · ‎11-01-2023

Got an incident today from one of our internal staff who have the itil role. For some reason, the ability to see some of the reports on their main dashboard is showing the following message:

Access to the content denied based on report_view ACLs

I looked at all the review view ACL's and find nothing. Any idea why this is happening? It's on more than 1 report on the dashboard and shows others just fine.

Screen shot sent. I, as admin, can see everything.

Thanks

scott barnard1 · ‎11-02-2023

Hi Terrieb

We've had a lot of issues with SN pushing report view acl's on our instance particularly around scoped apps. Agent has full write on the table but the report view acl is blocking visibility on the dashboard.

One of the things to look for is how the report on the dashboard is constructed.

If the report is dot walking through to other tables then you need to check the report view ACL on each table touched.

For example if the report is for incidents that are linked to a service and you are dot walking the service table in your report to get the service name you may be blocked by the service report view acl. If All you are after is the display value of the dot walked records change the condition so it just uses the service and no dot walking is needed.

/nav_to.do?uri=%2Fsys_security_acl_role_list.do%3Fsysparm_clear_stack%3Dtrue gives you the roles by ACL's

You can alter the filter to just show report view ACL's

nav_to.do?uri=%2Fsys_security_acl_role_list.do%3Fsysparm_query%3Dsys_security_acl.operation%3D0997ab83733303005978e4b9cdf6a7b9%26sysparm_first_row%3D1%26sysparm_view%3D

I usually start debugging the issue from here.

Good luck

View solution in original post

Danish Bhairag2 · ‎11-01-2023

Hi @terrieb ,

Please first try to check the report view acls on the table from which the data is being populated. If things are ok on that table (which can be either the report view acl is not present or the relevant roles user already has mentioned in the report view ACL)

You can move on the next time which would be to check the extended table of the current table from where the report is showcased. There definately must be some report view ACLs kindly grant/add the appropriate roles to the user facing the issue in the report view ACL.

Thanks,

Danish

Jaspal Singh · ‎11-01-2023

Hi,

Concept of report_view was made available from San Diego version and it points to limiting reports on table for users. Doc link will help understand in detail.

terrieb · ‎11-02-2023

I understand the difference but how do I locate Table view ACL's? I looked in the System Security/ACL list and it appears to be the one but can't find one...

Any other suggestion? I did the search in this list based on AdnersBGS suggestion and only found three linked to the Incident table and they all allowed access to the itil role. so that's not what's preventing them access

Plus this is a new issue - we have been on Tokyo for a while now and due to go to Utah later this month and it is just now broken.

AndersBGS · ‎11-02-2023

Hi @terrieb ,

Go to ACL

and review all the ACLs based on the table and report_view operation:

There should be one here that is causing the issue.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/