How to Restart Request ticket Number?

[Anonymous]

Hi,

I open 30 test ticket in itop. now i want to restart the ticket no. for example now, when i open a new ticket, ticket no start like "I-1031" but i want like" I-1001".
Please help me.

[TheBigOne]

Hi,

if you delete the ticket entries in the DB or whereever you also need to reset the auto_increment counter on the table:

ALTER TABLE tablename AUTO_INCREMENT=0

[Aman]

Hi All,

Just started ticket no from 1
But notification and History of previous deleted ticket still exist.

Plz help its Urgent

[Aman]

Hi All,

Just started ticket no from 1
But notification and History of previous deleted ticket still exist.
Want to delete history and notification of previous ticket

Plz help its Urgent

[Diego Flores]

Did you resolve your problem? I'm facing the same situation. I can delete Tickets from GUI but there is message that there are linked objects that must be deleted as well to maintain db consistency.

Can someone help us?!

Thanks!.

[Nabeel ahamed]

you have to delete all the entries in the databaase table in order to resolve this issue.
please mail me to mkr.nabeel@gmail.com to assist.

[Dan Hsieh]

Hi! Could you advise me how to reset the ticket number in iTop? I try to remove the tickets from GUI but it will continue the ticket number when new ticket create.

[Pierre Goiffon]

Hello,
For now tickets ref are directly made from the ticket id, which is an auto increment field.
In the upcoming 2.7.0 the ref will be handled separetly with a new ItopCounter object.

[Jeffrey Bostoen]

There's actually another way. But then the ID in the ref won't be the same anymore as in the reference.

If that's fine, you can alter the method which generates the ticket ref.