question Reset Number Counter in Community Central forum

Reset Number Counter

ashavinod — Wed, 04 Sep 2024 09:59:31 GMT

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

Re: Reset Number Counter

Zach Koch — Wed, 04 Sep 2024 13:08:02 GMT

Take a look at this post.

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.

Re: Reset Number Counter

Anurag Tripathi — Wed, 04 Sep 2024 13:13:58 GMT

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.

Re: Reset Number Counter

ashavinod — Wed, 04 Sep 2024 13:23:13 GMT

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.

Re: Reset Number Counter

ashavinod — Wed, 04 Sep 2024 13:23:58 GMT

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.

Re: Reset Number Counter

Anurag Tripathi — Wed, 04 Sep 2024 13:38:39 GMT

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.