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 ?