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.

You can only use custom database formats to log individual messages. Messages logged in bulk cannot apply custom database formats. For more information, see Add an action to log messages to a database.

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.