SIEM, IPS, Server Monitoring, Uptime Monitoring and Compliance Software
Table of Contents

SIEM Reports

A SIEM Report queiries centralized log databases for specific log entries generated from various log types on multiple servers, workstations and network devices, applies log entry filters, applies display options, such as the column order, group by and sort by rules, then lastly, displays, saves or emails the output results.

This report is typically used by network administrators that want to analyze and correlate Security Event Logs and data from various sources within their organization's network infrastructure, such as firewalls, intrusion detection systems, and servers.

Information To quickly view logs of the same type, see: Merging Logs.

SIEM Reports optionally use Regular Expressions to parse log entries, extract values, validate subject and target accounts in Active Directory (when applicable), then, finally, filter entries using each assigned log type's native filters.

How to create a SIEM Report

  • From the Menu Bar select File | New. The Create New Object View displays.
  • From the Create New Object View, expand Reports.
  • Expand Report | Log Consolidation Reports then select SIEM Report. The Properties View displays.
    Information Unlicensed report types appear in gray text. If you would like to create a report that is not currently licensed, please contact Corner Bowl Software to upgrade your license.
  • The Properties View contains 6 configuration tabs.
    • General
    • Explicitly Assigned Logs
      Sample Windows Security Log and Linux Audit Log assignment
    • Columns
      Sample Windows/Linux Success Logon Report column definitions
      Alert If you apply regular expressions column definitions in your corresponding log consolidation templates, and the column keys are identical between log types, you do not need to re-apply the regular expressions in the report.
    • Options
    • Date/Time Range
    • Actions

The Options Tab

  • Use the Filters drop-down to select all of the filters you would like to apply to the report.
    Alert Filters are only applied to corresponding log entries types. For example, when you have assigned both an Event Log and a Text Log to the report, Event Log Filters are only applied to Event Log Entries while Text Log Filters are only applied to Text Log Entries.
    Sample regular expression driven new Windows success login filter with exclusion.
    Sample regular expression driven new Red Hat Linux success login filter with exclusion.
    Assign report filters
  • Once a filter is assigned, use the Include entries that pass drop-down to select the filter method.

    The following filter options are available:

    AllInclude each entry that passes all assigned filters of the same type.
    AnyInclude each entry that passes any filter of the same type.
    NoneInclude each entry that does not pass any of the filters of the same type.
    IgnoreInclude all entries.
    Sample SIEM Success Logon Report properties
    Sample Windows/Linux Success Logon Report
  • Use the Select distinct count controls to define a composite key to select a distinct count of entries that match your composite key. For example, generate a report that displays the number of each unique event type, Information, Warning, Critical, Audit Success and Audit Failure or the number of unique entries keyed by Event ID and Source on each assigned host).
    Generate a report that displays the number of entries grouped by Event ID and Source.
  • Use the Query by controls to optimize SQL statements. For example, if the column you want to search for was added using a regular expression column defnition, specify the column key and the value to search for. Once executed, only rows that match your search criteria are returned from the database engine.
    Apply select where clauses to optimize SQL.

Related Topics

Merging Logs