In the previous version 1.36.3 I used to a simple sql query that will show
which tapes are in changer and which tapes are offsite location. It looked
like this below.
inchanger slot VolumeName VolStatus percent_full lastwritten
1 3 SDLT005 Purged 76.1 2006-07-21
23:57:55
1 6 SDLT019 Purged 97.1 2006-07-22
12:08:12
1 7 SDLT016 Purged 83.4 2006-07-24
01:24:20
1 5 SDLT017 Full 110.2 2006-07-25
05:50:59
0 6 SDLT008 Full 101.9 2006-08-01
03:23:32
0 5 SDLT001 Full 100.4 2006-08-02
03:13:17
Since the database structure changed a lot this script won't work now. I
used the following query that is given below.
#!/bin/sh
echo "Content-type: text/html"
echo
echo "<html>"
echo "<head>"
echo "<title>Bacula Tape Status</title>"
echo "</head>"
echo "<body>"
avg_capacity=`mysql -NB -u bacula -h heptagram -e "select
sum(VolBytes)/count(VolBytes) from Media where VolStatus = 'Full'" bacula`
mysql -H -u bacula -h heptagram -e "select inchanger, slot, VolumeName,
VolStatus, round((100 * VolBytes / $avg_capacity), 1) as percent_full,
lastwritten from Media where poolid=3 and
VolStatus!='Error' order by lastwritten;" bacula
echo "</body>"
echo "</html>"
The first query worked fine but not the second one.
If somebody correct me that will be great.
Thanks,
Arunav.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
