I believe that someone was asking for an SQL query to report on the assignment
of pools to volumes. Perhaps this will help...it lists volumes in each pool,
after prompting for the pool name. Suggestions in improving the SQL are welcome.
====================================================================
# 21
:List Volumes per Pool
*Enter Pool Name:
SELECT VolumeName AS VolName,MediaID AS ID,Pool.Name AS Pool,MediaType AS
Type,VolStatus AS Status,VolErrors AS Errs,Media.LastWritten AS LastWritten,
FROM_UNIXTIME(
UNIX_TIMESTAMP(Media.LastWritten)
+ (Media.VolRetention)
) AS Expires
FROM Media,Pool,Storage
WHERE Media.PoolId=Pool.PoolId
AND Media.StorageId=Storage.StorageId
AND Pool.Name='%1'
ORDER BY VolumeName;
====================================================================
----
Mark Bergman [EMAIL PROTECTED]
System Administrator
Section of Biomedical Image Analysis 215-662-7310
Department of Radiology, University of Pennsylvania
http://pgpkeys.pca.dfn.de:11371/pks/lookup?search=mark.bergman%40.uphs.upenn.edu
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
