Delete Tickets and attachements with GenericAgent

[adestis]

Hi everybody,

I have a question regarding the GenericAgent in the OTRS WebInterface and deleting Tickets this way.
If I select "Delete Tickets", will also the attachments for this tickets been deleted from the MySQL-Database? Do I have to run a script after that?
Or how can I delete tickets together with attachements and all other information from teh OTRS Database?

[crythias]

For what purpose are you asking this question? If you had tried it and found the answer is no, you'd be asking a different question.

[adestis]

Yes I deleted some tickets via GenericAgent but as it seems, the Attachments for this Tickets have not been deleted as the remaining disk space is still the same.
So I want to know if the GenericAgent only delete the ticket without attachment or if I have to run something after that to delete all regarding entries for this ticket from the database.

[crythias]

By default, attachments are stored in the Database (DB) unless manually changed to FileSystem (FS).

If the attachments are still part of database, it's possible that the database storage doesn't necessarily immediately decrease disk space.

If the attachments are part of FS, you'd be able to see if they're gone or not.

[adestis]

So if the attachments are part of a DB, will the entries deleted automatically by the OTRS system, when running the GenericAgent after some time or do I have to do some action manually?

[crythias]

You shouldn't need to do anything to remove attachments (according to what should be in the code.) When your database shrinks size is a different issue.