Get the count of Incidents which are more than 1 for same CI

[Rakshanda Kunte]

Hi,

Get the count of Incidents which are more than 1 for same CI

How can we fetch this from Reports?

[Mark Manders]

Create the report on the cmdb_ci table (or the class you need it for) and use the related list conditions to select '2 or more' from the incident related list on that ci.

[Uncle Rob]

Check out this video on building reports with Related Record Conditions.
Build the report on the CI class you're interested in (or just base CMDB_CI ... but that might be REALLY big)
Add the related record condition of Incident > 0

You can even add conditions on the related records.  So you could even say Incident > 0 but only incidents created in the last 12 months.