Reset Number Counter

[ashavinod]

In ServiceNow , how to reset number counter to 0 in number maintenance table

[Zach Koch]

Take a look at this post. 

How to re-set the number counter? 

However If this is a Prod environment I would highly recommend not doing this, as you will end up with duplicate numbers on records which are supposed to be unique and a lot of functionality is driven by this assumption of uniqueness. 

[Anurag Tripathi]

Agreed with Zack, be very careful with what you do and don't do it on prod

However, In some instances that module may still be in System Maintenance, which isn't open to admins. If so, you can go directly to the URL
http://www.service-now.com/yourinstancename/sys_number_list.do to reset a table's numbering.

[ashavinod]

But I need to reset the counter to 0 for all the records in the number maintenance table(sys_number). The solution you have provided is to be used for one particular record but I need to reset for all the records present.

[Anurag Tripathi]

Maybe this will help then

Numbering Existing Records - ServiceNow Guru

Again, test well and understand what implications it might have if you run this in prod.