Hello,
I'd like to insert or update my table on SQL Server with using search results through Splunk DB Connect.
I defined the following SQL Query for Database Lookups settings.
INSERT INTO table_name (column01, column02) VALUES ($value1$, $value2$)
But I failed.
So, I want to use a function like "mysqloutput" provided by "MySQLConnector".
If not, I would appreciate your alternative ways to update my DB tables.
Thank you.
The DB Connect app comes with a similar command, dboutput. There appears to be little documentation though 😞 maybe you can gather at least some insight from the dboutput.conf.spec file.