Finding Duplicate Serial Numbers

SkipperJim · ‎02-03-2021

Is there a way to identify/report on duplicate serial numbers in the asset database in ServiceNow? Export dumps limits to 150K records for using alternative tools/methods, but we have more than 150K rows in the database.

Peda · ‎02-03-2021

Hi SkipperJim

this will help.

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()) { 

 var gr = new GlideRecord('alm_asset');
  gr.addQuery('serial_number',gaDupCheck.serial_number);
  gr.query();
  gs.info('Duplicate serial number: ' + gaDupCheck.serial_number);

}

best regards

View solution in original post

Luiz Lucena · ‎01-12-2023

We are in the same boat here.
Have you found a way to solve this?

GITAM-Ninja · ‎03-15-2023

We have not found a solution and the Remediation meetings for this are a time killer.