User doesn't see data in the exported spreadsheet

Ravish Shetty · ‎09-04-2015

Hi,

A user with itil role is trying to export data from the report. They can see the data in the report but when they open the spreadsheet they are not able to see it. This doesnt happen to all the columns. The field level ACL's have many 'requires role' and itil is one of them. I impersonated with the user and opened the record and i am able to see the field so doesn't look like a problem with the read acl.

Ravish Shetty · ‎09-10-2015

Hi Cory,

I checked with the SN support and it seemed the problem was something else.

There was a read access control on the cmdb_ci table.

I removed the admin role from the 'requires role' tab and it worked.

Now it is strange why this ACL previously gave us inconsistent result as we were able to see the data on the report but not on the spreadsheeet.

View solution in original post

coryseering · ‎09-13-2015

Hi Ravio,

Thanks for following up. If you are going to keep the modifications you made to your ACLs to work around the problem I strongly suggest doing a review of the users who now have rights to the data, and the specific data they can read, to ensure you aren't granting something you don't expect.