script to capture certain output

fara_aris · August 13, 2008, 8:33pm

Hi All,
I want to create a script that capture only Date & Time, Current CPU % usage, Disk % usage, Mem % usage and Top process based on this output;

Data Collected: 05/17/08 17:19:49

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 08:19:45
B3692A GlancePlus C.03.72.00 17:29:49 UXAMSK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSUUUUU | 16% 9% 22%
Disk Util F | 1% 5% 12%
Mem Util SSSSSSSSSSUUUUUUUUBBBBB | 46% 45% 46%
Swap Util UUUURRRRR | 17% 16% 17%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 8
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 24.8/ 25.1 0.5/ 0.5
2 /stand /dev/vg00/lvol1 hfs 0.0/ 0.0 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 0.2/ 0.3 1.9/ 2.1
4 /usr /dev/vg00/lvol7 vxfs 35.2/ 17.7 0.9/ 0.7
5 /tmp /dev/vg00/lvol4 vxfs 0.0/ 0.0 0.0/ 0.0
6 /opt /dev/vg00/lvol6 vxfs 40.2/ 40.2 0.9/ 1.0
7 /nsm /dev/vg00/lvol10 vxfs 0.5/ 0.6 0.4/ 0.3
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /app/oracle9i /dev/vg00/lvol9 vxfs 0.0/ 0.0 0.0/ 0.0
10 /BTM/aramis /dev/vgaramis/lvol1 vxfs 1092/674.8 30.8/ 91.1
11 /BTB/aramis /dev/vgbtb/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
12 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 11053, s_server 10.0 IOs/sec S - Select a Disk

Any advise?

bakunin · August 13, 2008, 8:48pm

Supposing the presented text is stored in /some/file:

sed -n '1p;8,10 {;s/^\([^ ]*\) [^0-9]*\([0-9]*%\).*$/\1 \2/p;};$p' /some/file

I hope this helps.

bakunin

fara_aris · August 13, 2008, 8:58pm

Hi bakunin,
I've tested the script, and this is the output that I received;

B3692A GlancePlus C.03.72.00 08:19:46 UXAMSK01 9000/800 Current Avg High

I want the output to be like this;

Data Collected: 05/17/08 17:19:49
UXAMSK01 Current
-------------------------------------------------------------------------------
CPU 16%
Disk 1%
Mem 46%

Top disk user: PID 11053, s_server 10.0 IOs/sec S - Select a Disk

Is it possible?

bakunin · August 14, 2008, 6:07am

Hm, i have tried the script with the following file, on which it does (almost - the "...Current..."-line is missing) exactly that:

Data Collected: 05/17/08 17:19:49

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 08:19:45
B3692A GlancePlus C.03.72.00 17:29:49 UXAMSK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSUUUUU | 16% 9% 22%
Disk Util F | 1% 5% 12%
Mem Util SSSSSSSSSSUUUUUUUUBBBBB | 46% 45% 46%
Swap Util UUUURRRRR | 17% 16% 17%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 8
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 24.8/ 25.1 0.5/ 0.5
2 /stand /dev/vg00/lvol1 hfs 0.0/ 0.0 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 0.2/ 0.3 1.9/ 2.1
4 /usr /dev/vg00/lvol7 vxfs 35.2/ 17.7 0.9/ 0.7
5 /tmp /dev/vg00/lvol4 vxfs 0.0/ 0.0 0.0/ 0.0
6 /opt /dev/vg00/lvol6 vxfs 40.2/ 40.2 0.9/ 1.0
7 /nsm /dev/vg00/lvol10 vxfs 0.5/ 0.6 0.4/ 0.3
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /app/oracle9i /dev/vg00/lvol9 vxfs 0.0/ 0.0 0.0/ 0.0
10 /BTM/aramis /dev/vgaramis/lvol1 vxfs 1092/674.8 30.8/ 91.1
11 /BTB/aramis /dev/vgbtb/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
12 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 11053, s_server 10.0 IOs/sec S - Select a Disk <end-of-file>

bakunin

broli · August 14, 2008, 8:45am

with awk it would be easier

awk 'NR==8 { print $5 } \
NR==9 { print $5 }\
NR==10 { print $5 }' datafile

acomplish the first part ....

fara_aris · August 14, 2008, 8:16pm

bakunin,
i've managed to get the output that i desired using the script that you've given, but now i'm facing another problem. the output file (/some/file) is not static, it has more output, because it has 600 seconds interval. so in one output file, i can have more entries like the one i've shown below.

so how to make the script to capture (time, cpu/disk/mem-current and top process) and direct it into one file (e.g output.out)?

which means, when i run the script, e.g:
sed -n '1p;8,10 {;s/^$[^ ]$ [^0-9]*$[0-9]*%$.$/\1 \2/p;};$p' /home/fara/AMSK01_glance.out_20080517
i want to get output.out that looks like this;

