These should be useful for Bacula users with changers and may be useful
for those who don't have them.
in /etc/bacula/query:
# 18
:List Volumes Bacula thinks should be removed from changer
SELECT Storage.Name AS Location,Slot,VolumeName,VolStatus,
VolBytes/(1024*1024*1024) AS GB,MediaId,MediaType,Pool.Name AS Pool
FROM Media,Pool,Storage
WHERE Media.PoolId=Pool.PoolId
AND Slot>0 AND InChanger=1
AND Media.StorageId=Storage.StorageId
AND ((VolStatus='Used') OR (VolStatus='Full') OR (VolStatus='Disabled')
OR (VolStatus='Error'))
ORDER BY VolumeName ASC, Slot ASC;
# 19
:List Volumes Bacula thinks are eligible for the changer
SELECT VolumeName,VolStatus,Storage.Name AS Location,
VolBytes/(1024*1024*1024) AS GB,MediaId,MediaType,Pool.Name AS Pool
FROM Media,Pool,Storage
WHERE Media.PoolId=Pool.PoolId
AND Media.StorageId=Storage.StorageId
AND InChanger=0
AND ((VolStatus='Purged') OR (VolStatus='Append') OR (VolStatus='Recycle'))
ORDER BY VolMounts ASC, Pool.Name ASC, VolumeName ASC
Improvements to SQL welcomed.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
