select distinct volume_name,node_name,stgpool_name from volumeusage where not 
stgpool_name='OFFSITEVOLS'

Just change this to filter out your copypool. In our case the copypool name is 
OFFSITEVOLS. This is a good way to verify how well co-location is working in 
your storage pool.

Larry Clark
NYS Thruway Authority


>>> GEOFFREY.L.GILL AT SAIC DOT COM 05/11/00 01:22PM >>>
Is there a query that will show me what tape numbers a specific node has
files spaces on? One user seems to have a need to know exactly what tapes he
has files on.

Thanks,
Geoff Gill
NT Systems Support Engineer
Computer Systems Group
E-Mail:   gillg AT saic DOT com 
Phone:  (858) 826-4062
Pager:   (888) 997-9614