Data Collected: 05/17/08 17:19:49
UXAMSK01 Current
-------------------------------------------------------------------------------
CPU 16%
Disk 1%
Mem 46%

Top disk user: PID 11053, s_server 10.0 IOs/sec S - Select a Disk

Data Collected: 05/17/08 17:29:49
UXAMSK01 Current
-------------------------------------------------------------------------------
CPU 16%
Disk 1%
Mem 46%

Top disk user: PID 11053, s_server 10.0 IOs/sec S - Select a Disk

Data Collected: 05/17/08 17:39:49
UXAMSK01 Current
-------------------------------------------------------------------------------
CPU 16%
Disk 1%
Mem 46%

Top disk user: PID 11053, s_server 10.0 IOs/sec S - Select a Disk

(etc)

Sorry if it's troublesome..

fara_aris · August 14, 2008, 8:17pm

broli,
i don't understand what you mean.. kindly explain..

thanks

vidyadhar85 · August 14, 2008, 8:23pm

it means he is taking 8th 9th and 10th lines of the o/p and printing 5th field of each line

Annihilannic · August 14, 2008, 8:25pm

Try this:

awk '
        /Collected/
        /B3692A/ { print $5, $7; getline; print }
        /^(CPU|Disk|Mem) Util/ { print $1, $5 }
        /Top disk user/ { print "" ; print; print "" }
' inputfile

vidyadhar85 · August 14, 2008, 8:37pm

try this
awk 'NR==1{print $0}\
NR==6{printf "%s %s\n",$5,$7}\
NR==7{print $0}\
NR==8 {printf "%s %s\n",$1,$5}\
NR==9 {printf "%s %s\n",$1,$5}\
NR==10{printf "%s %s\n",$1,$5}' inputfile >> outputfile

fara_aris · August 14, 2008, 9:33pm

i've tried both methods;

1)
[UXHUBT01:fara]/home/support/fara#cat test3.sh
awk '
/home/support/fara/output.out
/B3692A/ { print $5, $7; getline; print }
/^(CPU|Disk|Mem) Util/ { print $1, $5 }
/Top disk user/ { print "" ; print; print "" }
' /home/support/fara/HUBK01_glance.out

[UXHUBT01:fara]/home/support/fara#
[UXHUBT01:fara]/home/support/fara#./test3.sh
syntax error The source line is 2.
The error context is
>>> /home/support/fara/output. <<< out
awk: Quitting
The source line is 2.

2)
[UXHUBT01:fara]/home/support/fara#cat test4.sh
awk 'NR==1{print $0}\
NR==6{printf "%s %s\n",$5,$7}\
NR==7{print $0}\
NR==8 {printf "%s %s\n",$1,$5}\
NR==9 {printf "%s %s\n",$1,$5}\
NR==10{printf "%s %s\n",$1,$5}' /home/support/fara/HUBK01_glance.out >>/home/support/fara/output.out

[UXHUBT01:fara]/home/support/fara#cat output.out
B3692A GlancePlus C.03.72.00 15:02:45 UXHUBK01 9000/800 Current Avg High
32% 32%
--------------------------------------------------------------------------
IO Users=
Idx Type

Any advise?

vidyadhar85 · August 14, 2008, 9:43pm

plz provide the exact HUBK01_glance.out file.. because the file what you provided gives the expected o/p with our codes...

fara_aris · August 14, 2008, 9:56pm

vidyadhar85,
this is only half of it..

