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