I use this to count files by client per tape:

select volume_name,node_name,count(file_name)
 as #files from contents where
 volume_name=upper('$1') group by
 volume_name,node_name

This lists client's files on a given tape:

select node_name,file_name as "File Name
                        " from contents where
 node_name=upper('$1') and
 volume_name=upper('$2')

Shouldn't be too hard to add filespace on either one.




At 11:23 AM 10/6/2003 -0700, you wrote:

Given a tape, is there a select query that will tell me what servers have
data on that particular tape? It'd be nice to know what file systems as well
but that level of granularity isn't necessary. I.e. I have tape XYZ, I run
query and find out CLIENTA, CLIENTB, and CLIENTC have data on it.


Gerald Wichmann
Manager, Systems Engineering
ZANTAZ, Inc.
925.598.3099 (w)



This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm)
service.  For more information, visit us at www.zantaz.com.
IMPORTANT: This electronic mail message is intended only for the use of the
individual or entity to which it is addressed and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law.  If the reader of this message is not the intended recipient, or the
employee or agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  If you have received
this communication in error, please notify the sender immediately by
telephone or directly reply to the original message(s) sent.  Thank you.