Re: SHOW VOLUMEUSAGE <node>
1999-12-21 13:35:19
That's what the SQL Query was designed to do... I use it to generate a
report for chargeback.
If you want to see the volume numbers then just alter the query.
select distinct volume_name,node_name from volumeusage
should work
-----Original Message-----
From: Michael Dummitt [SMTP:Michael.Dummitt AT ROSSNUTRITION DOT COM]
Sent: Tuesday, December 21, 1999 12:25 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SHOW VOLUMEUSAGE <node>
Well I tried this command and I recvd the below output. I still do
not know
which volumes....it just tellsme how many. Any more hints? The would
be
appreciated.
adsm> select node_name as aixs70a,count(distinct volume_name) as
"Number of tap
es used" from volumeusage group by node_name
ANR2963W This SQL query may produce a very large result table, or
may require a
significant amount of time to compute.
Do you wish to proceed? (Yes/No) y
AIXS70A Number of tapes used
------------------ --------------------
ADSMRS 58
AF_REMOTE 2
AIX01 94
AIX02 56
AIX03 95
AIX07 75
AIX08 51
AIX0A 41
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SHOW VOLUMEUSAGE <node>, Medico, Frederic
- Re: SHOW VOLUMEUSAGE <node>, Frederic Landreville
- Re: SHOW VOLUMEUSAGE <node>, Michael Dummitt
- Re: SHOW VOLUMEUSAGE <node>, Nathan King
- Re: SHOW VOLUMEUSAGE <node>, Michael Dummitt
- Re: SHOW VOLUMEUSAGE <node>,
Nathan King <=
- Re: SHOW VOLUMEUSAGE <node>, Joerg Pohlmann
- Re: SHOW VOLUMEUSAGE <node>, Mark Mooney
- Re: SHOW VOLUMEUSAGE <node>, Joshua S. Bassi
- Re: SHOW VOLUMEUSAGE <node>, Michael Dummitt
- SHOW VOLUMEUSAGE <node>, Medico, Frederic
- Re: SHOW VOLUMEUSAGE <node>, ADSM : Dist Stor Manager [mailto:ADSM-L
|
|
|