SIEM, Vulnerability Scanning, Server Monitoring and Compliance Training for IT Professionals
Table of Contents

Database Actions

Database Actions enable Network Administrators to save monitored audit log entries and scheduled report results to a database table for external consumption. This Action is typically used to integrate with Business Intelligence (BI) systems such as Microsoft Power BI.

In this Topic

To Create a Database Action

  • From the Menu Bar select File | New. The Create New Object View displays.
  • Select Alerts and Actions. The New Action view displays.
  • Use the Name text box to specify a unique name.
  • From the Type drop-down select Save to a Database.

Options

  • Use the Data Provider drop-down to select the target database provider.
Note
To attach an external database, create a new Data Provider that connects to your database. When creating the Data Provider, set the Role to None.
  • Use the Table textbox to specify the name of the table to create.
Important
Do not manually create the table. The data structure is defined within the Columns Definitions found in Log Monitors and Reports.
  • Use the Clear the database table prior to writing entries checkbox to clear the table each time written too. Templates should leave this un-checked to append new triggers. Reports should check this to overwrite the previous report each time executed.
Save to Database Action Properties
Save to Database Action Properties

To Assign to a Report

To assign this action to a report, from any Report Properties View, select the Actions Tab, then assign this action to the On Complete drop-down.

Related Topics

Actions

Columns Definitions

Data Providers