Create a report for CIs

[Shashi K]

Create a report for 

1.  Highest Number of Cis per Change 

2. Average Number of Cis per Change

[Dr Atul G- LNG]

Hi @Shashi K 

If you create a report on cmdb table or cmdb_ci class table it may impact performance as it pull data from many child table.

What is your exact use case

[Robbie · Accepted solution]

Hi @Shashi K,

This is easily achieved if you set the 'Table' to 'CIs Affected' (task_ci) under the 'Data' tab when setting up the report.

Please see the example screen shots below to help you.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie

Data tab:

Under the 'Configure tab' you can configure the report to either the 'Count' (total number of CI's) or 'Average.

- The key additional configuration is to set the filter as highlighted below so that the 'Task number' starts with 'CHG' meaning we only show Affected CI which are related to a change request.

[Shashi K]

Thanks Robbie

And I have created Average report

what am mention in aggregation 

aggregation- Average 

And below which field select