Prevent duplicate attachments in the helpdesk
We have many users that have our logo in their email signature and when they submit a ticket their logo image is added as an attachment to the ticket. Over time this will create a lot of separate unneeded attachments.
One solution for this could be to create a hash of each attachment and save it to the database. When someone submits an attachment have the system generate a hash and compare to the hashes in the database. If the hash is in the database then link the already saved attachment to the ticket, if the hash is not in the database then save the attachment as a new file.
That's one solution, but theres probably more to solve duplicate files.