Book Image

Data Analytics Using Splunk 9.x

By : Dr. Nadine Shillingford
5 (1)
Book Image

Data Analytics Using Splunk 9.x

5 (1)
By: Dr. Nadine Shillingford

Overview of this book

Splunk 9 improves on the existing Splunk tool to include important features such as federated search, observability, performance improvements, and dashboarding. This book helps you to make the best use of the impressive and new features to prepare a Splunk installation that can be employed in the data analysis process. Starting with an introduction to the different Splunk components, such as indexers, search heads, and forwarders, this Splunk book takes you through the step-by-step installation and configuration instructions for basic Splunk components using Amazon Web Services (AWS) instances. You’ll import the BOTS v1 dataset into a search head and begin exploring data using the Splunk Search Processing Language (SPL), covering various types of Splunk commands, lookups, and macros. After that, you’ll create tables, charts, and dashboards using Splunk’s new Dashboard Studio, and then advance to work with clustering, container management, data models, federated search, bucket merging, and more. By the end of the book, you’ll not only have learned everything about the latest features of Splunk 9 but also have a solid understanding of the performance tuning techniques in the latest version.
Table of Contents (18 chapters)
1
Part 1: Getting Started with Splunk
5
Part 2: Visualizing Data with Splunk
10
Part 3: Advanced Topics in Splunk

Adding reports and drilldowns to dashboards

The dashboard panels we have created so far are powered by inline searches. We can also create panels where the search results are generated by reports. Let’s start by generating a report using one of the charts we created in Chapter 6, Creating Tables and Charts Using SPL. Enter the following query in the search bar:

index=botsv1 sourcetype=wineventlog EventCode=4624
| stats values(Account_Name) as users by host

This query generates the Account_Name property of all the users who successfully logged in to Windows grouped via the host device. Figure 7.33 shows the results:

Figure 7.33 – Successful Windows logins

Figure 7.33 – Successful Windows logins

Let’s save these new results as a new report by clicking the Save As dropdown and selecting Report (see Figure 7.34):

Figure 7.34 – Saving as a report

Figure 7.34 – Saving as a report

Enter the following in the Save As Report dialog box and leave the remaining options as...