# How to Parse logfile with columns informations

**URL:** https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699
**Category:** Logstash
**Created:** [August 2, 2018, 7:28am UTC](https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699 "2018-08-02T07:28:12Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Loudone](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/loudone/32/33365_2.png) [@Loudone](https://discuss.elastic.co/u/Loudone)
#### Post date: [August 2, 2018, 7:28am UTC](https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699/1 "2018-08-02T07:28:12Z")

</div>

Dear All,

I'm trying to parse a very specific Log, this log look like this:

```
pid user_name user_authentication client_host client_lib_ver
=== ========= =================== =========== ==============

510 dmadmin Password 0111APPT 5.3.0.622 SP6 
378 dmadmin Password ADTS71 7.1.0450.0357 
464 dmadmin Password ADTS71 7.1.0450.0357 
410 dmadmin Trusted Client DCTMLS20 7.3.0030.0023 
307 dmadmin Trusted Client DCTMLS20 7.3.0040.0025 
432 Aodren LE Ticket 0112APPT 7.2.0000.0054 
338 Aodren LE Ticket 0112APPT 7.2.0000.0054 
688 Aodren LE Ticket 0112APPT 7.2.0000.0054 

```

My question is: how can I parse in logstash with grok filter this kind of log? and is it possible?

Many thanks for your feed Back

---

<div class="post-metadata">

### Author: ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [August 2, 2018, 7:44am UTC](https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699/2 "2018-08-02T07:44:18Z")

</div>

Of course it's possible, but using a csv or dissect filter might be easier. Are columns always separated by two or more spaces, i.e. how do we know that "Aodren LE" is part of the same column?

---

<div class="post-metadata">

### Author: ![Loudone](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/loudone/32/33365_2.png) [@Loudone](https://discuss.elastic.co/u/Loudone)
#### Post date: [August 2, 2018, 8:10am UTC](https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699/3 "2018-08-02T08:10:47Z")

</div>

Hello Magnus,

To begin, Thank you for your response.

I'm completly agree with you, if this log will be in csv, it could be an easier way.

Every columns are separated by two spaces, and for the column User\_name, the string is include in the length of the multiple string "=" on the top of the log

If it's possible to do that with the dissect filter, how can I do that?

Thank you

---

<div class="post-metadata">

### Author: ![Loudone](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/loudone/32/33365_2.png) [@Loudone](https://discuss.elastic.co/u/Loudone)
#### Post date: [August 2, 2018, 8:53am UTC](https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699/4 "2018-08-02T08:53:56Z")

</div>

Magnus, do you have an idea.?

---

<div class="post-metadata">

### Author: ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [August 2, 2018, 9:14am UTC](https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699/5 "2018-08-02T09:14:02Z")

</div>

This example from the documentation is pretty close to what you need: [https://www.elastic.co/guide/en/logstash/current/plugins-filters-dissect.html#\_delimiters\_used\_as\_padding\_to\_visually\_align\_fields](https://www.elastic.co/guide/en/logstash/current/plugins-filters-dissect.html#_delimiters_used_as_padding_to_visually_align_fields)

---

<div class="post-metadata">

### Author: ![Loudone](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/loudone/32/33365_2.png) [@Loudone](https://discuss.elastic.co/u/Loudone)
#### Post date: [August 2, 2018, 10:05am UTC](https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699/6 "2018-08-02T10:05:38Z")

</div>

Magnus,

it seems to be interresting!! many thanks for your feed back

---

<div class="post-metadata">

### Author: ![Loudone](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/loudone/32/33365_2.png) [@Loudone](https://discuss.elastic.co/u/Loudone)
#### Post date: [August 2, 2018, 10:15am UTC](https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699/7 "2018-08-02T10:15:08Z")

</div>

Last question Magnus, do you hnow if Dissect Debugger similar to the grok debugger exit?

it's very helpful for debugging logstash config

---

<div class="post-metadata">

### Author: ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [August 2, 2018, 10:54am UTC](https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699/8 "2018-08-02T10:54:50Z")

</div>

> Last question Magnus, do you hnow if Dissect Debugger similar to the grok debugger exit?

I don't believe there's anything like that.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 30, 2018, 10:54am UTC](https://discuss.elastic.co/t/how-to-parse-logfile-with-columns-informations/142699/9 "2018-08-30T10:54:54Z")

</div>

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