A report on the Incident Table

Zubair Alam2
Tera Contributor

An ITIL user has access to all the attributes of sys_user_group table when they run the report.
However, if they run the report on the Incident table and dot walk to sys_user_group attributes to be included in their report, the values from group table do not show up in this report. 
Any help is greatly appreciated. 

5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Zubair Alam2 

 

 

AGLearnNGrow_1-1719411364583.png

 

AGLearnNGrow_0-1719411342106.png

 

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi Atul: Thanks for your response. However, the values from the group table do not populate once a report is created on Incident table and dot walked to sys_user_group. all help is appreciated. Thanks. 

Hi @Zubair Alam2 

 

I added all fields of assignment group by dot walk and here is report in my PDI. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

James Chun
Kilo Patron

Hi @Zubair Alam2,

 

Did you dot-walk on the Assignment Group field in the Incident record?

 

ITIL users have access to the [sys_user_group] fields and it should all be visible in the report.

Do you have any custom ACL on the [sys_user_group] or the [incident] tables?

 

Cheers