Chinaunix

标题: 日志分析：根据用户ID统计在线时长 [打印本页]
作者: nblity    时间: 2009-12-03 16:48
标题: 日志分析：根据用户ID统计在线时长
根据[login]判断登陆   [logout]判断登出
[playerid][2095]   playerid后边方括号内的数字为用户ID
统计判断该ID在线时长

请教一下高手，该怎样处理。


[2009-12-03 10:01:09103](LoginManagerImpl.java:229) [ messageReceiveStart [961531:0] [1] +[LoginSystem]] - [login][failed][accountid:961531]
[2009-12-03 10:01:13185](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][25]
[2009-12-03 13:50:55211](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 13:50:55213](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 13:50:55214](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 13:50:57309](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 14:20:20104](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 14:20:20105](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 14:20:20105](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 14:21:26465](LoginManagerImpl.java:229) [ messageReceiveStart [961531:0] [1] +[LoginSystem]] - [login][failed][accountid:961531]
[2009-12-03 14:21:28464](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 14:52:15782](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 14:52:15783](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 14:52:15784](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 14:52:47172](LoginManagerImpl.java:229) [ messageReceiveStart [961531:0] [1] +[LoginSystem]] - [login][failed][accountid:961531]
[2009-12-03 14:52:48882](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 14:52:59738](LoginManagerImpl.java:229) [ messageReceiveStart [tester110:0] [1] +[LoginSystem]] - [login][failed][accountid:tester110]
[2009-12-03 14:53:05224](LoginManagerImpl.java:205) [ messageReceiveStart [tester110:2730] [1] +[LoginSystem]] - [login][enterWorld][accountid][tester110][playerid][2730][name][能见度][career][战士][level][80]
[2009-12-03 15:11:33544](LoginManagerImpl.java:183) [ messageReceiveStart [tester110:2730] [1] +[LoginSystem]] - [logout][accountid][tester110][playerid][2725][name][苔丝特][career][战士][level][1]
[2009-12-03 15:11:33545](LoginManagerImpl.java:183) [ messageReceiveStart [tester110:2730] [1] +[LoginSystem]] - [logout][accountid][tester110][playerid][2730][name][能见度][career][战士][level][80]
[2009-12-03 15:11:33620](LoginManagerImpl.java:183) [ messageReceiveStart [tester110:2730] [1] +[LoginSystem]] - [logout][accountid][tester110][playerid][2729][name][雨夹雪][career][法师][level][80]
[2009-12-03 15:11:34983](LoginManagerImpl.java:205) [ messageReceiveStart [tester110:2725] [1] +[LoginSystem]] - [login][enterWorld][accountid][tester110][playerid][2725][name][苔丝特][career][战士][level][1]
[2009-12-03 15:13:10239](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [5] +[CombatSystem]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 15:13:10240](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [5] +[CombatSystem]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 15:13:10241](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [5] +[CombatSystem]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 15:46:52136](LoginManagerImpl.java:229) [ messageReceiveStart [961531:0] [1] +[LoginSystem]] - [login][failed][accountid:961531]
[2009-12-03 15:46:53738](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 15:57:31679](LoginManagerImpl.java:183) [ messageReceiveEnd [tester110:2725] [3] +[PlayerSystem]] - [logout][accountid][tester110][playerid][2725][name][苔丝特][career][战士][level][1]
[2009-12-03 15:57:31698](LoginManagerImpl.java:183) [ messageReceiveEnd [tester110:2725] [3] +[PlayerSystem]] - [logout][accountid][tester110][playerid][2730][name][能见度][career][战士][level][80]
[2009-12-03 15:57:31699](LoginManagerImpl.java:183) [ messageReceiveEnd [tester110:2725] [3] +[PlayerSystem]] - [logout][accountid][tester110][playerid][2729][name][雨夹雪][career][法师][level][80]
[2009-12-03 16:16:16689](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 16:16:16690](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 16:16:16691](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 16:16:18260](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 16:22:40970](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 16:22:40970](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 16:22:40971](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 16:22:42495](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:0] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 16:22:42496](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:0] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 16:22:42497](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:0] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 16:22:49333](LoginManagerImpl.java:229) [ messageReceiveStart [96153c:0] [1] +[LoginSystem]] - [login][failed][accountid:96153c]
[2009-12-03 16:23:23488](LoginManagerImpl.java:205) [ messageReceiveStart [96153c:2732] [1] +[LoginSystem]] - [login][enterWorld][accountid][96153c][playerid][2732][name][任务享][career][法师][level][8]

