Documentation forKiwi Syslog Server

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

This snippet is used for legacy 9.8.3 topics that link to a KSS NG topic of the same name.

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.