Breaking News: Grepper is joining You.com. Read the official announcement!

duplicate serial numbers asset

Envious Elk answered on February 4, 2022 Popularity 1/10 Helpfulness 1/10

answer duplicate serial numbers asset

duplicate serial numbers asset

Comment

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);

}

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: community.servicenow.com

Tags: javascript

Link to this answer
Share Copy Link