B3692A GlancePlus C.03.72.00 ----------------------------------------- CPU Util SSSSSSSSSSSSSNNNNNNAUUUU Disk Util F Mem Util SSSSSSSSUUUUUUUUUUUUBBBBB Swap Util UUUURRRRRRRRRRRRR ----------------------------------------- IO BY FILE SYSTEM Idx File System Device ----------------------------------------- 1 / /dev/vg00/lvol3 2 /stand /dev/vg00/lvol1 3 /var /dev/vg00/lvol8 4 /usr /dev/vg00/lvol7 5 /tmp /dev/vg00/lvol4 6 /oracle /dev/vg00/lvol10 7 /opt /dev/vg00/lvol6 8 /home /dev/vg00/lvol5 9 /IA_FBMI /dev/vg00/fbmi 10 swap device /dev/vg00/lvol2 11 swap device /dev/vg00/lvol9 12 /DIFF_appli /dev/vg04/lvol1 13 /DIFFBTM_appli /dev/vg04/lvol2 14 /HUB_appli /dev/vg03/lvol1 15 /HUB_data /dev/vg03/lvol2 16 /HUB_log /dev/vg03/lvol3 17 /HUBBTM_appli /dev/vg03/lvol4 18 /HUBBTM_log /dev/vg03/lvol5 19 /HUBBTM_data /dev/vg03/lvol6 20 /HSTBTM_appli /dev/vg03/lvol7 21 /oracle9i/client /dev/vg03/lvol8 22 /HST_appli /dev/vg05/lvol1 15:02:45 UXHUBK01 9000/800 Current Avg High
--------------------------------------
| 50% 50% 50%
| 1% 1% 1%
| 49% 49% 49%
| 32% 32% 32%
--------------------------------------
Users= 10
Type Logl IO Phys IO
---------------------------------------
vxfs 114.2/114.2 2.8/ 2.8
hfs 8.5/ 8.5 0.0/ 0.0
vxfs 10.0/ 10.0 0.0/ 0.0
vxfs 1749/ 1749 0.0/ 0.0
vxfs 0.0/ 0.0 0.0/ 0.0
vxfs 0.0/ 0.0 0.0/ 0.0
vxfs 4.2/ 4.2 0.0/ 0.0
vxfs 0.0/ 0.0 0.0/ 0.0
vxfs 0.0/ 0.0 0.0/ 0.0
hfs 0.0/ 0.0 0.0/ 0.0
hfs 0.0/ 0.0 0.0/ 0.0
vxfs 0.0/ 0.0 0.0/ 0.0
vxfs 97.1/ 97.1 7.1/ 7.1
vxfs 0.0/ 0.0 0.0/ 0.0
vxfs 0.0/ 0.0 0.0/ 0.0
vxfs 0.0/ 0.0 0.0/ 0.0
vxfs 0.0/ 0.0 0.0/ 0.0
vxfs 3.5/ 3.5 6.4/ 6.4
vxfs 79.2/ 79.2 32.8/ 32.8
vxfs 1.4/ 1.4 3.5/ 3.5
vxfs 0.0/ 0.0 0.0/ 0.0
vxfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 24728, hublogd 14.2 IOs/sec S - Select a Disk
Page 1 of 1

Data Collected: 05/17/08 15:02:45

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 15:02:44
B3692A GlancePlus C.03.72.00 15:12:45 UXHUBK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSSSSSSSSSSSSNNNNNAUUUU | 47% 47% 50%
Disk Util F | 3% 2% 3%
Mem Util SSSSSSSSUUUUUUUUUUUUBBBBB | 49% 49% 49%
Swap Util UUUURRRRRRRRRRRRR | 32% 32% 32%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 10
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 24.5/ 24.8 1.5/ 1.5
2 /stand /dev/vg00/lvol1 hfs 1.1/ 1.1 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 4.7/ 4.7 3.8/ 3.7
4 /usr /dev/vg00/lvol7 vxfs 1819/ 1819 1.9/ 1.9
5 /tmp /dev/vg00/lvol4 vxfs 0.0/ 0.0 0.1/ 0.1
6 /oracle /dev/vg00/lvol10 vxfs 0.0/ 0.0 0.0/ 0.0
7 /opt /dev/vg00/lvol6 vxfs 144.5/144.1 0.2/ 0.2
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /IA_FBMI /dev/vg00/fbmi vxfs 0.0/ 0.0 0.0/ 0.0
10 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0
11 swap device /dev/vg00/lvol9 hfs 0.0/ 0.0 0.0/ 0.0
12 /DIFF_appli /dev/vg04/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
13 /DIFFBTM_appli /dev/vg04/lvol2 vxfs 59.1/ 59.2 7.9/ 7.9
14 /HUB_appli /dev/vg03/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
15 /HUB_data /dev/vg03/lvol2 vxfs 0.0/ 0.0 0.0/ 0.0
16 /HUB_log /dev/vg03/lvol3 vxfs 0.0/ 0.0 0.0/ 0.0
17 /HUBBTM_appli /dev/vg03/lvol4 vxfs 0.4/ 0.4 0.0/ 0.0
18 /HUBBTM_log /dev/vg03/lvol5 vxfs 5.1/ 5.1 4.5/ 4.5
19 /HUBBTM_data /dev/vg03/lvol6 vxfs 3323/ 3315 64.8/ 64.7
20 /HSTBTM_appli /dev/vg03/lvol7 vxfs 1.2/ 1.2 2.2/ 2.2
21 /oracle9i/client /dev/vg03/lvol8 vxfs 1.2/ 1.1 0.0/ 0.0
22 /HST_appli /dev/vg05/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 25712, hub_masterd 16.2 IOs/sec S - Select a Disk
Page 1 of 1

