Back to Community Threads
1
Deleting Old Tickets?
Question asked by Leo Novelli - 11/24/2014 at 11:30 AM
Answered
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.
0
Employee Replied
11/24/2014 at 3:55 PM
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.
0
jwmagno Replied
5/28/2016 at 7:03 AM
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. 
0
jwmagno Replied
7/8/2016 at 11:26 AM
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.
0
Kelly Anderson Replied
7/10/2016 at 9:49 AM
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
0
Yannick Guerdat Replied
8/29/2018 at 11:22 PM
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.Group - Digital Transformation, eGovernment Solutions
0
Andrew Barker Replied
8/30/2018 at 7:30 AM
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. www.smartertools.com
0
Yannick Guerdat Replied
8/30/2018 at 9:13 AM
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.Group - Digital Transformation, eGovernment Solutions
Back to Community Threads

Reply to Thread

Enter the verification text

Related Knowledge Base Articles

SmarterTrack/WHMCS Addon ModuleUtilities and Conversion Tools
How To: Migrate a Brand to new Hosted SmarterTrack siteHosted SmarterTrack Helpdesk > General Topics
Reindex SmarterTrack Search TablesSmarterTrack > Server Configuration and Management
Hosted SmarterTrack Trials & Paid SubscriptionsHosted SmarterTrack Helpdesk > General Topics
Merge Multiple Tickets Into OneSmarterTrack > Agent Configuration and Management