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 this:

  select stgpool_name, cast((est_capacity_mb*pct_utilized/100) -
    as decimal(16,2)) as "UTILIZED_MB" from stgpools

=Dave (not a big dog)


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of Cheung, Richard
> Sent: Monday, November 10, 2008 10:55 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] command to query how much data is stored
>
> What is the command to show how much data is currently stored in a
> storage pool - eg tapepool?  Not for any specific individual nodes -
> just at a pure 'how much data is in a storage pool' level?


--
Hello World.                                    David Bronder - Systems Admin
Segmentation Fault                                     ITS-SPA, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bronder AT uiowa 
DOT edu