NBA Finals 2015

I recently posted a blog about Splunking my golf swing and afterwards a co-worker asked if I could Splunk the NBA finals. He gave me some NBA data and while on a flight today I decided to look into the data a little with Splunk. I don’t know very much about basketball and you all probably have way better questions to ask of the data; nevertheless I gave it a shot on my flight. Note: CLE=Cleveland and GSW=Golden State Warriors

Each file had the date of the game and who played where as the filename.

Since it was csv I imported it as such and set timestamp based on the date and “elapsed”.…

» Continue reading

All aboard with Infrastructure 4.0 — Splunk wins Deutsche Bahn Internet of Things Hackathon

Deutsche Bahn (DB) describes itself as the second largest transport company in the world and is the largest railway and infrastructure operator in Europe. With the popularity of Industry 4.0 and IoT in Germany, DB recently ran a “Deutsche Bahn goes 4.0” Hackathon over the weekend of May 8-9 2015. The concept was “We provide the data, you innovate with it”. Splunk participated with a crack team of two people, a copy of Splunk Enterprise running on a laptop and got their hands dirty digging into a labyrinth of infrastructure data. The challenge was tough: starting at 5pm we had 24 hours straight to analyze the data and demonstrate the value from it. After the final presentation of …

» Continue reading

Make it flash! Make it flash!

Splunk Traffic Lights

Splunk ships with some really neat visualisation options. From bar charts to gauges. Though sometimes they just don’t fit your requirements.

Wether that be something as simple as an custom icon or a super-slick D3 visualisation, Splunk’s framework makes it really easy to display your data in many number of ways.

One of the things I get asked a lot is: “Can we have a traffic light?”. The answer – yes! Let me show you how to light Splunk up in this post.…

» Continue reading

Mission Critical Analytics – Everywhere

You are so incredibly awesome.

That’s what I wanted to call the new release of Splunk Enterprise announced today, but instead we went with Splunk Enterprise 6.1. What this release represents is pretty remarkable. Why? Because it’s defined by what we see you do.

You’ve made machine data a valuable asset in your organization. Whether you’re in IT, on the applications team or on the security team, you’ve helped yield powerful results for the company you work for. So valuable that machine data insights are now more mission critical than ever.

You’re changing how you analyze data—you’re comfortable exploring and analyzing data, knowing that Splunk software will eat just about anything you throw at it and give you answers …

» Continue reading

Custom Icons in Splunk 6 Tables

“Daddy. DADDY! We’re out of Sriracha. Does Costco sell Sriracha? Can you go get some before you start working today?”

That was my five-year-old son at breakfast this morning, after he turned the Sriracha bottle upside down and banged the heck out of the bottom of the rooster-adorned bottle with his tiny fist, trying to get the last bits of the dark-red chili sauce deposited onto his scrambled eggs.

While I’m certain we will solve the 2014 Sriracha Crisis at the Brodsky household, the whole episode reminded me of a question (stick with me, you’ll see why) that a Splunk customer asked me a few months ago, which went something like this:

“When creating a dashboard in Splunk 6,

» Continue reading

Show/Hide a Dashboard Panel Based on a Search Result

Today’s post will build two of my previous posts about pivoting a single row table and toggling visibility of dashboard panels.  In the post about pivoting a table, one of the fields in the table was an IP address.  Wouldn’t it be nice to run the iplocation command on the IP address and display where the user was logging in from on a map?  Yeah, that would be cool, but only if we had something to map.  Otherwise, we just have an empty map.

So, what we will be doing today is use a post process search on the IP address to get the geostats.  Then, if this post process search returns results, we will dynamically display …

» Continue reading

Pivot a Single Row Table with a DataTemplate View

PowerShell has some cool object formatting features.  Two of the most common are called Format-Table and Format-List.  You can think of a Splunk Table as a Format-Table view, but what if you want to format your results as a list?  This is especially helpful when you have a one-row table that starts to push the boundaries of your screen.  Wouldn’t it be nice if you could pivot your table to have the headers as one column and the data as another?  Well, with a DataTemplate View, you can do this very easily.


What We Will Be Doing

We will be turning this:

Into this:


How It Is Done – Step 1 – Create a HTML dashboard

The …

» Continue reading

Toggle Visibility of Dashboard Components with jQuery

Sometimes a dashboard can become too busy to focus. This is especially true when you have both summary and detailed data on a Key Performance Indicator (KPI) dashboard. An example of this would be the Citrix XenApp app User Experience dashboard as seen below:

This dashboard scores the various components that impact a user’s experience – things like network latency, server performance, hypervisor performance, shared storage latency, Netscaler throughput, etc.  There is just too much information to show all at once, so we hide parts of the dashboard and allow the user to view the detailed information of only what they want to see.


Toggle with Simple XML

Adding toggle buttons to hid/show parts of your dashboard isn’t all …

» Continue reading

Big data and financial services – an EMEA perspective

I was lucky enough to attend the first day of the “Big Data in Financial Services” event in London a few days ago. I know some people might not think of that as lucky but I say it on the back of a surprisingly varied agenda, entertaining speakers and a lot of good debate and content on what big data means to FS companies and how they are using it.

The key point that I took away was that right now, FS companies are using big data today to focus on operational issues – risk, efficiency, compliance, security and making better decisions. However, there is a growing trend in FS companies looking at how big data is going …

» Continue reading

Splunking Exchange in a Simple XML World

With the release of Splunk 5.0, the Simple XML language we use to define the dashboards and forms for an app was greatly extended. So, we were given a challenge – could a reasonably complex app, such as the Splunk App for Microsoft Exchange – be represented using only Simple XML?
» Continue reading