select distinct(volume_name) from volumeusage where
node_name='YOUR-NODENAME-GOES-HERE'






David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/15/03 12:40 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: To Collate or Not to Collate? - UPDATE


> Since then I've been
>able to put an SQL query together to get that info but it takes quite
a
>while to execute.

Can you share that code with us?

David