List space used/free on each tape currently in autochanger

[JHI Star]

Is this possible ?

Many thanks

[Spadajspadaj]

You can query the database for media details. You can get both the used capacity and overall capacity in bytes and blocks but be aware that you need to take into account also the status of the volume. You can only write more jobs to the tape if it's in "Append" status.

example query (using my pool name; chose any columns you want and run it via sqlquery on bconsole):

select
  media.volumename,
  media.mediaid,
  media.volcapacitybytes,
  media.volbytes,
  media.maxvolbytes,
  media.volblocks,
  media.endblock,
  media.volstatus
from
 media join pool
   on media.poolid = pool.poolid
where
  pool.name like 'Offsite%' and media.inchanger=1;

On 20.10.2021 11:13, JHI Star wrote:

Is this possible ?

Many thanks

--
You received this message because you are subscribed to the Google Groups "bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/90733c0a-7745-47fe-9a53-3649ae6f1267n%40googlegroups.com.