How to combine multiple entries in change report ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-24-2025 02:22 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-24-2025 06:22 AM
Hi @LekhaJ
No mate, it will show in a separate row only , as all CI are separate records.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-24-2025 06:27 AM
Steps to Create a Consolidated Change Report
Navigate to the Report Builder:
Go to Reports > Create New or open an existing report.
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.
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).
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.
Add Other Fields:
Add any other fields you want to include in the report (e.g., short_description, assigned_to, state, etc.).
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).
Save and Run the Report:
Save the report and run it to verify that the data is consolidated as expected.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-25-2025 09:09 PM
Hi, I am unable to find the List or Comma Separated List in the Aggregation.
Also, Aggregation isn't available in the list view.