Re: [ADSM-L] SELECT FOR DISTINCT VOLUMES IN A COLLOCATION GROUP
2009-09-17 17:14:43
> 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
|
|
|