Blog Feed Post

Splunk Geostats: Because Where in the World Is It?

Splunk has many compelling features. For me, the most advantageous features are often the built-in capabilities that allow users to make use of the data being fed into Splunk. A long-time favorite has been Splunk’s data visualization modules, specifically, geostats. Geostats can give data sets value by giving them global, national, and local level perspectives. Let’s take a look at how to put this visualizer to use. 

My first idea, to utilize this visualizer, was to map out the geographic location of where possible “cyber attacks” (as noted by IDS/SEIM) are potentially coming from. This was done using the following search:

(Note: the source and destination IP depend on the type of IDS event your system might be using. For the purpose of this demonstration, we are going to assume via a tag that we only have IDS events where the “Source IP” is the “offending” IP address).

<search to call IDS data> | iplocation “Source IP” | geostats latfield=lat longfield=lon count by Signature globallimit=0

Geo Location Search

It’s recommended to refine the initial data set to show only attacks known from a specific threat actor, or a specific type of (unique) attack. This will help determine if there was a pattern in the exit nodes your adversary may be attacking you from, and therefore be more useful to an intelligence team.

Another use of the geostats visualizer is to keep an eye on failed services or systems. This will include something like a number of Point of Sales (POS) systems that are no longer ‘checking in’, or perhaps a list of ‘failed connections’ from a calling service you provide. Again, this is another way to look for anomalous occurrences.  

For this example, I created a CSV containing three distinctive locations. I created this through the iplocation mapping again. If the locations are not mobile (like a store), I would recommend having a static geographical address assigned to that data’s location instead of, or in addition to, a global IP address.

In this example, I assumed that you are a supermarket retailer with three similar size locations. At this time of day, having more than 15 POS systems not “checking in” could be indicating something is wrong with the networking in that area. To visualize this, I processed the data with the follow search:

| iplocation "Source IP" | geostats latfield=lat longfield=lon count as TOTAL | eval redCount = if(TOTAL >=15, TOTAL, 0) | eval greenCount = if(TOTAL <15, TOTAL,0) | fields - TOTAL

The first step was to plot my data on the geomap.

| geostats latfield=lat longfield=lon count as TOTAL

With the data plotted, I created a range map with descriptive names I wanted to use as my colors.

| eval redCount = if(TOTAL >=15, TOTAL, 0) | eval greenCount = if(TOTAL <15, TOTAL,0)

Then finally I removed the TOTAL field

| fields - TOTAL

Now, to bring these colors to life, I saved my search to a dashboard and went into splunk’s XML source editor and added the following line:

<option name="mapping.fieldColors">{greenCount:0x00b200,redCount:0xfb0000}</option>

XML Source Editor

With not much effort, Splunk now presents us with an excellent map showing where a networking problem might be brewing at our store in the Detroit area.

Detroit Visual

These two explain just the tip of the iceberg of what one can achieve with Splunk’s visualization capabilities. For more information on geostats, check out Splunk’s official documentation.

Read the original blog entry...

More Stories By Hurricane Labs

Christina O’Neill has been working in the information security field for 3 years. She is a board member for the Northern Ohio InfraGard Members Alliance and a committee member for the Information Security Summit, a conference held once a year for information security and physical security professionals.

