Deleting multiple tickets

[stevelucas]

Hi,

I have a situation where I was testing knowledge base and I have over 8000 tickets I want to delete.

Is there an easy way to do this rather than 100 at a time.

Thanks

Steve

[Mike Allen]

The deleteMultiple method:

http://wiki.servicenow.com/index.php?title=GlideRecord#Delete_Methods

[Mike Allen · Accepted solution]

Or, if you just want to clear out the whole table, do that in the Tables & Columns module, select your table, and then delete all records underneath the picker.

[stevelucas]

Thanks Mike

This will work…

Regards

Steve Lucas

2nd Line Support Team Leader

Smart421 smart solutions for the 21st Century

Part of the KCOM Group

[Anurag Tripathi]

Hi Steve,

This should help, run this in background script or a on demand job

function deleteComputerRecords(){

var rec = new GlideRecord('your_table');

rec.addQuery('created_by',<get the user id>); //&& OR any other condition that works

rec.deleteMultiple();

Also check this

delete records faster based on condition