[ 本帖最后由 nblity 于 2009-12-3 16:51 编辑 ]
作者: ly5066113    时间: 2009-12-03 17:05
login logout 不配对的怎么处理？
作者: nblity    时间: 2009-12-03 17:34
标题: 回复 #2 ly5066113 的帖子
只有login没有logout的，截止到当天23：59
没有login只有logout的，从00:00起计算
作者: ly5066113    时间: 2009-12-03 17:59
标题: 回复 #3 nblity 的帖子
try:

  1. $ cat test.awk
  2. #! /usr/bin/awk -f

  4. BEGIN {
  5.         FS = "[][]"
  6. }

  8. /login/ && ! /failed/ {
  9.         a[$22] = d2s($2)
  10. }
  11. /logout/ {
  12.         c[$20] = d2s($2)

  14.         if(a[$20])
  15.         {
  16.                 b[$20] += c[$20] - a[$20]
  17.         }
  18.         else
  19.         {
  20.                 b[$20] += c[$20] - d2s(substr($2, 1, 10)" 00:00:00")
  21.         }
  22. }
  23. END {
  24.         for(i in a)
  25.         {
  26.                 if(c[i] < a[i])
  27.                 {
  28.                         b[i] = d2s(strftime("%Y %m %d", a[i])" 23:59:59") - a[i]
  29.                 }
  30.         }
  31.         for(i in b)
  32.         {
  33.                 print i, b[i]
  34.         }
  35. }

  37. function d2s(d)
  38. {
  39.         gsub(/[-:]/, " ", d)
  40.         s = mktime(substr(d, 1, 19))
  41.         return s
  42. }
  43. $ awk -f test.awk urfile
  44. 2730 4974
  45. 2732 27396
  46. 2095 386298
  47. 2725 57450
  48. 2088 386298
  49. 2736 21143
  50. 2729 112144
复制代码

[ 本帖最后由 ly5066113 于 2009-12-3 18:00 编辑 ]
作者: nblity    时间: 2009-12-03 18:16
标题: 回复 #4 ly5066113 的帖子
保存为test.awk
chmod +x test.awk
./test.awk之后
提示信息：
./test.awk: line 1: $: command not found
./test.awk: line 4: BEGIN: command not found
./test.awk: line 5: FS: command not found
./test.awk: line 6: syntax error near unexpected token `}'
./test.awk: line 6: `}'
作者: lucash    时间: 2009-12-03 18:45
标题: 回复 #5 nblity 的帖子
晕，你不会把第一行的 $ cat test.awk也放进去了吧？
作者: nblity    时间: 2009-12-03 22:57
第一行跟最后一行都不放进去？
呵呵，我是做java的，对shell一点都不懂
见笑了，不过正在学习
作者: walkerxk    时间: 2009-12-03 23:02
$ 开头的行不要放进去，就这两个$ 中间的部分就行了，$ 是shell提示符
作者: nblity    时间: 2009-12-04 09:30
嗯，明白了
已经测试出结果
谢谢两位
我还得继续研究研究
作者: nblity    时间: 2009-12-04 14:11
弱弱的再问一下，怎样让上述代码的结果输出到一个文本文件中呢？
作者: ly5066113    时间: 2009-12-04 14:19
标题: 回复 #10 nblity 的帖子
http://bbs.chinaunix.net/viewthr ... p;page=7#pid1636825

有空把十三问都看一遍吧。
作者: vbirding    时间: 2009-12-04 14:30
弱弱的冒個泡
$ awk -f test.awk urfile >1.txt
作者: nblity    时间: 2009-12-04 14:47
嗯   我没有在外部执行  直接在里面用了echo   已经可以了
谢谢   我去看十三问



欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2