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 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:[EMAIL PROTECTED] On Behalf Of > Cheung, Richard > > Sent: Monday, November 10, 2008 10:55 PM > > To: ADSM-L@VM.MARIST.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. > [EMAIL PROTECTED] >