Field in Graylog message is displayed as decimal


#1

Hi,

I am currently using Logstash-jdbc-plugin to call a database query and send the results to graylog.
Below is my logstash.conf.

input {
  jdbc {
    jdbc_driver_library => "/data/logstash/logstash-6.3.0/lib/sqljdbc42.jar"
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    jdbc_connection_string => "XXX"
    jdbc_user => "XXX"
    jdbc_password => "XXX"
    schedule => "* * * * *"
    statement => "select XXX from XXX"
  }
}

filter {
 mutate {
   add_field => { "message" => "Testing Server" }
   add_field => { "host" => "XXX" }
 }
}

output {
  gelf {
  host => "XXX"
  port => 12201
  short_message => "Testing gelf output"
  }
  stdout { codec => rubydebug }
}

The stdout output shows below :

 {
       "host" => "XXX",
      "project_loc" => 554283.0,
       "@version" => "1",
       "@timestamp" => 2018-07-18T03:58:01.364Z,
       "message" => "Test Gelf Output"
}

I am expecting project_loc field in Graylog search dashboard to be 554283.0 but however under the search section in Graylog, the field project_loc shows 0.554283E6 instead. Is there a conversion behind i should know of ?


(Jochen) #2

You could convert the “project_log” field into an integer number with the to_long() pipeline function.


(system) #3

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