Add an action to log messages to a database with a bulk insert

You can add an action to log messages to a SQL database using a bulk insert. You can use a bulk insert to log multiple events in a single connection to the database, rather than establishing and closing a session for each event.

1. From the Kiwi Syslog Service Manager, choose File > Setup.
2. Add a rule, or locate an existing rule.
3. Right-click Actions below the rule, and choose Add Action.
4. Replace the default name with a descriptive name.

5. From the Action menu, select Log to Database - New Bulk Insert.

   

6. Insert the SQL Server connection string and database table name.

7. Insert the number of maximum records, maximum milliseconds, and connection inactivity timeout if needed.
8. Test the action.
9. Click Apply.