creation of reports on CI's

[Nitin_NOW]

Hello everyone

I am trying to create a report on all the CI's which we have and list of incidents associated with them in the below format. I am not sure whether this is possible or not but needs inputs from group.

Just a thought, can we do this on ci's table directly if possible ?

Thanks in advance

[Patrick Schult2]

If you want it in the list format like this, then you probably want to add a Calculated Field for it. Calculated fields do exactly what you are talking about, but they are somewhat resource-heavy on the system. See System Dictionary - ServiceNow Wiki   for more information.

You could potentially create a custom report to provide this same output, and avoid the pitfalls described in the Wiki (e.g. recalculation with every query), but that's probably not an optimal solution. Try the calculated fields first, and be sure to use a really lightweight script to keep it as fast as possible (e.g. use GlideAggregate to count incidents for each column, instead of GlideRecord).

[Deepak Kumar5]

Create a Report on incident of type Pivot table

[Nitin_NOW]

I have tried that and i see the below format. but i cant see the list of CI's left side. is there anything more i need to add.

[Deepak Kumar5]

You are choosing Affected CI in row instead of Configuration item.