Data Collected: 05/17/08 15:12:45

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 15:02:44
B3692A GlancePlus C.03.72.00 15:22:46 UXHUBK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSSSSSSSSSSSNNNNNAUUUU | 44% 46% 50%
Disk Util F | 2% 2% 3%
Mem Util SSSSSSSSUUUUUUUUUUUUBBBBB | 49% 49% 49%
Swap Util UUUURRRRRRRRRRRRR | 32% 32% 32%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 9
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 22.2/ 23.5 1.5/ 1.5
2 /stand /dev/vg00/lvol1 hfs 1.1/ 1.1 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 4.3/ 4.5 3.4/ 3.6
4 /usr /dev/vg00/lvol7 vxfs 1835/ 1827 1.7/ 1.8
5 /tmp /dev/vg00/lvol4 vxfs 0.0/ 0.0 0.1/ 0.1
6 /oracle /dev/vg00/lvol10 vxfs 0.0/ 0.0 0.0/ 0.0
7 /opt /dev/vg00/lvol6 vxfs 96.3/120.2 0.1/ 0.1
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /IA_FBMI /dev/vg00/fbmi vxfs 0.0/ 0.0 0.0/ 0.0
10 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0
11 swap device /dev/vg00/lvol9 hfs 0.0/ 0.0 0.0/ 0.0
12 /DIFF_appli /dev/vg04/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
13 /DIFFBTM_appli /dev/vg04/lvol2 vxfs 50.3/ 54.8 7.6/ 7.8
14 /HUB_appli /dev/vg03/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
15 /HUB_data /dev/vg03/lvol2 vxfs 0.0/ 0.0 0.0/ 0.0
16 /HUB_log /dev/vg03/lvol3 vxfs 0.0/ 0.0 0.0/ 0.0
17 /HUBBTM_appli /dev/vg03/lvol4 vxfs 0.4/ 0.4 0.0/ 0.0
18 /HUBBTM_log /dev/vg03/lvol5 vxfs 3.2/ 4.1 4.5/ 4.5
19 /HUBBTM_data /dev/vg03/lvol6 vxfs 64.3/ 1689 45.9/ 55.3
20 /HSTBTM_appli /dev/vg03/lvol7 vxfs 1.1/ 1.2 2.2/ 2.2
21 /oracle9i/client /dev/vg03/lvol8 vxfs 1.4/ 1.3 0.0/ 0.0
22 /HST_appli /dev/vg05/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 25712, hub_masterd 17.2 IOs/sec S - Select a Disk
Page 1 of 1

Data Collected: 05/17/08 15:22:46

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 15:02:44
B3692A GlancePlus C.03.72.00 15:32:48 UXHUBK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSSSSSSSSSSSNNNNNAUUUU | 45% 45% 50%
Disk Util F | 2% 2% 3%
Mem Util SSSSSSSSUUUUUUUUUUUUBBBBB | 49% 49% 49%
Swap Util UUUURRRRRRRRRRRRR | 32% 32% 32%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 9
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 22.2/ 23.1 1.5/ 1.5
2 /stand /dev/vg00/lvol1 hfs 1.1/ 1.1 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 4.7/ 4.6 3.5/ 3.5
4 /usr /dev/vg00/lvol7 vxfs 1834/ 1829 1.6/ 1.7
5 /tmp /dev/vg00/lvol4 vxfs 0.0/ 0.0 0.0/ 0.1
6 /oracle /dev/vg00/lvol10 vxfs 0.0/ 0.0 0.0/ 0.0
7 /opt /dev/vg00/lvol6 vxfs 144.1/128.2 0.1/ 0.1
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /IA_FBMI /dev/vg00/fbmi vxfs 0.0/ 0.0 0.0/ 0.0
10 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0
11 swap device /dev/vg00/lvol9 hfs 0.0/ 0.0 0.0/ 0.0
12 /DIFF_appli /dev/vg04/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
13 /DIFFBTM_appli /dev/vg04/lvol2 vxfs 49.3/ 52.9 7.7/ 7.7
14 /HUB_appli /dev/vg03/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
15 /HUB_data /dev/vg03/lvol2 vxfs 0.0/ 0.0 0.0/ 0.0
16 /HUB_log /dev/vg03/lvol3 vxfs 0.0/ 0.0 0.0/ 0.0
17 /HUBBTM_appli /dev/vg03/lvol4 vxfs 0.4/ 0.4 0.0/ 0.0
18 /HUBBTM_log /dev/vg03/lvol5 vxfs 3.2/ 3.8 4.5/ 4.5
19 /HUBBTM_data /dev/vg03/lvol6 vxfs 64.0/ 1148 45.7/ 52.1
20 /HSTBTM_appli /dev/vg03/lvol7 vxfs 1.2/ 1.2 2.2/ 2.2
21 /oracle9i/client /dev/vg03/lvol8 vxfs 1.1/ 1.2 0.0/ 0.0
22 /HST_appli /dev/vg05/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 25712, hub_masterd 16.3 IOs/sec S - Select a Disk
Page 1 of 1

