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

Bilasnew
Tera Contributor

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.

2 REPLIES 2

Tanushree Maiti
Mega Patron

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 mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin:

Its_Azar
Mega Sage

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.