Re: restore times
1999-03-18 00:23:02
Yes! That's the ticket.
Here, then, is the complete query, embellished
with an order by so that the nodes with data
on the most volumes floats to the top. I have
split the query across multiple lines for readability.
I have tested this query on my systems and it
is getting the results I expect:
select node_name, count (distinct volume_name) as Numvols
from volumeusage where stgpool_name = 'TAPEPOOL'
group by node_name order by Numvols desc
Thanks to both Bill and Thomas!
John Sorensen
SSSI
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: restore times, (continued)
- Re: restore times, Prather, Wanda
- Re: restore times, Kelly J. Lipp
- Re: restore times, Mapes, Mark
- Re: restore times, Kelly J. Lipp
- Re: restore times, Joel Fuhrman
- Re: restore times, John M. Sorensen
- Re: restore times, Schauerte, Andrew (NM75)
- Re: restore times, Bill Colwell
- Re: restore times, John M. Sorensen
- Re: restore times, Thomas A. La Porte
- Re: restore times,
John M. Sorensen <=
- Re: restore times, Sheelagh Treweek
- Re: restore times, Herve Chibois
- Re: restore times, Michael Abel
- Re: restore times, Dusedau, Stefan
- Re: restore times, Dusedau, Stefan
- Re: restore times, Prather, Wanda
- Re: restore times, Bill Colwell
- restore times, Fluker , Tom R [mailto:Tom.Fluker
- Re: restore times, McAllister Craig-WCM033
- Re: restore times, Moir , Betsy
|
|
|