Data Collected: 05/17/08 15:32:48

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 15:02:44
B3692A GlancePlus C.03.72.00 15:42:49 UXHUBK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSSSSSSSSSSSSNNNNNNNNAUUUU | 52% 47% 52%
Disk Util F | 3% 2% 3%
Mem Util SSSSSSSSUUUUUUUUUUUUBBBBB | 49% 49% 49%
Swap Util UUUURRRRRRRRRRRRR | 32% 32% 32%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 9
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 27.1/ 24.1 1.6/ 1.5
2 /stand /dev/vg00/lvol1 hfs 1.1/ 1.1 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 4.0/ 4.4 4.1/ 3.7
4 /usr /dev/vg00/lvol7 vxfs 1723/ 1803 1.9/ 1.8
5 /tmp /dev/vg00/lvol4 vxfs 1.2/ 0.3 0.3/ 0.1
6 /oracle /dev/vg00/lvol10 vxfs 0.0/ 0.0 0.0/ 0.0
7 /opt /dev/vg00/lvol6 vxfs 68.6/113.3 0.1/ 0.1
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /IA_FBMI /dev/vg00/fbmi vxfs 0.0/ 0.0 0.0/ 0.0
10 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0
11 swap device /dev/vg00/lvol9 hfs 0.0/ 0.0 0.0/ 0.0
12 /DIFF_appli /dev/vg04/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
13 /DIFFBTM_appli /dev/vg04/lvol2 vxfs 228.2/ 96.7 8.7/ 8.0
14 /HUB_appli /dev/vg03/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
15 /HUB_data /dev/vg03/lvol2 vxfs 0.0/ 0.0 0.0/ 0.0
16 /HUB_log /dev/vg03/lvol3 vxfs 0.0/ 0.0 0.0/ 0.0
17 /HUBBTM_appli /dev/vg03/lvol4 vxfs 0.4/ 0.4 0.0/ 0.0
18 /HUBBTM_log /dev/vg03/lvol5 vxfs 62.6/ 18.5 9.8/ 5.8
19 /HUBBTM_data /dev/vg03/lvol6 vxfs 539.5/995.7 89.7/ 61.5
20 /HSTBTM_appli /dev/vg03/lvol7 vxfs 2.8/ 1.6 2.6/ 2.3
21 /oracle9i/client /dev/vg03/lvol8 vxfs 1.2/ 1.2 0.0/ 0.0
22 /HST_appli /dev/vg05/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 25712, hub_masterd 20.3 IOs/sec S - Select a Disk
Page 1 of 1

Data Collected: 05/17/08 15:42:49

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 15:02:44
B3692A GlancePlus C.03.72.00 15:52:50 UXHUBK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSSSSSSSSSSSSNNNNNNNNNNARUUUU | 57% 49% 57%
Disk Util FFV | 5% 3% 5%
Mem Util SSSSSSSSUUUUUUUUUUUUBBBBB | 49% 49% 49%
Swap Util UUUURRRRRRRRRRRRR | 32% 32% 32%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 9
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 23.4/ 23.9 1.6/ 1.5
2 /stand /dev/vg00/lvol1 hfs 1.1/ 1.1 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 5.5/ 4.7 4.4/ 3.8
4 /usr /dev/vg00/lvol7 vxfs 1698/ 1782 2.0/ 1.8
5 /tmp /dev/vg00/lvol4 vxfs 4.2/ 1.1 0.4/ 0.2
6 /oracle /dev/vg00/lvol10 vxfs 0.0/ 0.0 0.0/ 0.0
7 /opt /dev/vg00/lvol6 vxfs 203.3/131.3 0.2/ 0.1
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /IA_FBMI /dev/vg00/fbmi vxfs 0.0/ 0.0 0.1/ 0.0
10 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0
11 swap device /dev/vg00/lvol9 hfs 0.0/ 0.0 0.0/ 0.0
12 /DIFF_appli /dev/vg04/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
13 /DIFFBTM_appli /dev/vg04/lvol2 vxfs 261.2/129.6 9.0/ 8.2
14 /HUB_appli /dev/vg03/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
15 /HUB_data /dev/vg03/lvol2 vxfs 0.0/ 0.0 0.0/ 0.0
16 /HUB_log /dev/vg03/lvol3 vxfs 0.0/ 0.0 0.0/ 0.0
17 /HUBBTM_appli /dev/vg03/lvol4 vxfs 0.5/ 0.4 0.0/ 0.0
18 /HUBBTM_log /dev/vg03/lvol5 vxfs 59.6/ 26.7 12.5/ 7.2
19 /HUBBTM_data /dev/vg03/lvol6 vxfs 631.7/922.9 113.7/ 71.9
20 /HSTBTM_appli /dev/vg03/lvol7 vxfs 2.8/ 1.8 2.8/ 2.4
21 /oracle9i/client /dev/vg03/lvol8 vxfs 1.2/ 1.2 0.0/ 0.0
22 /HST_appli /dev/vg05/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 25712, hub_masterd 20.3 IOs/sec S - Select a Disk
Page 1 of 1

