Script to delete records from hardware table

Navneet3 · ‎03-08-2022

Hi

I am looking for a script to delete 5419 records from hardware table, the transform map created assets without serial numbers.

The key is SERIAL # is NULL.

thank you

Ankur Bawiskar · ‎03-08-2022

Hi,

you didn't see my updated script

you had used incorrect gliderecord object which I corrected 34mins ago

sharing the script again

deleteRecords();

function deleteRecords(){
	try{
		var grAlmHardware = new GlideRecord('alm_hardware');
		grAlmHardware.addEncodedQuery("serial_numberISEMPTY");
		grAlmHardware.setLimit(5);
		grAlmHardware.query();
		gs.info(gralmHardware.getRowCount()); //check count before deleting
		while(grAlmHardware.next())
		{
			grAlmHardware.deleteRecord(); //uncomment once you verify the count got reduced by 5
		}
	}
	catch(ex){
		gs.info(ex);
	}
}

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

shloke04 · ‎03-08-2022

Hi,

You can follow what Rohila has mentioned, that will work for you.

Create a Fix Script and use the same script as shown below .

Advantage is you can move this to your higher instance as well.

Regards,

Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

shloke04 · ‎03-08-2022

Hi @Navneet

Try below script:

removeRecord();
function removeRecord(){
var gr = new GlideRecord('alm_hardware');
gr.addEncodedQuery("serial_numberISEMPTY");
gr.setLimit(10);
gr.query();
gr.deleteMultiple();
}

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke