How to combine multiple entries in change report ?

[LekhaJ]

I am trying to create a change report but there are multiple entries due to multiple CIs added to a change. Is there a way we can club these entries to show a single row?

[Dr Atul G- LNG]

Hi @LekhaJ 

No mate, it will show in a separate row only , as all CI are separate records.

[Murtaza Saify]

Steps to Create a Consolidated Change Report

1. Navigate to the Report Builder:

   • Go to Reports > Create New or open an existing report.

2. Select the Table:

   • Choose the table that contains the data you want to report on. For example:

     • If you're using the change_request table, select it.

     • If you're using a related table like task_ci (which links Changes to CIs), select that.

3. Add Grouping:

   • In the Group By section, add the field you want to group by. For example:

     • Change Request Number (number) or Change Request Sys ID (sys_id).

4. Add Aggregation for CIs:

   • Add the Configuration Item field (e.g., cmdb_ci) to the report.

   • In the Aggregation section, select List or Comma Separated List for the CI field. This will combine all CIs associated with a single Change Request into one row.

5. Add Other Fields:

   • Add any other fields you want to include in the report (e.g., short_description, assigned_to, state, etc.).

6. Configure the Report:

   • Set the report type (e.g., Bar Chart, Pie Chart, or List).

   • Apply filters if needed (e.g., only show Changes in a specific state or created within a certain time frame).

7. Save and Run the Report:

   • Save the report and run it to verify that the data is consolidated as expected.

[LekhaJ]

Hi, I am unable to find the List or Comma Separated List in the Aggregation. 
Also, Aggregation isn't available in the list view.