What do you mean by the text marked in red above? I thought you wanted to get the sum and average values of the 3rd FIELD (not ROW) from the last 7 and 30 lines??? And, this is the first you have said about wanting a maximum instead of a sum and average???

When I asked you to run uptime for a couple of hours, what we need to see is what happens around multiples of one hour and around an integral multiple of one day of up time. So, instead of skipping over the data between what you showed us:

Code:

 19:22:26 up  8:23,  2 users,  load average: 0.52, 0.22, 0.12
 19:23:24 up  8:24,  2 users,  load average: 0.26, 0.21, 0.12
 19:24:22 up  8:25,  2 users,  load average: 0.14, 0.18, 0.12
... ... ...
20:32:03 up  9:33,  3 users,  load average: 0.00, 0.04, 0.06
 20:33:01 up  9:34,  3 users,  load average: 0.00, 0.03, 0.06
 20:33:59 up  9:35,  3 users,  load average: 0.03, 0.04, 0.06

show us what is on the lines starting with 19:58, 19:59, 20:00, 20:01, and 20:02. And we need to see what happens around the time when the system has been running for an even multiple of 24 hours. (At least on OS X, the format on one hour multiples, is something like 9 hours, 17 secs, (instead of 9:00,) and on 24 hour multiples the change is even more pronounced.)

If you got the output:

Code:

mins[4] = 0 from users,
mins[5] = 0 from users,
mins[6] = 582 from 9:42
Input file /home/sandy/logger/uplog.txt trimmed from 216 lines to 200 lines

from my script, I obviously left in a debugging statement that I forgot about. Note also that the output here says that that the 1st 16 lines from that file were discarded (thereby keeping the last 200 lines) as you requested. Is the last line in your log file:

Code:

uptime sandy an jarbo3   9:42   23.06.2014

in the format you want?

Obviously, the format I used to write the sums and averages in /home/averages.txt (or whatever pathname you changed it to) is not in the format you want. But, as I said before, I made a wild guess at a reasonable output format based on the data being summed and averaged. If you will actually show us the last few lines of your log file AND show us exactly what the corresponding sum and average output should be for those lines, we might be able to produce data in the format you want. Did you even look in this file to see the output my script produced?

PLEASE DON'T TELL ME I WROTE THE WRONG SUMS AND AVERAGES IF YOU REFUSE TO SHOW US WHAT YOU WANT!

As I said before, your command:

Code:

awk 'BEGIN {max = 0} {if ($3>max) max=$3} END {print max}' /logfile.txt

tells you absolutely nothing about the data on the last 7 or on the last 30 lines in your log file; it is looking for the maximum value in all 200 lines in your log file. And, it is doing a string comparison (not a numeric comparison of hours and minutes); so 7:56 is greater than 22:30, but even more importantly $3 seems to be what you want for looking at the output from uptime not the data in your log file where I hope the up time is in field 5:

Code:

uptime sandy an jarbo3   9:42   23.06.2014

shown in red here; not field 3 shown in orange. Or, have you changed the data format in your log file again!