3. Tables, Charts, and Fields | Implementing Splunk (Update)

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Implementing Splunk (Update)

By : VINCENT BUMGARNER, James D. Miller

4.5 (4)

Implementing Splunk (Update)

4.5 (4)

By: VINCENT BUMGARNER, James D. Miller

Overview of this book

If you are a data analyst with basic knowledge of Big Data analysis but no knowledge of Splunk, then this book will help you get started with Splunk. The book assumes that you have access to a copy of Splunk, ideally not in production, and many examples also assume you have administrator rights.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. The Splunk Interface

1. The Splunk Interface

Logging into Splunk

The home app

The top bar

The search & reporting app

Using the time picker

Using the field picker

The settings section

Summary

2. Understanding Search

2. Understanding Search

Using search terms effectively

Boolean and grouping operators

Clicking to modify your search

Using fields to search

Using wildcards efficiently

All about time

Making searches faster

Sharing results with others

Search job settings

Saving searches for reuse

Creating alerts from searches

Summary

3. Tables, Charts, and Fields

3. Tables, Charts, and Fields

About the pipe symbol

Using top to show common field values

Using stats to aggregate values

Using chart to turn data

Using timechart to show values over time

Working with fields

Summary

4. Data Models and Pivots

4. Data Models and Pivots

What is a data model?

What does a data model search?

Creating a data model

Lookup attributes

What is a pivot?

A quick example

Sparklines

Summary

5. Simple XML Dashboards

5. Simple XML Dashboards

The purpose of dashboards

Using wizards to build dashboards

Converting the panel to a report

Back to the dashboard

Editing XML directly

UI examples app

Building forms

Features replaced

Autorun dashboard

Scheduling the generation of dashboards

Summary

6. Advanced Search Examples

6. Advanced Search Examples

Using subsearches to find loosely related events

Using transaction

Determining concurrency

Calculating events per slice of time

Rebuilding top

Acceleration

Summary

7. Extending Search

7. Extending Search

Using tags to simplify search

Using event types to categorize results

Using lookups to enrich data

Using macros to reuse logic

Creating workflow actions

Using external commands

Summary

8. Working with Apps

8. Working with Apps

Defining an app

Included apps

Installing apps

Building your first app

Editing navigation

Customizing the appearance of your app

Object permissions

The app directory structure

Summary

9. Building Advanced Dashboards

9. Building Advanced Dashboards

Reasons for working with advanced XML

Reasons for not working with advanced XML

The development process

The advanced XML structure

Converting simple XML to advanced XML

Module logic flow

Understanding layoutPanel

Reusing a query

Using intentions

Creating a custom drilldown

Third-party add-ons

10. Summary Indexes and CSV Files

10. Summary Indexes and CSV Files

Understanding summary indexes

When to use a summary index

When not to use a summary index

Populating summary indexes with saved searches

Using summary index events in a query

Using sistats, sitop, and sitimechart

How latency affects summary queries

How and when to backfill summary data

Reducing summary index size

Calculating top for a large time frame

Using CSV files to store transient data

Summary

11. Configuring Splunk

11. Configuring Splunk

Locating Splunk configuration files

The structure of a Splunk configuration file

The configuration merging logic

An overview of Splunk .conf files

User interface resources

Summary

12. Advanced Deployments

12. Advanced Deployments

Planning your installation

Splunk instance types

Common data sources

Sizing indexers

Planning redundancy

Working with multiple indexes

Deploying the Splunk binary

Using apps to organize configuration

Configuration distribution

Using LDAP for authentication

Using Single Sign On

Load balancers and Splunk

Multiple search heads

Summary

13. Extending Splunk

13. Extending Splunk

Writing a scripted input to gather data

Using Splunk from the command line

Querying Splunk via REST

Writing commands

Writing a scripted lookup to enrich data

Writing an event renderer

Writing a scripted alert action to process results

Hunk

Summary

Index

Index

Using stats to aggregate values

While top is very convenient, stats is extremely versatile. The basic structure of a stats statement is:

stats functions by fields

Many of the functions available in stats mimic similar functions in SQL or Excel, but there are many functions unique to Splunk. The simplest stats function is count. Given the following query, the results will contain exactly one row, with a value for the field count:

sourcetype=tm1* error | stats count

Using the by clause, stats will produce a row per unique value for each field listed, which is similar to the behavior of top. Run the following query:

sourcetype=tm1* error | stats count by date_month date_wday

It will produce a table like that shown in the following screenshot:

There are a few things to notice about these results:

The results are sorted against the values of the by fields, in this case date_month followed by date_wday. Unlike top, the largest value will not necessarily be at the top of the list. You can sort in the...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Implementing Splunk (Update)

Search

Your notes and bookmarks