Hi @Ginasz,
To create a report in ServiceNow showing changes by the top 10 configuration items for the last six months, follow these concise steps:
1. Navigate to Reports:
- Go to Reports > Create New
2. Define Report Source:
- Name: "Top 10 CI Changes - Last 6 Months"
- Source Type: Table
- Table: Change Request [change_request]
3. Set Conditions:
- Add a condition: `Opened on` `is` `on or after` `6 months ago`.
4. Group and Aggregate:
- Group By: `Configuration Item [cmdb_ci]`
- Aggregation: Count
5. Filter and Display:
- Display Type: Bar Chart
- Maximum Number: 10
6. Save and Run:
- Click `Save`.
- Click `Run`.
This will generate a report showing the top 10 configuration items with the most changes over the last six months.
Thank you, please make helpful if you accept the solution.
Hi @Ginasz,
To create a report in ServiceNow showing changes by the top 10 configuration items for the last six months, follow these concise steps:
1. Navigate to Reports:
- Go to Reports > Create New
2. Define Report Source:
- Name: "Top 10 CI Changes - Last 6 Months"
- Source Type: Table
- Table: Change Request [change_request]
3. Set Conditions:
- Add a condition: `Opened on` `is` `on or after` `6 months ago`.
4. Group and Aggregate:
- Group By: `Configuration Item [cmdb_ci]`
- Aggregation: Count
5. Filter and Display:
- Display Type: Bar Chart
- Maximum Number: 10
6. Save and Run:
- Click `Save`.
- Click `Run`.
This will generate a report showing the top 10 configuration items with the most changes over the last six months.
Thank you, please make helpful if you accept the solution.
