Re: Tapes per Node
1999-08-03 10:50:46
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
|
|
|