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

terrieb · ‎11-02-2023

Yes that was the issue and I have resolved it by going table by table from the reports and adding the itil role where needed. The dashboard is now working as originally designed.

Thank you for the quick resolution!