you can try this ... it givec a lot more and it's useful i think

select
vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.volume_name
-
from volumeusage vu,volumes vo -
where vo.volume_name=vu.volume_name -
group by
vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.volume_name
-
order by vo.volume_name, -
vu.node_name,vu.copy_type,vo.pct_utilized


----- Original Message -----
From: "Norita binti Hassan" <ita AT POS.COM DOT MY>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Wednesday, March 09, 2005 11:51 AM
Subject: Volume sequence

Hi,

Is there any select statement that can display the volume sequence number
so
that I can list all the volumes in sequence that has been used by specific
node.

NORITA BINTI HASAN
Senior Programmer
Enterprise Systems Services
Information Communication Tech.Div
6th Floor, Pos Malaysia Berhad
50670 Kuala Lumpur

Tel : 03 - 22756638



Pos Malaysia Berhad is Malaysia's national postal company
Visit us online at www.pos.com.my

NOTICE
This message may contain privileged and/or confidential
information. If  you are  not the addressee  or authorised
to  receive this email, you must not use, copy,  disclose
or take any  action based  on this email. If you  have
received this  email in  error, please advise  the sender
immediately by  reply e-mail and delete  this message.
Pos Malaysia  Berhad takes  no responsibility  for  the
contents of this email.