Creating Report for Top 10 CIs from Resolved Incidents

anvitha ash
Tera Contributor

3 hours ago

Hi,

 

I am trying to create a report on the Incident table where the incident state is Resolved. From these resolved incidents, I need to capture all associated Configuration Items (CIs) and then identify and display the top 10 most frequently impacted CIs.

The requirement is:

Include all resolved incidents which is for current year

Group incidents by CI

Display the top 10 CIs based on the number of resolved incidents linked to them

Could someone please suggest the best approach to achieve this using ServiceNow reporting

 

Thanks in advance 😀 

0 Helpfuls
  • 275 Views
5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

3 hours ago

Hi @anvitha ash 

 

DrAtulGLNG_0-1766406604952.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]

****************************************************************************************************************
0 Helpfuls