Kelly Lipp wrote:
Now the big dogs will weigh in with the perfect 300 character SQL
select statement with it summarized, etc, but this will get you
started.
It sounded more to me like Richard is looking for query stgpool... :)
Well, if he doesn't want to do the math by hand, something like
How about 'select sum(physical_mb) from occupancy where
stgpool_name='TAPEPOOL'?
On Tue, Nov 11, 2008 at 3:01 AM, David Bronder [EMAIL PROTECTED]wrote:
Kelly Lipp wrote:
Now the big dogs will weigh in with the perfect 300 character SQL
select statement with it summarized, etc, but this
I see it's been about a day, and I'd hate for you to be disappointed,
Kelly, so here goes.
select stgpool_name, sum(est_capacity_mb*pct_utilized/100) from volumes
group by stgpool_name
OK, so it's short by about 200 characters -- I'll just have to try
harder next time. :o)
disclaimer: I
Tsm audit license
Tsm query auditocc pooltype=primary
Will show all nodes capacity in the primary storage pools.
I think query auditocc pooltype=primary node=nodename or perhaps q auditocc
nodename pooltype=primary will do it as well.
Now the big dogs will weigh in with the perfect 300