tbrosow
4/25/2016 - 11:40 PM

datacleanup

datacleanup

deleteRecords('alm_transfer_order_line');
deleteRecords('alm_transfer_order');
deleteRecords('alm_asset');
deleteRecords('u_part_family');
deleteRecords('cmdb_consumable_product_model');
deleteRecords('u_serialised_part');
deleteRecords('u_m2m_part_master_vendor');
deleteRecords('u_bill_of_material');
deleteRecords('u_m2m_part_master_component'); 
deleteRecords('u_stock_level');
deleteRecords('cmdb_m2m_model_compatibility');
deleteRecords('u_m2m_roh_parts'); 
deleteRecords('alm_stockroom');
deleteRecords('u_stock_adjustment');
deleteRecords('u_default_bin_bad');
deleteRecords('u_tl_default_bin');
deleteRecords('proc_po_item');
deleteRecords('proc_po');
deleteRecords('proc_rec_slip');
deleteRecords('sm_part_requirement');
deleteRecords('u_dispatch_modes');
deleteRecords('u_repair_sequence');
deleteRecords('u_repair_task');
deleteRecords('u_m2m_repair_sequence_task_template');
deleteRecords('u_m2m_repair_method_sequence');
deleteRecords('u_repair_sequence_template');
deleteRecords('u_repair_task_template_values');
deleteRecords('u_tl_repair_task_template');
deleteRecords('u_repair_order');
deleteRecords('u_repair_method');

function deleteRecords(_table, _query) {
	gs.print('Deleting records table: ' + _table + ' using query: ' + _query);

	var gr = new GlideRecord(_table);
	if (_query) {
		gr.addEncodedQuery(_query); 
	} else {
		gs.print('Delete all records of table: ' + _table);
		var _query = '';
	}
	gr.query();
	var records = gr.getRowCount();
	gr.deleteMultiple();
	gs.log('SYSTEM-CLEAN-UP: Deleted ' + records + ' records of table: ' + _table + ' using query: ' + _query);
}