Perl - Mawk

we got  some lines like that  and they are tab separted
we want to group the logs with TTL & destination ip address and get count of the each group  how should that be done

a
1433301992474 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301992503 - 41.26.121.86.   51594   0001000000000000067178737a6b6603        37.123.100.8.   53      233     66
1433301992532 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301992565 - 185.9.156.26.   62218   4e495431006500008802fd66d3000000        185.9.156.13.   9987    128     62
1433301992594 - 185.9.156.26.   62218   670afe6f00000000229d748b45aa7bef        185.9.156.13.   9987    128     212
1433301992640 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301992673 - 213.238.170.199.        137     000100000000000020454a4543454e45        213.238.170.255.        137     128     78
1433301992706 - 213.238.170.199.        137     00010000000000002045434641454d46        213.238.170.255.        137     128     78
1433301992736 - 213.238.170.199.        137     00010000000000002045474545464846        213.238.170.255.        137     128     78
1433301992764 - 213.238.170.199.        137     00010000000000002045424549454e45        213.238.170.255.        137     128     78
1433301682696 - 213.238.170.199.        137     0001000000000000204649464a454b45        213.238.170.255.        137     128     78
1433301682746 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301682778 - 213.238.170.199.        137     00010000000000002046424550454946        213.238.170.255.        137     128     78
1433301682808 - 157.56.205.8.   40021   00010000000000000a636961686f7374        37.123.100.220. 53      112     60
1433301682837 - 191.234.67.56.  44197   00010000000000000a636961686f7374        37.123.100.220. 53      48      60
1433301682866 - 157.56.205.9.   29205   00010000000000000a636961686f7374        37.123.100.220. 53      112     60
1433301682895 - 37.123.103.4.   64210   00010000000000000477706164000001        224.0.0.252.    5355    1       50
1433301682925 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301682954 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301682984 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683012 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683066 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683109 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683139 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683173 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683202 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683232 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683261 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683308 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683340 - 57.177.212.60.  17824   0001000000000000026d740737373737        37.123.100.8.   53      239     60
1433301683370 - 37.123.103.4.   63257   00010000000000000477706164000001        224.0.0.252.    5355    1       50
1433301683399 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683437 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683480 - 157.56.205.9.   14975   00010000000000000a636961686f7374        37.123.100.220. 53      111     60
1433301683510 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683540 - 37.123.103.4.   63257   00010000000000000477706164000001        224.0.0.252.    5355    1       50
1433301683569 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683598 - 37.123.96.154.  137     00010000000000002046484641454245        37.123.96.159.  137     128     78
1433301683632 - 18.92.167.121.  51761   00010000000000000273720377777705        37.123.100.8.   53      233     62
1433301683662 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683691 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683720 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683749 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683778 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683807 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683836 - 061632. 246284  000000000100020222022300672c52  (hlim   UDP     00      128
1433301683869 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301683899 - 37.123.103.4.   137     00010000000000002046484641454245        37.123.103.15.  137     128     78
1433301482893 - 185.9.159.186.  137     00010000000000002045504644454e45        185.9.159.255.  137     128     78
1433301482920 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301482934 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301482947 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301482960 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301482984 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301482997 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483010 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483023 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483058 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483073 - 14.211.48.149.  19515   00010000000000000a656e6978736a69        37.123.100.8.   53      237     68
1433301483102 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483115 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483127 - 185.9.156.26.   62218   4e495431006500008802fd66d3000000        185.9.156.13.   9987    128     62
1433301483140 - 185.9.156.26.   62218   670afe6f00000000229d748b45aa7bef        185.9.156.13.   9987    128     212
1433301483153 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483166 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483178 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483191 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483213 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483228 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483241 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483254 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483266 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483279 - 91.19.112.252.  9508    00010000000000001067627364736467        37.123.100.8.   53      236     77
1433301483291 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483304 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483316 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483329 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483341 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483354 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483366 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483379 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483391 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483404 - 37.123.103.4.   137     00010000000000002046484641454245        37.123.103.15.  137     128     78
1433301483416 - 178.20.225.235. 54513   0500000000000000f8be000013000000        255.255.255.255.        48887   128     75
1433301483433 - 93.158.178.83.  21776   0001000000000000037777770c726f6d        37.123.100.2.   53      51      66

Open in new window

FireBallITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ozoCommented:
sort -k6,6 -k8,8
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
FireBallITAuthor Commented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Perl

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.