Reset or Clear Old Ticket Data + Reset Ticket ID Value

Hi all. I’m running RT 3.4.1 and have the following 2 questions.

I need to clear the RT database of all old ticket and ticket related
information as well as reset the the ticket id so that it’s back at 1.

Question 1: Which tables do I need to reset/clear?

Question 2: How do I set the ticket id back to its original value?
(After I delete all ticket values,

  • What I know concerning Question 1:
    I have the following tables in the RT database:
    ACL
    Attachments
    Attributes
    CachedGroupMembers
    CustomFieldValues
    CustomFields
    GroupMembers
    Groups
    Links
    ObjectCustomFieldValues
    ObjectCustomFields
    Principals
    Queues
    ScripActions
    ScripConditions
    Scrips
    Templates
    Tickets
    Transactions
    Users
    sessions

I’m guessing I need to clear (delete * from table-name): Attachments,
Links, Tickets, Transactions. What else?

Anything else I should know regarding this process?

Thanks in advance,

Robert Marier

Question 1: Which tables do I need to reset/clear?

check out the following link:
http://wiki.bestpractical.com/index.cgi?DatabaseAdmin

Question 2: How do I set the ticket id back to its original value?
(After I delete all ticket values,

you could drop and recreate sequence ‘tickets_id_seq’, specifying the
whatever starting value you’d like to have for your ticket numbers

-anya