Hello @_bhishek ,
You can create a script include for the same and you can use that script include and use the same in your report.
Create a script include:
var Duplicate_Records_serial = Class.create();
Duplicate_Records_serial.prototype = Object.extendsObject(AbstractAjaxProcessor, {
duplicateRecord: function(){
var numbers = [];
var gaDupCheck = new GlideAggregate('alm_asset');
gaDupCheck.addAggregate('COUNT', 'serial_number');
gaDupCheck.addNotNullQuery('serial_number');
gaDupCheck.groupBy('serial_number');
gaDupCheck.addHaving('COUNT', '>', 1);
gaDupCheck.query();
while (gaDupCheck.next()) {
numbers.push(gaDupCheck.serial_number.toString());
// var gr = new GlideRecord('alm_asset');
// gr.addQuery('serial_number',gaDupCheck.serial_number);
// gr.query();
// gs.info('Duplicate serial number: ' + gaDupCheck.serial_number);
}
//gs.info("Serial_records "+numbers)
return numbers;
},
type: 'Duplicate_Records_serial'
});
and create a report in that call the above script include like this.
Condition: serial number is "javascript:new Duplicate_Records_serial().duplicateRecord()"
Please mark this Accepted and helpful if this worked for you.
I ran into the same issue and it was the condition on the report that was incorrect for me. Try making sure that the condition is:
javascript:new Duplicate_Records_serial().duplicateRecord()
Also, row 9 on the script include should filter out null serial numbers, so it may not be working correctly for you.
A way to test if the script is working correctly is to create two assets with the same serial number and check if they show up in the report.
Edit: The report condition breaks when posting as text but it is:
