Re: [Bacula-users] needed tapes

[Stefan G. W. <li...@xu...>]

Am 13.03.25 um 13:09 schrieb Gary R. Schmidt:
> On 13/3/25 18:14, Stefan G. Weichinger via Bacula-users wrote:
>>
>> thanks all for your replies and explanations.
>>
>> It wasn't my intention to let somebody else do my work, no :-)
>>
>> I see the complexity somehow, and wonder if I can at least come up 
>> with something that *helps* choosing the next 8 tapes each week.
>>
>> Currently mostly I select the tapes, I am the external admin of that 
>> server, and it seems the customer would prefer if some internal tape 
>> operator can do that ... (that guy is very likely cheaper for them).
>>
>> The customer has to write and fulfill a specific SOP document for 
>> backups, and I will see if I can negotiate about that part.
>>
>> So it is standard procedure for most of the Bacula installations that 
>> somebody "manually" selects the tapes regularly? Sure, with big 
>> libraries it's not necessary, I understand.
>>
>> Thanks, greetings, Stefan
>>
>> ps: I still haven't found the time to look at that script using 
>> bconsole ... I will do that asap and see what I can achieve.
>>
> 
> I use an 8-slot autoloader, I added a little bit of SQL to the query 
> file and just run that, it lists my tapes from last-used to most recent.
> I grab the three oldest, move them to the Scratch pool, purge them, and 
> replace the three oldest in the autoloader with them.
> 
> NOTE: This is for Postgres, YMMV:
> # 22
> :List volumes in Order of LastWritten
> SELECT Media.MediaId, Media.VolumeName, Media.PoolId, Pool.Name AS Pool, 
> Media.Slot,
>          Media.Slot <> 0 AS InChanger, Media.FirstWritten, 
> Media.LastWritten, Media.VolStatus,
>          GREATEST(0, (extract('epoch' from LastWritten + 
> Media.VolRetention * interval '1second' - NOW())::bigint)) as ExpiresIn,
>          Media.VolBytes
>      FROM Media
>      INNER JOIN Pool
>          ON Media.PoolId = Pool.PoolId
>      ORDER BY Media.LastWritten;
> 
> I wrote it about 6 years ago, previously I'd been looking at the output 
> of "list media" and working out what was oldest.

oh, looks promising, thanks for sharing! I will test that later today 
when I have to select tapes for the weekend.