Link to home
Start Free TrialLog in
Avatar of FireBall
FireBall

asked on

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

User generated image
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

ASKER CERTIFIED SOLUTION
Avatar of ozo
ozo
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of FireBall
FireBall

ASKER