Latest Stories
Dynatrace is an application performance management software company with products for the information technology departments and digital business owners of medium and large businesses. Building the Future of Monitoring with Artificial Intelligence. Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more busine...
Having been in the web hosting industry since 2002, dhosting has gained a great deal of experience while working on a wide range of projects. This experience has enabled the company to develop our amazing new product, which they are now excited to present! Among dHosting's greatest achievements, they can include the development of their own hosting panel, the building of their fully redundant server system, and the creation of dhHosting's unique product, Dynamic Edge.
This session will provide an introduction to Cloud driven quality and transformation and highlight the key features that comprise it. A perspective on the cloud transformation lifecycle, transformation levers, and transformation framework will be shared. At Cognizant, we have developed a transformation strategy to enable the migration of business critical workloads to cloud environments. The strategy encompasses a set of transformation levers across the cloud transformation lifecycle to enhance ...
Your job is mostly boring. Many of the IT operations tasks you perform on a day-to-day basis are repetitive and dull. Utilizing automation can improve your work life, automating away the drudgery and embracing the passion for technology that got you started in the first place. In this presentation, I'll talk about what automation is, and how to approach implementing it in the context of IT Operations. Ned will discuss keys to success in the long term and include practical real-world examples. Ge...
The challenges of aggregating data from consumer-oriented devices, such as wearable technologies and smart thermostats, are fairly well-understood. However, there are a new set of challenges for IoT devices that generate megabytes or gigabytes of data per second. Certainly, the infrastructure will have to change, as those volumes of data will likely overwhelm the available bandwidth for aggregating the data into a central repository. Ochandarena discusses a whole new way to think about your next...
So the dumpster is on fire. Again. The site's down. Your boss's face is an ever-deepening purple. And you begin debating whether you should join the #incident channel or call an ambulance to deal with his impending stroke. Yes, we know this is a developer's fault. There's plenty of time for blame later. Postmortems have a macabre name because they were once intended to be Viking-like funerals for someone's job. But we're civilized now. Sort of. So we call them post-incident reviews. Fires are ne...
Lori MacVittie is a subject matter expert on emerging technology responsible for outbound evangelism across F5's entire product suite. MacVittie has extensive development and technical architecture experience in both high-tech and enterprise organizations, in addition to network and systems administration expertise. Prior to joining F5, MacVittie was an award-winning technology editor at Network Computing Magazine where she evaluated and tested application-focused technologies including app secu...
CloudEXPO New York 2018, colocated with DevOpsSUMMIT and DXWorldEXPO New York 2018 will be held November 12-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI and Machine Learning to one location.
CloudEXPO | DevOpsSUMMIT | DXWorldEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need to realize their goals. Sponsors of DXWorldEXPO | CloudEXPO benefit from unmatched branding, profile building and lead generation opportunities.
ICC is a computer systems integrator and server manufacturing company focused on developing products and product appliances to meet a wide range of computational needs for many industries. Their solutions provide benefits across many environments, such as datacenter deployment, HPC, workstations, storage networks and standalone server installations. ICC has been in business for over 23 years and their phenomenal range of clients include multinational corporations, universities, and small busines...
This sixteen (16) hour course provides an introduction to DevOps, the cultural and professional movement that stresses communication, collaboration, integration and automation in order to improve the flow of work between software developers and IT operations professionals. Improved workflows will result in an improved ability to design, develop, deploy and operate software and services faster.
Headquartered in Plainsboro, NJ, Synametrics Technologies has provided IT professionals and computer systems developers since 1997. Based on the success of their initial product offerings (WinSQL and DeltaCopy), the company continues to create and hone innovative products that help its customers get more from their computer applications, databases and infrastructure. To date, over one million users around the world have chosen Synametrics solutions to help power their accelerated business or per...
All in Mobile is a place where we continually maximize their impact by fostering understanding, empathy, insights, creativity and joy. They believe that a truly useful and desirable mobile app doesn't need the brightest idea or the most advanced technology. A great product begins with understanding people. It's easy to think that customers will love your app, but can you justify it? They make sure your final app is something that users truly want and need. The only way to do this is by ...
Authorization of web applications developed in the cloud is a fundamental problem for security, yet companies often build solutions from scratch, which is error prone and impedes time to market. This talk shows developers how they can (instead) build on-top of community-owned projects and frameworks for better security.Whether you build software for enterprises, mobile, or internal microservices, security is important. Standards like SAML, OIDC, and SPIFFE help you solve identity and authenticat...
The digital transformation is real! To adapt, IT professionals need to transform their own skillset to become more multi-dimensional by gaining both depth and breadth of a wide variety of knowledge and competencies. Historically, while IT has been built on a foundation of specialty (or "I" shaped) silos, the DevOps principle of "shifting left" is opening up opportunities for developers, operational staff, security and others to grow their skills portfolio, advance their careers and become "T"-sh...