I see Docs on selecting a Custom DB Format of Microsoft SQL. Though I cannot find anywhere to select the Microsoft SQL format, or a way to define my own format like in the old version.
This is from v9.x I have an Existing table that is used on our Intranet site to Query Data from. I'd like to get the log to SQL to work the same without having to alter the structure of the existing DB/Table.
SQL command to create the table:
CREATE TABLE Syslogd (MsgDate DATETIME,MsgPriority VARCHAR(30),MsgHostname VARCHAR(255),MsgText VARCHAR(4096))
SQL INSERT command example:
INSERT INTO Syslogd (MsgDate,MsgPriority,MsgHostname,MsgText) VALUES (N'2024-08-08 14:51:35',N'Local7.Debug',N'10.11.0.134',N'This is a test message from Kiwi Syslog Server - Paulo?')
In the folder:C:\ProgramData\SolarWinds\KiwiSyslogService\Settings
I see the following:
SolarWinds.Kiwi.Syslog.Actions.LogToFile.Model.LogFileCustomFormat.json
I was hoping to create something like:
SolarWinds.Kiwi.Syslog.Actions.BulkInsert.Model.BulkInsertCustomFormat.json
and was hoping there was a way to alter the insert format.