Cant view certain fields in survey report using asmt_metric_result

Matt Todd
Kilo Contributor

‎02-03-2020 03:58 PM

Hi all,

Ive made a report to display all survey results on the asmt_metric_result table. It works on my admin account, however when i log in as a user there are fields missing. Particularly instance.task.number, instance.task.short_description, instance.task.opened_by, instance.task.assigned_to. Originally none of the survey responses where there. i added the role survey_reader and it made the survey stuff available such as instance number, metric and string value, but not the related task information. Can anyone help identify what im missing here?

find_real_file.png

Labels:
Preview file
25 KB
  • 3,579 Views
7 REPLIES 7

Matt Todd
Kilo Contributor

‎02-03-2020 04:14 PM

I specifically need help identifying what permission im missing to display these fields. The report works under my admin account, but not a users.

0 Helpfuls

Sandesh9
Tera Guru
In response to Matt Todd

‎02-03-2020 05:38 PM

Hi,

For the users to see the specific details of the targeted records, they will need read level access to those tables. For instance if the survey is for Incident resolution, you might want to check that they have access to those fields that you are running a report on. So, did you see if that user meets the Read ACL criteria for that table??

Hope this helps, Please mark helpful or correct based on the impact!

0 Helpfuls

pavan9885
Tera Guru

‎02-03-2020 06:12 PM

Hi Matt 

 

check the acls on the tables and  read roles of the acl's  and user roles.

 

1. users need to have read acess to see any fields what they need to see

2 Check the acls if any roles is needed for read acls they user need to have read acl's to see the fields and data on the reports.

https://docs.servicenow.com/bundle/newyork-performance-analytics-and-reporting/page/use/reporting/co...

0 Helpfuls