Result Modification

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.

Days : 1
Price :

This product is currently out of stock and unavailable.

Description

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