Configure a Custom Log Parser
Configure a Custom Log Parser
You can configure a custom log parser if the predefined parsers do not extract events from your uploaded logs. You can customize your parser based on what you know about your logs. After creating a custom parser, it will appear on the Custom tab.
These are the primary steps to configuring a custom log parser:
- Upload
- Preparation
- Extraction
- Transformation
- Name
To configure a custom parser using a log file:
- On the Test/Create page, click Create Custom Parser.
- On the Upload page, click Select File. Locate and select a log file, and then click Upload.
- Click Test to process your log file. The results display on the Extracted Fields tab at the bottom of the page. You can use these bottom tabs to ensure that your log file data is being mapped correctly:
- Extracted Fields: This tab shows the columns that are extracted from your log file.
- Extracted Events: This tab shows the extracted events from your log file.
- Rejections: This tab shows the rejected log line number, line, and reason.
- Summary: This tab provides an overview of the total extracted lines, number of rejected lines, and the total uploaded lines.
Tip
The Test button and the bottom tabs display on all pages.
- On the Preparation page, select and enter the needed information on these tabs:
- Format: This tab opens with a default setting of CSV for format. To change the formatting, specify the following:
- Log file type: Choose CSV, Delimited, Key-Value, or Hybrid.
- Header in log: Specify whether the log has a header.
- Header starts with: Enter the text string that start the header.
- Line number: Enter the number of the starting line in the log.
- Header delimiter: Choose the type of delimiter from the dropdown.
- Pre-Filters: This tab allows you to pick data line patterns for your log file. Currently, the only supported Data Line Pattern is
80http443https
. In addition, you can define the Line/Header Patterns to discard, a regular expression that determines the log lines to discard. - Multi-Line Merge: Use this tab only if you have complex log files that contain lines that split into two lines. You can specify the following:
- Multi-line delimiters: Delimiter between lines.
- Log-line delimiter size: Delimiter size between log lines.
- Log-line delimiter match: Delimiter match between log lines.
- Format: This tab opens with a default setting of CSV for format. To change the formatting, specify the following:
- When finished, click Next.
- On the Extraction page, identify the file structure, timestamp, and fields for your log file. Fields: For field mapping, verify the log header of each specific field, like Source IP (required), Source (Src) Port, Destination IP or Destination Host or URL (required), Destination Port (required if only
- Structure: This tab allows you to specify the Field Delimiter (like comma, space, tab, colon, and so on), Field Enclosure (like double quotes, single quotes, or pipe character), and Line Enclosed Within (like square brackets, parenthesis, curly brackets, pipe character, or double quotes). Timestamp: This tab contains several fields that are important to mapping data correctly. The fields include:
- Timestamp Maps To: Identifies the location (column header) of the timestamp in your log file and map it to this field. Timestamp Format: In most cases you do not need to change a format except for some cases when the timestamp is in a unique epoch format, in which case you should select a format code like %H for the format field. Refer to the Timestamp Format Codes to see all the specific format codes. Enclosed Within: Select if the Timestamp is enclosed within square brackets, parenthesis, curly brackets, pipe character, or double quotes. Default Time Zone: Select your default GMT time zone for the log file.
Note
This is a required field and best practice is to map it to column 1.
- Timestamp Maps To: Identifies the location (column header) of the timestamp in your log file and map it to this field.
Destination IP or Destination Host is present), Action, and map them to the required field from Skope IT. For example, if the Source IP is in column 6, select column 6 from the dropdown list for the Source IP. Do this for all fields you want to map. - Structure: This tab allows you to specify the Field Delimiter (like comma, space, tab, colon, and so on), Field Enclosure (like double quotes, single quotes, or pipe character), and Line Enclosed Within (like square brackets, parenthesis, curly brackets, pipe character, or double quotes). Timestamp: This tab contains several fields that are important to mapping data correctly. The fields include:
- When finished, click Next.
- Click Test to process your log file. The results display on the tabs at the bottom of the page.
- Click Finish, enter a name for your custom parser, and then click Save.
Tip
Keep this Create Custom Parser window open if you want to create a Transformation Rule, which is explained in Transformation.
Timestamp Format Codes
Format Code | Description | Example |
---|---|---|
%a | Day of the week as locale’s abbreviated name | Wed |
%A | Day of the week as locale’s full Name | Wednesday |
%w | Weekday as a decimal number, where 0 is Sunday and 6 is Saturday | 3 for Wednesday |
%d | Day of the month as a zero-padded decimal number | 25 |
%b | Month as a locale’s abbreviated name | Dec |
%B | Month as a locale’s full name | December |
%m | Month as a zero-padded decimal number | 12 |
%y | The year without the century as a zero-padded decimal number | 15 or 2015 |
%Y | The year with the century as a decimal number | 2015 |
%H | Hours on a 24-hour clock as a zero-padded decimal number | 18 |
%I | Hours on a 12 hour clock | 06 |
%p | Locale’s equivalent of AM or PM | PM |
%M | Minutes as a zero-padded decimal number | 15 |
%S | Seconds as a zero padded decimal number | 30 |
%f | Microsecond as a decimal number, zero-padded on the left | 000000 |
%z | UTC offset in the form +HHMM or -HHMM (empty string if the object is naive) | -0800 |
%Z | Timezone name like GMT( empty string if naive) | PST |
%j | Day number of the year from the first of Jan as a zero-padded decimal number | 359 |
%U | Week number of the year as a zero-padded number. All days in the first week preceding the first Sunday are considered to be week 0 | 51 |
%W | Week number of the year as a zero-padded number. All days in the first week preceding the first Monday are considered to be week 0 | 02 (a zero-padded number for single digit weeks) or 36 |
%c | Locale’s appropriate date and time representation | Wed Dec 25 18:15:30 2015 |
%x | Locale appropriate date | 12/25/15 |
%X | Locale appropriate time | 18:15:30 |