user has ITIL role but not able see records from asmt_metric_result table.

Bilasnew
Tera Contributor

3 weeks ago

One user has ITIL access. Not able see records from asmt_metric_result table.
We have checked from the access analyzer,user passed the table read and report view,query range,query match,report on.
But  still user not able to see data.

0 Helpfuls
  • 584 Views
8 REPLIES 8

Tanushree Maiti
Tera Patron

3 weeks ago

Hi @Bilasnew 

 

Just once Grant the survey_reader or survey_admin role to the affected users and revalidate.

KB0714739 Unable to report on Survey or Assessment tables 

 

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti
0 Helpfuls

Its_Azar
Mega Sage

3 weeks ago

Hi there @Bilasnew

Check these:

 

Domain Separation restrictions

Before Query Business Rules on asmt_metric_result

Data filtration from User Criteria / Assessment conditions

Row-level ACL scripts returning empty results

 

☑️ If this helped, please mark it as Helpful or Accept Solution so others can find the answer too.

Kind Regards,
Azar
Serivenow Rising Star ⭐
Developer @ KPMG.
0 Helpfuls

Bilasnew
Tera Contributor

3 weeks ago

@Its_Azar 
Do you have any solution/recommendation of any approach to achieve this solution?

0 Helpfuls

Ankur Bawiskar
Tera Patron

3 weeks ago

@Bilasnew 

did you try giving survey_reader role as per what @Tanushree Maiti mentioned?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls