Updating existing documents with a new field

Elastic Stack Elasticsearch
1

Hello all, we're ingesting Windows event logs via Logstash and to get specific field data from an application log I've got the following filter in Logstash:

if [log_name] == "CISAccess" {
   grok {
      match => { "message" => "Usr=>%{DATA:User}#.*\sStn=>%{DATA:Workstation}#.*"}
        }
    }

Can somebody tell me how I can apply this to existing documents? - would I need to use a painless script or do I need to change the Logstash output to action => update and if so how do I keep ingesting new documents if I do that?

Thanks

2

@kernelpanic I think you have two options:

  1. build an ingest pipeline with the same grok logic inside of a grok processor and run an _update_by_query which passes data through that pipeline like
    PUT _ingest/pipeline/my-grok-pipeline
{
  "description" : "pulls more stuff from the message",
  "processors" : [ {
     "grok": {
        "field": "message",
        "patterns": ["Usr=>%{DATA:User}#.*\sStn=>%{DATA:Workstation}#.*"]
     }
  }]
}
POST my-index/_update_by_query?pipeline=my-grok-pipeline
{
   "query": { "term": { "log_name": "CISAccess" } }  
}
  2. Do the _update_by_query with a Painless script, requiring you to figure out how to map that grok logic to Java-style regex/Patterns
3

Excellent, thankyou for getting back to me Mike.

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.