Script to delete records from hardware table

[Navneet3]

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

[Voona Rohila]

You can run it as background script or as a fix script as ankur mentioned.

[Navneet3]

Ankur, The table is alm_hardware not cmdb table

thanks

[Ankur Bawiskar]

please enhance the script from your side.

It was just an example

[Navneet3]

is this right?

deleteRecords();

function deleteRecords(){
try{
var grAlmHardware = new GlideRecord('alm_hardware');
grAlmHardware.addEncodedQuery("serial_numberISEMPTY");
gralmHardware.query();
gs.print(gralmHardware.getRowCount()); //check count before deleting
while(grAlmHardware.next())
{
//grCmdbCiHardware.deleteRecord(); //uncomment for delet
}
}
catch(ex){
gs.info(ex);
}
}

[Ankur Bawiskar]

yes

Minor changes

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