Re: [bareos-users] List space used/free on each tape currently in autochanger

[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+unsubscr...@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 
.


--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/4d0698f8-13ba-5e37-a5e1-7321953b0c88%40gmail.com.

[bareos-users] List space used/free on each tape currently in autochanger

[JHI Star]

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+unsubscr...@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.