Course Content
This three-hour module is for power users who want to use commands to manipulate output and normalize data. Topics will focus on specific commands for manipulating fields and field values, modifying result sets, and managing missing data. Additionally, students will learn how to use specific eval command functions to normalize fields and field values across multiple data sources.
Who should attend
Search Experts and Knowledge Managers
Certifications
This course is part of the following Certifications:
Prerequisites
To be successful, students should have a solid understanding of the following:
- How Splunk works
- Creating search queries
- Knowledge objects
Course Objectives
- Manipulating Output
- Modifying Result Sets
- Managing Missing Data
- Modifying Field Values
- Normalizing with eval
Outline: Result Modification (SRM)
Topic 1 - Manipulating Output
- Convert a 2-D table into a flat table with the untable command
- Convert a flat table into a 2-D table with the xyseries command
Topic 2 - Modifying Result Sets
- Append data to search results with the appendpipe command
- Calculate event statistics with the eventstats command
- Calculate "streaming" statistics with the streamstats command
- Modify values to segregate events with the bin command
Topic 3 - Managing Missing Data
- Find missing and null values with the fillnull command
Topic 4 - Modifying Field Values
- Understand the eval command
- Use conversion and text eval functions to modify field values
- Reformat fields with the foreach command
Topic 5 - Normalizing with eval
- Normalize data with eval functions
- Identify eval functions to use for data and field normalization