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
.conf21 CFS Extended through 5/20!

Don't miss your chance
to share your Splunk
wisdom in-person or
virtually at .conf21!

Call for Speakers has
been extended through
Thursday, 5/20!