ADSM-L

Re: [ADSM-L] SELECT FOR DISTINCT VOLUMES IN A COLLOCATION GROUP

2009-09-17 17:14:43
Subject: Re: [ADSM-L] SELECT FOR DISTINCT VOLUMES IN A COLLOCATION GROUP
From: Wolfgang J Moeller <moeller AT GWDG DOT DE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 17 Sep 2009 23:12:16 +0200
> Does anyone have a script that will show the volumes associated with a
> collocation group?

select distinct vv.volume_name from nodes nn, volumeusage vv -
 where nn.collocgroup_name=upper('$1') and vv.node_name=nn.node_name

You DON'T want to use the "collocgroup" table.

        Wolfgang J. Moeller @ GWDG Goettingen, Germany

<Prev in Thread] Current Thread [Next in Thread>