ADSM-L

Select statement

2004-09-28 14:39:36
Subject: Select statement
From: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 28 Sep 2004 14:38:03 -0400
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
joni.moyer AT highmark DOT com
********************************

<Prev in Thread] Current Thread [Next in Thread>