Deleting Old Tickets?
Question asked by Leo Novelli - 11/24/2014 at 11:30 AM
Is there a way to delete all the old closed tickets, along with their associated RawContent and Attachments, from a specific department or group?  
We have an old group that we don't use anymore and the old tickets are taking up a lot of disk space within the RawContent and Attachments folders.

7 Replies

Reply to Thread
Employee Replied
Employee Post Marked As Answer
Hello Leo,
Thanks for the inquiry. I would suggest for you to perform a backup of the database prior to making any changes or deleting is done. We do have a process that after you select to delete tickets after 90 days we will purge the records from the system. I do believe will also remove items form the attachments and raw content folders.  Please let us know if you encounter any other difficulties.
Note:  Items purged from SmartrerTrack are no longer indexed and will not return as results when using Advanced Search.
Thank You.
jwmagno Replied
How exactly do we delete all closed tickets? The reply above doesn't say how to do this. For example, tell me how to delete all closed tickets that are over a year old. We are running SmarterTrack Version 11.0.5619.21833. 
jwmagno Replied
We see that SmarterTrack automatically deletes purged items after 90 days.  Is there a job that we can run manually to do this process now so that we do not have to wait 90 day?  Thanks.
Kelly Anderson Replied
i created new thread for general discussion ..please guys come there
Top 10 paying ptc sites
Buy crackers online ahmedabad
Clash Royale Small Army power
Yannick Guerdat Replied
To force tickets deletion without to wait 90 days just run the following SQL Query : 
UPDATE st_Tickets
SET DateDeletedUTC = DATEADD(d, -91, GETDATE())
WHERE IsDeleted = 1
But actually by me the running task is never executed. Has anyone the same issue ? I have over 90'000 tickets marked as deleted but the cleaning job never work.

Artionet Web Agency | Director - Strategic Consultant Route de Moutier 109 | CH-2800 Delémont | Switzerland Website, CMS, e-Commerce, e-Gov, Social News Room

Andrew Barker Replied
Employee Post
Generally, we like to avoid posting SQL queries in community threads. We also recommend that you avoid running queries that may alter the structure or data of your SmarterTrack database. 
Before running any queries against your SmarterTrack database, please contact our support team. They may be able to assist you without manually running any queries.
As for your issue with the purge process not running, there are several possible factors that could be preventing the thread from running successfully. If your purge thread continues to fail, please contact our support department.

Andrew Barker
Software Developer
SmarterTools Inc.
(877) 357-6278

Yannick Guerdat Replied
Hello Andrew,
Ok sorry to have expose some SQL code but it's just a select :-) 
I'm already in touch with your support regarding my issue because it's not working and it make my full system slow. 
I was wondering if the community can assist me as well.

Artionet Web Agency | Director - Strategic Consultant Route de Moutier 109 | CH-2800 Delémont | Switzerland Website, CMS, e-Commerce, e-Gov, Social News Room

Reply to Thread