Data Collected: 05/17/08 15:52:50

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 15:02:44
B3692A GlancePlus C.03.72.00 16:02:51 UXHUBK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSSSSSSSSSSSSSNNNNNNNNNNNRUUUUU | 61% 51% 61%
Disk Util FFFV | 8% 4% 8%
Mem Util SSSSSSSSUUUUUUUUUUUUBBBBB | 49% 49% 49%
Swap Util UUUURRRRRRRRRRRR | 32% 32% 32%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 9
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 18.3/ 23.0 1.4/ 1.5
2 /stand /dev/vg00/lvol1 hfs 1.1/ 1.1 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 1084/184.4 72.6/ 15.3
4 /usr /dev/vg00/lvol7 vxfs 1675/ 1764 1.9/ 1.8
5 /tmp /dev/vg00/lvol4 vxfs 0.0/ 0.9 0.0/ 0.2
6 /oracle /dev/vg00/lvol10 vxfs 0.0/ 0.0 0.0/ 0.0
7 /opt /dev/vg00/lvol6 vxfs 68.3/120.8 0.1/ 0.1
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /IA_FBMI /dev/vg00/fbmi vxfs 0.0/ 0.0 0.0/ 0.0
10 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0
11 swap device /dev/vg00/lvol9 hfs 0.0/ 0.0 0.0/ 0.0
12 /DIFF_appli /dev/vg04/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
13 /DIFFBTM_appli /dev/vg04/lvol2 vxfs 171.1/136.5 8.7/ 8.3
14 /HUB_appli /dev/vg03/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
15 /HUB_data /dev/vg03/lvol2 vxfs 0.0/ 0.0 0.0/ 0.0
16 /HUB_log /dev/vg03/lvol3 vxfs 0.0/ 0.0 0.0/ 0.0
17 /HUBBTM_appli /dev/vg03/lvol4 vxfs 0.4/ 0.4 0.0/ 0.0
18 /HUBBTM_log /dev/vg03/lvol5 vxfs 75.8/ 34.9 9.5/ 7.5
19 /HUBBTM_data /dev/vg03/lvol6 vxfs 3948/ 1427 125.8/ 80.9
20 /HSTBTM_appli /dev/vg03/lvol7 vxfs 2.3/ 1.9 2.7/ 2.5
21 /oracle9i/client /dev/vg03/lvol8 vxfs 1.2/ 1.2 0.0/ 0.0
22 /HST_appli /dev/vg05/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 2890, opcmsga 68.0 IOs/sec S - Select a Disk
Page 1 of 1

Data Collected: 05/17/08 16:02:51

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 15:02:44
B3692A GlancePlus C.03.72.00 16:12:52 UXHUBK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSSSSSSSSSSSSNNNNNNNNUUUU | 51% 51% 61%
Disk Util F | 3% 4% 8%
Mem Util SSSSSSSSUUUUUUUUUUUUBBBBB | 49% 49% 49%
Swap Util UUUURRRRRRRRRRRR | 31% 31% 32%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 8
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 16.5/ 22.1 1.5/ 1.5
2 /stand /dev/vg00/lvol1 hfs 1.1/ 1.1 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 4.8/158.8 3.9/ 13.7
4 /usr /dev/vg00/lvol7 vxfs 1782/ 1766 1.8/ 1.8
5 /tmp /dev/vg00/lvol4 vxfs 0.0/ 0.8 0.2/ 0.2
6 /oracle /dev/vg00/lvol10 vxfs 0.0/ 0.0 0.0/ 0.0
7 /opt /dev/vg00/lvol6 vxfs 144.2/124.1 0.2/ 0.1
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /IA_FBMI /dev/vg00/fbmi vxfs 0.0/ 0.0 0.0/ 0.0
10 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0
11 swap device /dev/vg00/lvol9 hfs 0.0/ 0.0 0.0/ 0.0
12 /DIFF_appli /dev/vg04/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
13 /DIFFBTM_appli /dev/vg04/lvol2 vxfs 105.8/132.1 8.4/ 8.3
14 /HUB_appli /dev/vg03/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
15 /HUB_data /dev/vg03/lvol2 vxfs 0.0/ 0.0 0.0/ 0.0
16 /HUB_log /dev/vg03/lvol3 vxfs 0.0/ 0.0 0.0/ 0.0
17 /HUBBTM_appli /dev/vg03/lvol4 vxfs 0.4/ 0.4 0.0/ 0.0
18 /HUBBTM_log /dev/vg03/lvol5 vxfs 3.7/ 30.4 5.0/ 7.2
19 /HUBBTM_data /dev/vg03/lvol6 vxfs 247.4/ 1259 74.2/ 80.0
20 /HSTBTM_appli /dev/vg03/lvol7 vxfs 1.3/ 1.8 2.5/ 2.5
21 /oracle9i/client /dev/vg03/lvol8 vxfs 1.1/ 1.2 0.0/ 0.0
22 /HST_appli /dev/vg05/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 25712, hub_masterd 17.8 IOs/sec S - Select a Disk
Page 1 of 1

