Splunk Search

Extracting / Plotting Splunk data

netwrkr
Communicator

Assume we have a log file with at least the following fields

  timestamp   field A   field B   field C .....

  ex:

  1316018215   u1       105        a
  1316018215   u2       30         a
  1316018215   u3       550        c
  1316018215   u2        21        a
  1316018215   u1       65         b
  1316018215   u3       105        a
  1316018215   u2        34        b
  1316018215   u1       105        c

The question: I would like to ask the following questions of this data

1. Plot for me a graph of Unique C vs. (sum of B for each unique C )
2. Plot for me a graph of Unique C vs. (sum of B for each unique C div count of occurrences).
0 Karma

Ayn
Legend

#1:

<yourbasesearch> | stats sum(B) by C

#2:

<yourbasesearch> | stats avg(B) by C
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...