Home » Search Logs > Extract New Fields

Extract New Fields to Parse and Index Logs


Network Administrators are always in need of more information and insights from their log data. There are times when an IT administrator would identify some log information which is useful and would like to have it indexed automatically as a new field.  Having more fields being indexed makes your log data more useful while conducting log forensics analysis and creating network security reports.

EventLog Analyzer allows administrators to (extract or) create custom (new) fields from raw logs by using the interactive Field Extraction UI to create regular expression (RegEx) patterns to help EventLog Analyzer to identify, parse and index these custom fields from new logs it receives from network systems and applications.

 

Procedure to extract new fields

In the Search screen, select the host(s) or host group(s), if unsure leave it blank. Leaving it blank will search all the hosts of the host groups. Select the log type for which you want to extract new fields. To narrow down the logs, enter specific word(s) in the search query text box, if you are unsure leave it blank. Leaving it blank will list all the log entries in the result. Click Go button. This will list the results for the above mentioned search. Use the Wrench icon of the particular log entry from which you want to extract the new field(s).

Step 1: Edit the log type and view the existing fields

 

Extract Field - Step1

 

  1. Edit the Log Type display name, if it is not default log type. For non-default log types, the display name will be name of the imported log file or hostname/port

  2. View the details of the 'Existing Fields' with the help of Show and Show All links.

 

Step 2: Select the required custom field value(s) and specify the details

 

Extract Field - Step2

 

  1. Select and click the word(s) in the message, to be extracted as field

  2. Provide a name for this field. Optinally, specify the prefix and suffix to the field value

  3. Click on Create Pattern to generate a parser rule pattern

Note: The word(s)/character(s) preceding and succeding the selected field value are called, Prefix and Suffix. These are used as identifiers to extract the fields exactly. The prefix and suffix can have a static value (Exact Match) or dynamic value (Similar Pattern) or they can be ignored.

Example for Static and Dynamic value for Prefix and Suffix

Message : Successful Network Logon: User Name: sylvian Domain: ADVENTNET Logon ID: (0x0,0x6D51131) Logon Type: 3 Logon Process: NtLmSsp Authentication Package: NTLM Workstation Name: SYLVIAN Logon GUID: - Caller User Name: - Caller Domain: - Caller Logon ID: - Caller Process ID: - Transited Services: - Source Network Address: 192.168.113.97 Source Port: 0 22873

The prefix Logon Type can be a static value as most of the logs will have the exact word as 'Logon Type' where as 'Source Network Address' can be dynamic as the logs may have different word(s) like, Source IP Address, Source Address, but with same pattern.

If the prefix and suffix are defined with exact match, the field extraction will be precise.

 

Step 3: Validate the pattern and save it to extract the new field

 

Extract Field - Step3

 

  1. A parser rule pattern is created using the field definition. You can edit the generated pattern manually, if you are familiar with regular expression

  2. Validate link is used to test the generated pattern against the previous search results. You can manually check the suitability of the pattern by analyzing the 'Matched Log Messages' and 'Unmatched Log Messages' displayed.

  3. Optionally, click on Choose another Pattern to choose a pattern from a list of patterns generated by the application

  4. Optionally, you can define any existing field matching criteria to apply the pattern for this specific log type

  5. Save the pattern to extract the field(s) from the upcoming logs. The saved pattern will be listed in the Settings tab under

  6. Custom Pattern Settings section

  7. Use the Ask Support button, if you face any problem and get assistance from the EventLog Analyzer team

 

Screen shot of Validate check

 

Extract Field - Step4

 

 

Screen shot of patterns generated by the application

 

Extract Field - Step5

 

 

 
Copyright © 2013, ZOHO Corp. All Rights Reserved.
ManageEngine