Data Collected: 05/17/08 16:12:52

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 15:02:44
B3692A GlancePlus C.03.72.00 16:22:53 UXHUBK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSSSSSSSSSSSSNNNNNNNNNUUUU | 53% 51% 61%
Disk Util F | 4% 4% 8%
Mem Util SSSSSSSSUUUUUUUUUUUUBBBBB | 48% 49% 49%
Swap Util UUUURRRRRRRRRRRR | 31% 31% 32%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 8
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 15.1/ 21.2 1.5/ 1.5
2 /stand /dev/vg00/lvol1 hfs 1.1/ 1.1 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 4.4/139.5 3.8/ 12.4
4 /usr /dev/vg00/lvol7 vxfs 1779/ 1768 1.7/ 1.8
5 /tmp /dev/vg00/lvol4 vxfs 0.0/ 0.7 0.0/ 0.1
6 /oracle /dev/vg00/lvol10 vxfs 0.0/ 0.0 0.0/ 0.0
7 /opt /dev/vg00/lvol6 vxfs 96.4/120.7 0.1/ 0.1
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /IA_FBMI /dev/vg00/fbmi vxfs 0.0/ 0.0 0.0/ 0.0
10 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0
11 swap device /dev/vg00/lvol9 hfs 0.0/ 0.0 0.0/ 0.0
12 /DIFF_appli /dev/vg04/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
13 /DIFFBTM_appli /dev/vg04/lvol2 vxfs 102.9/128.5 8.4/ 8.3
14 /HUB_appli /dev/vg03/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
15 /HUB_data /dev/vg03/lvol2 vxfs 0.0/ 0.0 0.0/ 0.0
16 /HUB_log /dev/vg03/lvol3 vxfs 0.0/ 0.0 0.0/ 0.0
17 /HUBBTM_appli /dev/vg03/lvol4 vxfs 0.4/ 0.4 0.0/ 0.0
18 /HUBBTM_log /dev/vg03/lvol5 vxfs 57.5/ 33.8 14.8/ 8.1
19 /HUBBTM_data /dev/vg03/lvol6 vxfs 241.2/ 1131 71.0/ 78.8
20 /HSTBTM_appli /dev/vg03/lvol7 vxfs 1.3/ 1.8 2.3/ 2.4
21 /oracle9i/client /dev/vg03/lvol8 vxfs 1.5/ 1.2 0.0/ 0.0
22 /HST_appli /dev/vg05/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 25712, hub_masterd 17.7 IOs/sec S - Select a Disk
Page 1 of 1

Data Collected: 05/17/08 16:22:53

Refresh Interval: 600 seconds

GlancePlus Started/Reset: 05/17/08 15:02:44
B3692A GlancePlus C.03.72.00 16:32:54 UXHUBK01 9000/800 Current Avg High
-------------------------------------------------------------------------------
CPU Util SSSSSSSSSSSSSNNNNNNUUUU | 46% 51% 61%
Disk Util F | 3% 3% 8%
Mem Util SSSSSSSSUUUUUUUUUUUBBBBB | 48% 49% 49%
Swap Util UUUURRRRRRRRRRRR | 31% 31% 32%
-------------------------------------------------------------------------------
IO BY FILE SYSTEM Users= 8
Idx File System Device Type Logl IO Phys IO
--------------------------------------------------------------------------------
1 / /dev/vg00/lvol3 vxfs 15.2/ 20.5 1.5/ 1.5
2 /stand /dev/vg00/lvol1 hfs 1.1/ 1.1 0.0/ 0.0
3 /var /dev/vg00/lvol8 vxfs 4.7/124.5 3.6/ 11.4
4 /usr /dev/vg00/lvol7 vxfs 1806/ 1772 1.7/ 1.8
5 /tmp /dev/vg00/lvol4 vxfs 0.0/ 0.6 0.0/ 0.1
6 /oracle /dev/vg00/lvol10 vxfs 0.0/ 0.0 0.0/ 0.0
7 /opt /dev/vg00/lvol6 vxfs 144.1/123.3 0.1/ 0.1
8 /home /dev/vg00/lvol5 vxfs 0.0/ 0.0 0.0/ 0.0
9 /IA_FBMI /dev/vg00/fbmi vxfs 0.0/ 0.0 0.0/ 0.0
10 swap device /dev/vg00/lvol2 hfs 0.0/ 0.0 0.0/ 0.0
11 swap device /dev/vg00/lvol9 hfs 0.0/ 0.0 0.0/ 0.0
12 /DIFF_appli /dev/vg04/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
13 /DIFFBTM_appli /dev/vg04/lvol2 vxfs 85.0/123.6 8.3/ 8.3
14 /HUB_appli /dev/vg03/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0
15 /HUB_data /dev/vg03/lvol2 vxfs 0.0/ 0.0 0.0/ 0.0
16 /HUB_log /dev/vg03/lvol3 vxfs 0.0/ 0.0 0.0/ 0.0
17 /HUBBTM_appli /dev/vg03/lvol4 vxfs 0.4/ 0.4 0.0/ 0.0
18 /HUBBTM_log /dev/vg03/lvol5 vxfs 82.6/ 39.2 4.9/ 7.8
19 /HUBBTM_data /dev/vg03/lvol6 vxfs 194.0/ 1027 64.9/ 77.3
20 /HSTBTM_appli /dev/vg03/lvol7 vxfs 1.3/ 1.7 2.3/ 2.4
21 /oracle9i/client /dev/vg03/lvol8 vxfs 1.1/ 1.2 0.0/ 0.0
22 /HST_appli /dev/vg05/lvol1 vxfs 0.0/ 0.0 0.0/ 0.0

