by being separate groups.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of stg
admin
Sent: Thursday, September 17, 2009 2:00 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SELECT FOR DISTINCT VOLUMES IN A COLLOCATION GROUP
Does anyone have a script t
> 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. Moe
Does anyone have a script that will show the volumes associated with a
collocation group?
I'm trying to run this but receive an error;
select distinct vu.volume_name, cg.collocgroup_name from volumeusage vu,
collocgroup cg where vu.node_name=cg.node_name and vu.stgpool_name='DRMC'
group by cg.col
