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!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...