Finding Duplicate Serial Numbers

[SkipperJim]

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 · Accepted solution]

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

[mitch9]

Where would you run this script to view the output?

[Phil32]

Why aren't you using the CMDB Health Dashboard jobs?

https://docs.servicenow.com/bundle/paris-servicenow-platform/page/product/configuration-management/c...

[GITAM-Ninja]

The deDup only works for CI's -  And it is fabulous !   However we are trying to to the following

1.  Identify duplicate serial numbers from the Hardware Asset Table

2.  Combine the asset records to one record.

3.  Clear all Duplicates

4. Then set Serial number as unique