Logstash plus filebeat pipeline

(Federico) #1

Hi there,

I have a api log file with the following format

...
2018.27.12 17:37:28.423 GET /api/v1/catalogManagement/productOffering 200 4
2018.27.12 17:37:28.242 GET /api/v1/addressManagement/address 200 1214
...

I would like to extract all the fields from log file and parse with grok to setup the @timestamp according first two records in each row

Thanks!

Logstash File pattern are more , how to reduce the number of patterns
(Christian Dahlqvist) #2

What have you got so far? Have you gone through This introduction to Logstash?

(Federico) #3

The main issue I have is how to parse the date based on dots and timestamp and setup the field timestamp

(Christian Dahlqvist) #4

What have you got so far? What is not working?

(Federico) #5

I need parsing dates and timestamps from fields, and then using that date and timestamp as the logstash timestamp for the event.

The fomat of hte lines in the file is like this:
...
2018.27.12 17:37:28.423 GET /api/v1/catalogManagement/productOffering 200 4
...

Are you able to do it using grok ?

(shyamkumar chintakindi) #6

you can try patterns on the below link:

http://grokdebug.herokuapp.com/

I tried matching the date with pattern:

%{YEAR}.%{MONTHDAY}.%{MONTHNUM}

(Federico) #7

Thanks so much for your input, I was able to make it work with a solution similar to the one you are proposing and I was also able to setup @timestamp using date. The app logs were quite tricky also becouse I had different date formats, now I fixed them. I was using hat debug site, its very useful

1 Like
(system) closed #8

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