Creating Report for Top 10 CIs from Resolved Incidents

anvitha ash
Tera Contributor

3 weeks 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
  • 537 Views
4 REPLIES 4

Dr Atul G- LNG
Tera Patron

3 weeks ago

Hi @anvitha ash 

 

Create a report on the Incident table and add a filter such as:

 

DrAtulGLNG_0-1766405458443.png

DrAtulGLNG_1-1766405490877.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/dratulgrover [ Connect for 1-1 Session]

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

anvitha ash
Tera Contributor
In response to Dr Atul G- LNG

3 weeks ago

What does maximum number of groups means here ???

0 Helpfuls

Dr Atul G- LNG
Tera Patron
In response to anvitha ash

3 weeks ago

It shows first 10 top CI only; if you put all, you can see all the CI.

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

Dr Atul G- LNG
Tera Patron

3 weeks 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/dratulgrover [ Connect for 1-1 Session]

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