below is a CPU utilization Log for ABC server.
However for every 15 minutes it generates 3 CPU values(with interval of 2 sec).
How would i list average value of cpu % at after every 15 minuates.
Say.
Please suggest .

Here is what I did...

Made a file with all the values called cpu.txt

Here is an example of the file I used:

$ cat cpu.txt
ABC 101.1 2 50.55 14 : 15
ABC 100.5 2 50.25 14 : 15
ABC 100.2 2 50.1 14 : 15
ABC 100.9 2 50.45 14 : 30
ABC 100.5 2 50.25 14 : 30
ABC 100.4 2 50.2 14 : 30
ABC 101.0 2 50.5 14 : 45
ABC 100.9 2 50.45 14 : 45
ABC 100.4 2 50.2 14 : 45
ABC 101.1 2 50.55 15 : 00
ABC 100.7 2 50.35 15 : 00
ABC 100.5 2 50.25 15 : 00
ABC 101.1 2 50.55 15 : 15
ABC 101.0 2 50.5 15 : 15
ABC 100.5 2 50.25 15 : 15
ABC 101.1 2 50.55 15 : 30
ABC 100.9 2 50.45 15 : 30
ABC 100.4 2 50.2 15 : 30
ABC 102.2 2 51.1 15 : 45
ABC 101.4 2 50.7 15 : 45
ABC 100.7 2 50.35 15 : 45



Then run the following awk statement against it:

awk '{sum+=$5; ++n; print $5 }; END { print "------"; print "Tot="sum"("n")";print "Avg="sum"/"n"="sum/n} ' cpu.txt

and here is the output:


$ awk '{sum+=$5; ++n; print $5 }; END { print "------"; print "Tot="sum"("n")";print "Avg="sum"/"n"="sum/n} ' cpu.txt
14
14
14
14
14
14
14
14
14
15
15
15
15
15
15
15
15
15
15
15
15
------
Tot=306(21)
Avg=306/21=14.5714

oops... silly me, used the wrong column... Just change the 5 to a 4 in the awk statement...


$ awk '{sum+=$4; ++n; print $4 }; END { print "------"; print "Tot="sum"("n")";print "Avg="sum"/"n"="sum/n} ' cpu.txt
50.55
50.25
50.1
50.45
50.25
50.2
50.5
50.45
50.2
50.55
50.35
50.25
50.55
50.5
50.25
50.55
50.45
50.2
51.1
50.7
50.35
------
Tot=1058.75(21)
Avg=1058.75/21=50.4167

appreciate your help but i m expecting output in following format.

Well it is the same story for identifying anything you want displayed, what are the unique factors / identifiers that allow you to group together the data you are looking for?

Based on what you have shown as input it appears this data does not have enough unique points to give you what you would like.
So now you need to find more data that you can cross-reference with what you already have so you can.

ok i will make it more clear.

I would like to take above file as input .
Notice that for every 15 minuate interval there are some entries generated.
for example : for 14:15 there are 3 entries .
for 14:30 there are 2 entries.

I would like to get average of cpu% considering time.
say.

Cool ... in that case (untested):
You may need to play with last entry if you want time shown with a colon, but you get the idea.