用于OASIS日志的GROk

Question

我想为OASIS日志创建一个自定义的GROK。

2019-10-29 00:36:53Z|User -User trying to login from desktop oasis screen|Cart -|Level -INFO|Severity -Information|Class -oaCheckOut.aspx.vb|Function -Button1_Click : oaCheckOut|UserID: 261343 Cart_ID: 8050513 - Start :  Validate K12PunchinGuest mandatory fields execution

我一开始用的是GROK

%{TIMESTAMP_ISO8601:timestamp}\|%{GREEDYDATA:user}\|%{DATA}%{SPACE}\-%{DATA:Level}

到目前为止我的输出。

{
  "timestamp": [
    [
      "2019-10-29 00:36:53Z"
    ]
  ],
  "user": [
    [
      "User -User trying to login from desktop oasis screen|Cart -|Level -INFO|Severity -Information|Class -oaCheckOut.aspx.vb|Function -Button1_Click : oaCheckOut"
    ]
  ],
  "Level": [
    [
      ""
    ]
  ]
}

在这里，我无法将用户、级别和严重性分开。

实现我所期望的最好的方法是什么？什么是正确的GROK？请帮帮我。

Answer 1

请尝试下面的grok，

%{TIMESTAMP_ISO8601:timestamp}\|(?:User -%{GREEDYDATA:User})\|(?:Cart -%{GREEDYDATA:Cart})\|(?:Level -%{GREEDYDATA:Level})\|(?:Severity -%{GREEDYDATA:Severity})\|(?:Class -%{GREEDYDATA:Class})\|(?:Function -%{GREEDYDATA:Function})\|(?:UserID: %{BASE10NUM:UserID})\s(?:Cart_ID: %{BASE10NUM:Cart_ID})%{GREEDYDATA}