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-04-2015

Hi ravio,

What kind of data is in those fields? This sounds like it might be an instance of PRB586579:

ServiceNow KB: PRB586579: Inactive user data is omitted when report is exported by non-admin user (K...

Ravish Shetty · ‎09-05-2015

Hi Cory, These are the fields on the computer table (cmdb_ci_computer) like Operating system. The report is generated on the Relationship table (cmdb_rel_ci) and we want the data of these fields for the Parent and the Child CI fields on the Relationships table.

coryseering · ‎09-05-2015

Hi ravio,

That does sound like an instance of the bug I mentioned (dot-walked fields on an Excel report are not visibile to non-admin users, though ACLs should grant them said access).

Open up an Incident with Support to verify. They can attach the incident to the existing PRB, so you can be notified for updates. If I am wrong about the cause (it could be unrelated) they should be able to track down the issue.

In the mean time, you should be able to present the data via a UI Page, create a Database View to report against, or run separate reports for each table.

Thanks

Cory

Ravish Shetty · ‎09-07-2015

Hi Cory,

The reports are fine. User is able to see the data on the report. Problem occurs when they download the excel and open the spreadsheet where they are unable to find the data.