Table of Contents
- Getting Started
- Agent-Based Management
- Data Providers
- Directory Services
- Event Log Archiving for JSIG and CMMC Compliance
- Auditing
- Hosts
- Templates
- Template Properties
- Batch Update Templates
- Assign Templates
- Log Management Templates
- SCAP Compliance Monitor
- File and Directory Monitor Templates
- Windows Monitor Templates
- Account Lockout Monitor Template
- Logon Monitor Template
- CPU Monitor Template
- Memory Monitor Template
- Disk Space Monitor Template
- SMART Monitor Template
- Process Monitor Template
- Service Monitor Template
- Performance Counter Monitor Template
- PowerShell Template
- Registry Value Monitor Template
- System Security Monitor Template
- Active Directory User Monitor Template
- Active Directory User Integrity Monitor Template
- Task Scheduler Template
- Clock Synchronization Template
- Defragment NTFS Disks Template
- Windows Audit Policy Monitor Template
- Windows Logon As Monitor Template
- Windows Update Template
- Windows Management Instrumentation (WMI) Templates
- Database Monitor Template
- Directory Service Monitor Template
- DNS Blacklist Monitor Template
- DNS Monitor Template
- Domain Expiration Monitor Template
- Network Speed Monitor Template
- Ping Monitor Template
- Database Table Reseed
- SQL Server Shrink and Backup Template
- SSH Shell
- TCP Port Scan Monitor Template
- Website Monitor Template
- Wake On LAN Template
- SSL Certificate Monitor Templates
- Email Monitor Templates
- SNMP Monitor Templates
- Windows Accounts Templates
- Monitors
- Reports
- File and Permission Reports
- Summary Reports
- Auto-Configurators
- Filters
- Actions
- Database Actions
- Desktop Actions
- Email Actions
- Event Log Actions
- Executable Actions
- File Actions
- IIS IP Address Restriction Actions
- Microsoft Teams Actions
- PowerShell Actions
- Report Actions
- Service Actions
- SMS Actions
- SNMP Trap Actions
- Syslog Actions
- Template Actions
- IIS IP Address Restriction Actions
- Action Variables
- Schedules
- Environment Variables
- Options
- Account Lockout Monitoring and Reporting
- Merging Logs
- SNMP
- SSH Shell
- Syslog
- Exporting and Importing Configuration Objects
- Shared Views
- Active Directory User and Group Filters
- Assign Actions
- Assign Azure Audit Logs
- Assign Consolidated Logs
- Assign Directories
- Assign Disks
- Assign Event Logs
- Assign Files
- Assign Services
- Assign Shares
- Auto-Config Host Assignment Properties
- Define CSV and W3C Log Entry Columns
- Define Log Entry Columns
- Define Log Entry Columns with Regular Expressions
- Executable Status
- Executable Timeline
- Explicitly Assigned Logs
- File Explorer
- General Executable Properties
- Report Columns
- Report Date/Time Ranges
- Report Security Event Log Filters
- Select Folder or File
- Target Files and Sub-Directories
- Command Line Interface
- Server Configuration
- Agent Configuration
- Troubleshooting
- Terminology
Corner Bowl Server Manager
SIEM, IPS, Server Monitoring, Uptime Monitoring and Compliance Software
Define Log Entry Columns
The Columns Tab, found within both Log Consolidation and Log Monitor template properties views, enables you to extract values from log entries then, in the case of log consolidation, save those values to custom columns in your log repository database. Log Monitors use the column definitions to extract key value pairs before applying filters.
Depending on the type of log you are monitoring, different options for extracting key value pairs are utilized.
| Log Type | Description | Help Link |
|---|---|---|
| Event Logs | Uses Regular Expressions to extract values. | Define Log Entry Columns with Regular Expressions |
| Syslogs | Uses Regular Expressions to extract values. | Define Log Entry Columns with Regular Expressions |
| Text Logs | Uses Regular Expressions to extract values. | Define Log Entry Columns with Regular Expressions |
| CSV Files | Scans rows using column definitions. | Define Log Entry Columns with Separated Values |
| W3C Logs | Scans rows using column definitions. | Define Log Entry Columns with Separated Values |
To define column definitions:
- From the Column Definitions List, click the Add
button. A new line is added to the list. - Each column definition includes the following configurable parameters:
| Parameter | Description |
|---|---|
| Enabled | Enables or disables the column from the result set. |
| Key | Defines the value's key for log monitor filters and defines the column name for log consolidation database tables. |
| Name | Defines the display value for the column. |
| Data Type | Defines the value's data type for log monitor filters and defines the column data type for log consolidation database tables. |
| Column Size | When applied to a log consolidation template, defines the maximum size for a string column. |
| Index | When applied to a log consolidation template, creates a database index for the column. |
- Use the Up Button
and Down Button 
to reorder the column definitions.
Note
Multiple regular expressions enable you to test for different key value pairs. If the same key exists for multiple regular expression results, the last matching regular expression in the list is applied to the result set.
The following data types are supported:
| Data Type | Description |
|---|---|
| bool | A Boolean value, which can be either true or false. |
| byte | Unsigned 8-bit integer |
| short | Signed 16-bit integer |
| int | Signed 32-bit integer |
| long | Signed 64-bit integer |
| ushort | Unsigned 16-bit integer |
| uint | Unsigned 32-bit integer |
| ulong | Unsigned 64-bit integer |
| DateTime | A DateTime value that is parsed from a string using the current locale. |
| TimeSpan | A TimeSpan value that is parsed from a string using the current locale. |
| float | A 4-byte floating point value. |
| double | An 8-byte floating point value. |
| decimal | A 16-byte floating point value. |
| Level | An internal data type for mapping verbose log message level integer values to Levels (e.g. Info, Notice, Critical and Error). |
| File System Size | Unsigned 64-bit integer that is formatted to a file system size string value (e.g. 1 GB). |
| Percent | Signed 32-bit integer that is formatted to a percent string value. |
| Gauge | Signed 32-bit integer that is formatted to a percent then displays as a percentage graphic. |
Define Log Entry Columns with Regular Expressions