Splunk Search

Use value in log file to draw chart

webantsug
Explorer

Dear Splunkies,

I am very happy with Splunk so far, but ran into one issue, I stuck.

I got a log file, containing a timestamp and a value, example below:

2015-05-18 1:53:30 Count=12

I want to use the Count (here 12) as value to display a chart but it usually displays a list of Count entire, found in my log file.

I'm pretty sure it's a very simple thing, but right now I don't see it.

Please advice.

Thanks very much

T.

0 Karma
1 Solution

webantsug
Explorer

Hi again.
I found a solution, by using field extractor to describe a field named "UserCount". then I used the following query to create a bar chart:

source="/opt/webants-dns/logs/ddnscount.log" | stats avg(UserCount) by _time | reverse | head 10

Thank you all.

T.

View solution in original post

0 Karma

webantsug
Explorer

Hi again.
I found a solution, by using field extractor to describe a field named "UserCount". then I used the following query to create a bar chart:

source="/opt/webants-dns/logs/ddnscount.log" | stats avg(UserCount) by _time | reverse | head 10

Thank you all.

T.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

What does your failing search look like?

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In April, the Splunk Threat Research Team had 2 releases of new security content via the Enterprise Security ...

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...

It’s go time — Boston, here we come!

Are you ready to take your Splunk skills to the next level? Get set, because Splunk University is back, and ...