B
bastardx
Hi
I wonder if you can point me to some scripts because I don't know perl.
I think that perl is best for what I want to do.
I have special kind of logs which looks like following:
ID - is client id
Date - is server access date
IN - bytes sent to server
OUT - bytes received from server
ID DATE IN OUT
id12 2005-06-07 12 1091
id16 2005-06-07 893 17881
id12 2005-06-07 53 9912
id34 2005-06-07 323 7211
id34 2005-06-07 15 2381
id34 2005-06-07 542 9771
id16 2005-06-07 90 9912
id16 2005-06-07 409 6712
id12 2005-06-07 311 3443
id34 2005-06-07 342 1123
id12 2005-06-07 90 7455
id34 2005-06-07 145 512
id12 2005-06-07 88 1667
I want to summarize IN and OUT bytes for particular ID per day
Fg
ID DATE TOTAL_IN TOTAL_OUT
id12 2005-06-07 12314 8098794
Can you help me?
I wonder if you can point me to some scripts because I don't know perl.
I think that perl is best for what I want to do.
I have special kind of logs which looks like following:
ID - is client id
Date - is server access date
IN - bytes sent to server
OUT - bytes received from server
ID DATE IN OUT
id12 2005-06-07 12 1091
id16 2005-06-07 893 17881
id12 2005-06-07 53 9912
id34 2005-06-07 323 7211
id34 2005-06-07 15 2381
id34 2005-06-07 542 9771
id16 2005-06-07 90 9912
id16 2005-06-07 409 6712
id12 2005-06-07 311 3443
id34 2005-06-07 342 1123
id12 2005-06-07 90 7455
id34 2005-06-07 145 512
id12 2005-06-07 88 1667
I want to summarize IN and OUT bytes for particular ID per day
Fg
ID DATE TOTAL_IN TOTAL_OUT
id12 2005-06-07 12314 8098794
Can you help me?