Create report duplicate records?

[Shashi K]

Do I need to find duplicate records of cabs?
We have six cabs
CAB-1, CAB-2, CAB-3,CAB-4,CAB-5,CAB-6
A change request record goes above any one cab and the same change goes to CAB-7, I don't want those records, I just want to find duplicate records of these cabs

table: cab agenda items .

Thanks in advance 

[Deepak Shaerma]

hi @Shashi K 
Using List Filters:
1. Navigate to the “cab agenda items” table list view in your ServiceNow instance.
2. Filter Records: Use the filter option to create a query such as:
- CAB is one of CAB-1, CAB-2, CAB-3, CAB-4, CAB-5, CAB-6.
- You might need to use the Group by option if available, or simply list all and then manually sort or search within the list for duplicates.

Note: This approach works for quick checks but might not be efficient for identifying duplicates, especially if you have a large number of records.

Creating a Report for Duplicates:
1. Navigate to Reports and click on “Create New”.
2. Select the “cab agenda items” table as your Data Source.
3. Configure the report to group by the Change Request number (or any unique identifier for the change request) and then by the CAB identifier.
4. Add a filter to exclude records associated with CAB-7.
5. Use the aggregation/count function to identify records with more than one count, which would indicate duplicates among CAB-1 to CAB-6.
You can also go for the script logic for a more precise and automated way to find duplicates among CAB-1 to CAB-6.

Note: Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning ‌‌
Thanks & Regards 
Deepak Sharma

[Dr Atul G- LNG]

Hi @Shashi K 

Practically there is no way to see the change which is not gone in CAB. It depends on the filter criteria you put on agenda criteria.