This article provides steps to log Kiwi Syslog Daemon to a MS SQL database.
The database options are always being improved. It is recommended you download the latest version of Kiwi Syslog Daemon from our SolarWinds Customer Portal
If you need details screen shots available under this post Kiwi Syslog logs to store with SQL database setup screen shots
All Kiwi Syslog versions
You should now be ready to have the messages logged to the database.
You only need to use a custom database type if you want to modify the field names or formats. More details on the Kiwi ISO format can be found in the help file.
To log to different databases, you will need to use a separate rule, filter and action for each database. You can split the traffic based on host name, or message facility. Just have all the routers send on Local0, all the switches on Local1 and all the firewalls on Local2. Then use priority filters to split the messages.
Action: Display (displays all messages - no filters)
Filter: Priority: Local0, all levels
Action: Log to ODBC: DSN=Routers
Filter: Priority: Local1, all levels
Action: Log to ODBC: DSN=Switches
Filter: Priority: Local2, all levels
Action: Log to ODBC: DSN=Firewalls
You can either use a separate DSN and database for each rule, or just specify a different table in the same database. The choice is up to you.