Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

finding greatest value in a column using awk from iostat output in linux

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting finding greatest value in a column using awk from iostat output in linux
# 1  
Old 03-02-2010
finding greatest value in a column using awk from iostat output in linux
Friends,
Need some help.
On linux i have to run iostat command and in each iteration have to print the greatest value in each column.

e.g

Code:
iostat -dt -kx 2 2 | awk ' !/sd[a-z][0-9]/ &&!/%util/ && !/Time/ && !/Linux/ {print $12}'

4.38
0.00

0.00
0.00

WHhat i would like to print is only the greatest value in each iteration. Can someone pls help me with this.
Last edited by Scott; 03-02-2010 at 11:50 AM.. Reason: Code tags
# 2  
Old 03-02-2010
Two things:

1.
Code:
iostat -dt -kx 2 2 | awk ' !/sd[a-z][0-9]/ &&!/%util/ && !/Time/ && !/Linux/ {print $12}' | sort | tail -1

2.
Code:
iostat -dt -kx 2 2 | awk ' !/sd[a-z][0-9]/ &&!/%util/ && !/Time/ && !/Linux/ {if(max < $12)max=$12}END{print max}'

cheers,
Devaraj Takhellambam
# 3  
Old 03-02-2010
Code:
iostat -dt -kx 2 2 | awk ' !/sd[a-z][0-9]/ &&!/%util/ && !/Time/ && !/Linux/ {print $12}' | awk 'BEGIN {max = 0.00} {if ($0>max) max=$0} END {print max}'

I hope this works, but i am not sure. Try it out and let me know.
# 4  
Old 03-02-2010
its not working. neither code is working. first one is print only 1 value at the end of all the iterations and so does code 2. but i need the values at the end of each iteration.
# 5  
Old 03-02-2010
Did you try this one... ???

Code:
iostat -dt -kx 2 2 | awk ' !/sd[a-z][0-9]/ &&!/%util/ && !/Time/ && !/Linux/ {print $12}' | awk 'BEGIN {max = 0.00} {if ($0>max) max=$0} END {print max}'

# 6  
Old 03-02-2010
Code:
iostat -dt -kx 2 2 | awk ' !/sd[a-z][0-9]/ &&!/%util/ && !/Time/ && !/Linux/ {print $12}' | 
awk 'BEGIN {max = 0.00} {if ($0>max) max=$0} END {print max}'

6.05

Last edited by Scott; 03-02-2010 at 11:51 AM.. Reason: Code tags
# 7  
Old 03-02-2010
Quote:
Originally Posted by achak01
iostat -dt -kx 2 2 | awk ' !/sd[a-z][0-9]/ &&!/%util/ && !/Time/ && !/Linux/ {print $12}' | awk 'BEGIN {max = 0.00} {if ($0>max) max=$0} END {print max}'

6.05
This fulfils your requirement rite ???
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Asvc_t values in iostat output

Noticed that asvc_t values in iostat command outputs are mostly more than 100 in our previous iostat analysis. Also found the following detail from an alternate site IO Bottleneck - Disk performance issue - UnixArena ---- 1. asvc_t average service time of active transactions, in... (2 Replies)
Discussion started by: saraperu
2 Replies

2. Shell Programming and Scripting

Take greatest value from second column

Dear All, Please help me, I have file input like this, 1 2142 215 2162 217 2842 285 2862 287 4002 401 4022 403 4822 1 2142 215 2162 217 2842 285 2862 287 4002 401 4022 403 4882 1 4801 (8 Replies)
Discussion started by: attila
8 Replies

3. Filesystems, Disks and Memory

iostat output vs TPC output (array layer)

Hi Guys, I've been having some arguments with my colleagues about one thing. Always my thought was that as as far as disk performance is concern by looking at the output of the iostat command (AIX) you would be able to identify if you have a hot disk and then by moving some files out that disk... (3 Replies)
Discussion started by: arizah
3 Replies

4. Shell Programming and Scripting

awk- comparing fields from the same column, finding discontinuities.

Hello, I have a file with two fields. The first field repeats itself for quite a while but the second field changes. What I want to do is to go through the first column until its value changes (and while it doesn't, verify that the second field is in a sequence from 0-15). Example input: ... (13 Replies)
Discussion started by: acsg
13 Replies

5. Shell Programming and Scripting

Question on awk for finding the column number using a match word

Hi Guys, Please help me out in my situation of writing a shell script Exampl:I have a output like asnapply 1 2 3 apply_server=1 apply_schema=ASN asnapply 1 2 3 apply_server=2 apply_schema=ASN Now i need output like asnacmd applysever=1 applyschema=ASN stop asnacmd applysever=2... (16 Replies)
Discussion started by: mallak
16 Replies

6. Shell Programming and Scripting

finding greatest value in a column using awk from iostat output in linux

Friends, . On linux i have to run iostat command and in each iteration have to print the greatest value in each column. e.g iostat -dt -kx 2 2 | awk ' !/sd/ &&!/%util/ && !/Time/ && !/Linux/ {print $12}' 4.38 0.00 0.00 0.00 What i would like to print is only the... (3 Replies)
Discussion started by: achak01
3 Replies

7. Shell Programming and Scripting

Formatting output from iostat

So I use Cacti for monitoring IO statistics on my servers, now originally I couldnt monitor Multipath deviced servers as they have alot of /dev/sdxx and /dev/emcpowerxx, I have devised a method of trimming them down to just the actual devices but the issue is the output looks like so. # iostat... (0 Replies)
Discussion started by: RiSk
0 Replies

8. Shell Programming and Scripting

Finding the total of a column using awk

Here is my file name countries USSR 8650 262 Asia Canada 3852 24 North America China 3692 866 Asia USA 3615 219 North America Brazil 3286 116 South America India 1269 637 Asia Argentina 1072 ... (8 Replies)
Discussion started by: ironhead3fan
8 Replies

9. UNIX for Advanced & Expert Users

iostat output what is that mean

Hi all, i have run iostat -em, and get below result. Can i know what is this output meaning, and how to fix that problem. iostat -em ---- errors --- device s/w h/w trn tot sd7 0 1 0 1 sd8 1 1 0 2 sd9 0 1 0 1 sd10 0 ... (2 Replies)
Discussion started by: foongkt5220
2 Replies

10. Solaris

iostat -e / -E output explanation

Hi all, hope you are having a nice day, its nice and warm today in Canberra Australia. iostat -e / -E reports soft and hard errors. Any idea what these are exactly? All I hear are I/O's failing and needing to retry, but no cause as to why they fail. My SUN guru tells me its our EMC SAN... (1 Reply)
Discussion started by: scottman
1 Replies
Login or Register to Ask a Question