Top disk user: PID 25712, hub_masterd 17.1 IOs/sec S - Select a Disk
Page 1 of 1

Annihilannic · August 14, 2008, 10:14pm

The output file does not belong there. Put it at the end, e.g.

' /home/support/fara/HUBK01_glance.out > /home/support/fara/output.out

fara_aris · August 14, 2008, 10:32pm

Annihilannic,
thanks for your help.. from the output.out, only current disk % is displayed, there's no output for CPU and Mem..

[UXHUBT01:fara]/home/support/fara#pg output.out
UXHUBK01 Current
-------------------------------------------------------------------------------
Disk 1%

Top disk user: PID 24728, hublogd 14.2 IOs/sec S - Select a Disk

UXHUBK01 Current
-------------------------------------------------------------------------------
Disk 3%

Top disk user: PID 25712, hub_masterd 16.2 IOs/sec S - Select a Disk

UXHUBK01 Current
-------------------------------------------------------------------------------
Disk 2%

Top disk user: PID 25712, hub_masterd 17.2 IOs/sec S - Select a Disk

UXHUBK01 Current
-------------------------------------------------------------------------------
Disk 2%

Top disk user: PID 25712, hub_masterd 16.3 IOs/sec S - Select a Disk

UXHUBK01 Current
-------------------------------------------------------------------------------
Disk 3%

Top disk user: PID 25712, hub_masterd 20.3 IOs/sec S - Select a Disk

Annihilannic · August 14, 2008, 10:49pm

I suspect its because your glance output really looks like this:

B3692A Glance C.04.70.000       02:45:40 hostname 9000/800   Current  Avg  High
-------------------------------------------------------------------------------
CPU  Util   SSSSSARUUUUUUUUU                                  | 31%   31%   31%
Disk Util   FFFFFFFFFFFFFFFFFF                                | 35%   35%   35%
Mem  Util   SSSSSSUUUUUUUUUUUUUUUUUUUB                        | 52%   52%   52%
Swap Util   UUUUUUUUUUUUUUUUURRRRRRRRRR                       | 54%   54%   54%
-------------------------------------------------------------------------------
                                                                  IO BY FILE SYSTEM                                                       Users=   14
Idx   File System            Device               Type     Logl IO     Phys IO
--------------------------------------------------------------------------------
   1 /                       /dev/vg00/lvol4      vxfs    25.5/ 25.5   6.6/  6.6

Notice how there are two spaces between "CPU" and "Util"?

Change this line and it should fix it:

/^(CPU|Disk|Mem) +Util/ { print $1, $5 }

Annihilannic · August 14, 2008, 10:51pm

Moral of the story is... post sample data or code using [ code]code goes here[ /code] tags without the spaces)!

fara_aris · August 14, 2008, 11:02pm

Annihilannic,
it's working!

sorry i was not aware of the correct output since those were the output files that i was given. i'm more on aix, and this one is for hp-ux..

thank you very much

[UXHUBT01:fara]/home/support/fara#pg output.out
15:02:45 UXHUBK01 Current
-------------------------------------------------------------------------------
CPU 50%
Disk 1%
Mem 49%

Top disk user: PID 24728, hublogd 14.2 IOs/sec S - Select a Disk

fara_aris · August 14, 2008, 11:07pm

and to bakunin, broli and vidyadhar85,
thank you as well

script to capture certain output

[UXHUBT01:fara]/home/support/fara#cat output.out B3692A GlancePlus C.03.72.00 15:02:45 UXHUBK01 9000/800 Current Avg High 32% 32% -------------------------------------------------------------------------- IO Users= Idx Type

[UXHUBT01:fara]/home/support/fara#cat output.out
B3692A GlancePlus C.03.72.00 15:02:45 UXHUBK01 9000/800 Current Avg High
32% 32%
--------------------------------------------------------------------------
IO Users=
Idx Type