Try:

select node_name, count (*) from volumeusage group by node_name

or for a little different results try,

select volume_name from volumeusage where node_name='node'


Joshua S. Bassi
Storage Management Team Lead
AIX / ADSM Certified Specialist
Dickens Services Group
(404) 386-9848
jbassi AT gloryworks DOT com
www.TeamDSG.com