Hi Werner Here's one that shows volumes by filespacename and stgpool name
select distinct node_name,volume_name,stgpool_name from volumeusage where node_name='$1' and filespace_name='$2' and stgpool_name<>'$3' Laura Buckley SSSI/STORServer, Inc. [EMAIL PROTECTED] -----Original Message----- From: Werner Baur [mailto:[EMAIL PROTECTED]] Sent: 03 January 2003 09:33 To: [EMAIL PROTECTED] Subject: On which volumes are my files? Does anyone know a fast way to get a list of all volumes on which a node has files of a specific subdirectory? A query of the volumeusage table does the job on filespace level but not on file/directory level. The only way I know is to search in the output of query content or the corresponding select query which is very slow. Thanks for any ideas, Werner -- Werner Baur Tel.:++49-89-28928781 Leibniz-Rechenzentrum Fax:++49-89-2809460 Barer Str. 21 mailto:[EMAIL PROTECTED] D-80333 Muenchen, Germany http://www.lrz.de