I want to create a report to find the top 10 CIs (by numbers) in the incidents raised for a month. Can someone help

[Alok9]

I want to create a report to find the top 10 CIs (by numbers) in the incidents raised for a month. Can someone help

[dvp · Accepted solution]

Configure the report as show in the screenshot and you may need update the created on condition to as per your requirement

[Adam Stout]

1) Use the Report Designer, not the Legacy Report Builder.  This won't affect the results in this case, but it is a best practice.

2) Uncheck "Show Other" if you only want to see 10.  I would probably also remove incidents where CI is empty.

[rchristopher]

 Hi Adam, I have this above report in ServiceNow. Is it possible to generate month on month count for each CI? Like the one below, which I created by exporting 6 months data into an excel and created the chart on top CIs.

 Thank you,

Ramya