How to make changing parameters in jdbc input?


(Taurus) #1

Hi, I'm using jdbc input plugin to import tables from SQLServer 2012 to ELK.
In my SQLServer DB, it will automatically generate a new table every minute with name XXXX_yyyyMMddHHmm (e.g. Blablabla_201707201023).

Now I hope to import one table every minute correspondingly using logstash automatically. I'm trying to add a parameter into my query statement to change the query table name according to time, like

statement => "SELECT * FROM :parameter"
parameters => { "parameter" => "blablabla_%{yyyyMMddHHmm}" }

well, something like that...

Is there anyone can help me point out what is the correct way to do that?

Thank you!


(system) #2

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