Thank you Ian! That is exactly what I had been looking for! ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ********************************
"Ian Hobbs" <[EMAIL PROTECTED] GERS.COM> To Sent by: "ADSM: [EMAIL PROTECTED] Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> Re: Select statement 09/28/2004 03:05 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> Per node select node_name, sum((capacity*pct_util/100)) as "USED_MB", sum(capacity) as "AVAIL_MB" from filespaces group by node_name Per server select sum((capacity*pct_util/100)) as "USED_MB", sum(capacity) as "AVAIL_MB" from filespaces On Tue, 28 Sep 2004 14:38:03 -0400, Joni Moyer wrote: >Hello All! > >I am sorry to bother you about a select statement that I am sure is out on >the adsm.org site, but I have just been denied by our filtering system and >I'm not quite sure when it will be taken off... > >What I would like to do is somehow create a select statement that will >query the filesystems of each server and figure out the total amount of >space used/server and also the total capacity available per server. If >this is possible, could someone please let me know? Thank you in advance! Ian Hobbs [EMAIL PROTECTED] ======================================================= "Never argue with an idiot. They drag you down to their level then beat you with experience." -Dilbert