SIEM, Log Management, Security, Compliance, Server Monitoring and Uptime Monitoring Software
Table of Contents

Report Columns

The Columns Tab, found in various Report property views, enables you to:

  • Select the columns to include in the report.
  • Order the columns.
  • Define custom regular expression driven columns.
  • Sort by multiple columns.
  • Group by multiple columns.

The Column definitions:

The Column definitions control lists all columns included in the report.

  • Use the Enabled check box to either enable or disable a column in the report.
  • The Key column lists the unique key for each column. The built-in column definition keys are read-only.
  • The Name column lists the column header's display string. By default, the key value is used to look up the locale specific string from resource DLLs. Use the Name text box to override the locale specific string that is assigned to the column's key.
Important
Once modified, regardless of locale, the value you specify is used in the report. To once again use the locale specific values, you must re-create the report.
  • The Data Type column lists the column's data type. The built-in column definition Data Types are read-only.
  • Use the Up Move up button and Down Move down button buttons found on the right side of the table control to change the column display order.
Sample Column Definition Properties View
Sample Column Definition Properties View

How to create a custom regular expression driven column:

Some reports enable users to define column content using one or more regular expressions. This format enables multiple log entry types to display different values to the same column. The last regular expression to match is applied.

  • Click the Add Add Button button. A new empty column definition is created at the bottom of the list.
  • Use the Key text box to specify a unique key to be used by filters.
  • Use the Name text box to specify the column header's display string.
  • Use the Data Type drop-down to select the data type to assign to the column.
  • From the RegEx column, click the Down Display regular expressionsbutton to display the Regular expressions control.
  • From the Regular expressions control, click the Add Add regular expression. A new Regular expression is added to the bottom of the list.
  • Use the Value text box to specify the regular expression that defines a key value pair. For example, when reporting on Event ID 4624(S): An account was successfully logged on., use the following regular expression to apply the new logged in user's account name to the TARGET_ACCOUNT_NAME column:
    New Logon:\r\n\s+Security ID:[^\r\n]+\r\n\s+Account Name:\s+(?<TARGET_ACCOUNT_NAME>[^\r\n]+)
Important
To successfully validate, a regular expression variable must be defined that matches the key. For example, if the key is TARGET_ACCOUNT_NAME, there must be a corresponding variable ?<TARGET_ACCOUNT_NAME>The regular expression is validated against the current column key after you tab out of the text box or move focus to another control.
  • Use the Up Move up button and Down Move down button buttons to change the regular expression order of execution.
Sample Regular Expression Column Definitions
Sample Regular Expression Column Definitions

Sort By:

  • Use the Select from list drop-down to select an alternate column to sort by when the values in the prior column are identical. You can sort by as many columns as necessary to get the desired results.
  • Use the Sort Order column drop-downs to assign the sort directions.
  • Use the Up Move up button and Down Move down button buttons found on the right side of the table control to change the order of sorting.
  • To delete an item, either select a single line item or use the shift and/or ctrl keys to multi-select, then either press the Delete key or press the Delete Delete button button.
  • To clear all listed items, press the Clear Clear button button.
Sample Sort By Controls
Sample Sort By Controls

Group By:

  • Use the Select from list drop-down to select each column to group by.
Note
When reports are emailed or saved to a file, a table is generated for each unique set of Group By columns.
  • Use the Sort Order column drop-downs to assign the sort directions.
  • Use the Sort By Count column checkbox to sort the groups by the count of rows rather than the names.
  • Use the Up Move up button and Down Move down button buttons found on the right side of the table control to change the order of grouping.
  • To delete an item, either select a single line item or use the shift and/or ctrl keys multi-select, then either press the Delete key or press the Delete Delete button button.
  • To clear all listed items, press the Clear Clear button button.
Sample Group By Controls
Sample Group By Controls

Related Topics

Reports