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! Node Name Filespace FSID Platform Filespace Is Capacity Pct Name Type Filespace (MB) Util Unicode? --------------- ----------- ---- -------- --------- --------- -------- ----- FJSU101 / 1 SUN UFS No 4,035.0 30.2 SOLARIS FJSU101 /var 2 SUN UFS No 4,035.0 14.3 SOLARIS FJSU101 /var/run 3 SUN TMPFS No 22,303.0 0.0 SOLARIS FJSU101 /opt 4 SUN UFS No 6,050.5 12.6 SOLARIS FJSU101 /p01 5 SUN VxFS No 45,719.5 40.2 SOLARIS FJSU101 /p03 6 SUN VxFS No 30,506.3 21.7 SOLARIS FJSU101 /export/ho- 7 SUN UFS No 8,089.7 30.4 me SOLARIS FJSU101 /u01/app/o- 8 SUN VxFS No 45,719.5 40.4 racle SOLARIS FJSU101 /p02 9 SUN VxFS No 45,661.4 26.7 SOLARIS FJSU101 /tmp 10 SUN TMPFS No 22,831.9 0.0 SOLARIS ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ********************************