Delete attachments - otrs - OTRS mailing lists

newer
can't login after Update (OTRS 5...

Delete attachments

older
OTRS 5 - Hiding fields from...

PREF31 OTRS

11 Jul 2018 11 Jul '18

6:38 a.m.

Hi, I have too many attachments on my database. Can I delete oldest attachments directly on the hard drive? I did a test and it seam correct but your views will help me. Thanks and best regards. Claude Pour une administration exemplaire, préservons l'environnement. N'imprimons que si nécessaire.

Reply

Sign in to reply online Use email software

Show replies by date

Diego Chacón

16 Jul 16 Jul

8:56 p.m.

No. My advice, move attachments from database to filesystem. OTRS create a folder per year, compress old folders On Wed, Jul 11, 2018 at 12:38 AM, PREF31 OTRS < pref-otrs@haute-garonne.gouv.fr> wrote:

Hi,

I have too many attachments on my database.

Can I delete oldest attachments directly on the hard drive?

I did a test and it seam correct but your views will help me.

Thanks and best regards.

Claude

Pour une administration exemplaire, préservons l'environnement. N'imprimons que si nécessaire. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

-- *Diego Chacón Rojas* ** E-mail: diego@gridshield.net *

Reply

Sign in to reply online Use email software

PREF31 OTRS

17 Jul 17 Jul

5:56 a.m.

Thanks Diego Chacón a écrit :

No.

My advice, move attachments from database to filesystem. OTRS create a folder per year, compress old folders

On Wed, Jul 11, 2018 at 12:38 AM, PREF31 OTRS mailto:pref-otrs@haute-garonne.gouv.fr> wrote:

Hi,

I have too many attachments on my database.

Can I delete oldest attachments directly on the hard drive?

I did a test and it seam correct but your views will help me.

Thanks and best regards.

Claude

Pour une administration exemplaire, préservons l'environnement. N'imprimons que si nécessaire. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs http://lists.otrs.org/mailman/listinfo/otrs

-- /Diego Chacón Rojas/ /* E-mail: diego@gridshield.net mailto:diego@gridshield.net/

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

Pour une administration exemplaire, préservons l'environnement. N'imprimons que si nécessaire.

Reply

Sign in to reply online Use email software

Olivier Macchioni

1:40 p.m.

+1 here... We're running OTRS on Linux - we actually move the directories to a loopback BTRFS filesystem, one mount point per year. BTRFS supports compression - we save approx 50% of the space, plus a large numbers of inodes. We run this process yearly, for all the tickets of year (current year - 2), which are usually not touched any more anyways.

On 17 Jul 2018, at 07:56, PREF31 OTRS wrote:

Thanks

Diego Chacón a écrit :

...
No.

My advice, move attachments from database to filesystem. OTRS create a folder per year, compress old folders

On Wed, Jul 11, 2018 at 12:38 AM, PREF31 OTRS mailto:pref-otrs@haute-garonne.gouv.fr> wrote: Hi,

I have too many attachments on my database.

Can I delete oldest attachments directly on the hard drive?

I did a test and it seam correct but your views will help me.

Thanks and best regards.

Claude

Pour une administration exemplaire, préservons l'environnement. N'imprimons que si nécessaire. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs http://lists.otrs.org/mailman/listinfo/otrs

-- Diego Chacón Rojas * E-mail: diego@gridshield.net mailto:diego@gridshield.net

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs http://lists.otrs.org/mailman/listinfo/otrs

Pour une administration exemplaire, préservons l'environnement. N'imprimons que si nécessaire. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

Reply

Sign in to reply online Use email software

Renee B

18 Jul 18 Jul

5:39 a.m.

With my addon TicketAttachments you can delete single attachments from a ticket or you can create a kind of GenericAgent to delete attachments based on filters... https://feature-addons.de/otrs/Ticket/TicketAttachments Kind regards, Renée Am 16.07.2018 um 22:56 schrieb Diego Chacón:

No.

My advice, move attachments from database to filesystem. OTRS create a folder per year, compress old folders

On Wed, Jul 11, 2018 at 12:38 AM, PREF31 OTRS < pref-otrs@haute-garonne.gouv.fr> wrote:

...
Hi,

I have too many attachments on my database.

Can I delete oldest attachments directly on the hard drive?

I did a test and it seam correct but your views will help me.

Thanks and best regards.

Claude

Pour une administration exemplaire, préservons l'environnement. N'imprimons que si nécessaire. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

-- Perl / OTRS development: http://perl-services.de OTRS AddOn repository: http://opar.perl-services.de

Reply

Sign in to reply online Use email software

2557

Age (days ago)

2564

Last active (days ago)

Download

4 comments

4 participants

tags

participants (4)

Diego Chacón
Olivier Macchioni
PREF31 OTRS
Renee B