Issue with Reports on a Dashbord

[terrieb]

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

[terrieb]

There are only three ACL's on the incident report_view and all of them grant access to the itil role.  So that is not what's preventing this.  

I'm searching on all the report_view operation ACL's but not sure which "name" to verify - any suggestions?

[AndersBGS]

Hi @terrieb ,

The reports that the user cannot see, are they all based on the incident table? 

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

Best regards

Anders 

[terrieb]

There were only 3 in the System Security/ACL list for the incident table, report_view operation and all have the itil role included.

No, this is not just affecting reports from the Incident table.  There are project tasks, agile tasks as well and other reports on the dashboard based on the Incident table are working just fine.  Going to attach a file showing the full screen shot of the dashboard.

[AndersBGS]

Hi @terrieb ,

Ok, I can see you have the issue for stories project task, stories and scrum tasks so you need to search those relevant ACLs with report_view for those tables e.g.: rm_story.

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

Best regards

Anders 

[scott barnard1 · Accepted solution]

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