Hi
At my company, the technical team handles large open tickets with extensive customer attachments, often big image files. Once resolved, I suspect these files aren't automatically deleted, leading to significant unnecessary storage usage in GBs. How can I optimise this process?
Kind regards
Adil
Optimising Storage: Managing Ticket Attachments Efficiently
Moderator: mkoch227
Re: Optimising Storage: Managing Ticket Attachments Efficiently
No data is deleted when a ticket is marked resolved.
You can either delete old tickets or delete files manually from the "attachments" folder.
You can either delete old tickets or delete files manually from the "attachments" folder.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here 
You should follow me on Twitter here
Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...
Also browse for php hosting companies, read php books, find php resources and use webmaster tools


Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...
Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Re: Optimising Storage: Managing Ticket Attachments Efficiently
Hello adildev89,
Maybe you can use what I do. I run HESK on a Linux server with jpegoptim, pngcrush, and optipng installed. I use this little script to optimize the size of image files, as they are often the ones that take up the most space:
After the last run (it had been a while), our attachments folder went from 169MB to 82MB. So, it is quite an improvement.
Maybe you can use what I do. I run HESK on a Linux server with jpegoptim, pngcrush, and optipng installed. I use this little script to optimize the size of image files, as they are often the ones that take up the most space:
Code: Select all
#!/bin/sh
for i in find . -name "*.png"; do pngcrush -e .png2 -rem allb -brute -reduce $i mv ${i}2 $i optipng -o7 $i done
jpegoptim --max=85 --strip-all --preserve --totals *.jpg
Re: Optimising Storage: Managing Ticket Attachments Efficiently
Thanks for sharing the image optimization path, that's also an option (not for all users, of course).
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here 
You should follow me on Twitter here
Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...
Also browse for php hosting companies, read php books, find php resources and use webmaster tools


Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...
Also browse for php hosting companies, read php books, find php resources and use webmaster tools