Hi:
This seems to do it by weeding out the copypool volumes:

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

Thanks,
Larry Clark
NYS Thruway

>>> dthorneycroft AT LACSD DOT ORG 04/25/00 11:25AM >>>
select distinct volume_name from volumeusage where node_name=<NODE> and
stgpool_name=<STGPOOL>

On Tuesday, April 25, 2000 8:11 AM, Lawrence Clark
[SMTP:Larry_Clark AT THRUWAY.STATE.NY DOT US] wrote:
> Hi:
>
> does anyone have a handy SELECT to identify volumes use by node in co-located
> storage pools?
>
> Larry Clark
> NYS Thruway Authority