How to graph numeric values from messages

This support forum board is for support questions relating to Nagios Log Server, our solution for managing and monitoring critical log data.
opene2
Posts: 18
Joined: Wed Apr 27, 2016 4:46 pm

How to graph numeric values from messages

Post by opene2 »

I am extracting numeric values from log messages. How can I graph the actual values (not how many times that they occur)?

I've tried with the following but no luck. I am still getting graphs based on how many times that the value occurs in the messages rather than the actual number.

# Partial filter
%{NUMBER:value:int}
NLS.png
Thanks in advance.
You do not have the required permissions to view the files attached to this post.
User avatar
eloyd
Cool Title Here
Posts: 2188
Joined: Thu Sep 27, 2012 9:14 am
Location: Rochester, NY

Re: How to graph numeric values from messages

Post by eloyd »

You you extracting the portion of the text that contains the number must be parsed into its own field. Then you can graph that field as a number. The basic of how to do this are explained in https://www.elastic.co/guide/en/logstas ... -grok.html, and there are a lot of examples on the web. If you have specific examples you can share about your data, we may be able to help you provide a working filter expression.

Assuming that you are extracting the number into its own field, and you want to graph that number itself, then one option is to make a histogram using the field that you are for as its field value and a chart type of "total." Look at the Apache Dashboard that came with NLS for some inspiration on how you can graph numbers or totals of numbers.
Image
Eric Loyd • http://everwatch.global • 844.240.EVER • @EricLoyd
I'm a Nagios Fanatic! • Join our public Nagios Discord Server!
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1

Re: How to graph numeric values from messages

Post by hsmith »

Also, can you please provide a screenshot of the log, and possibly a mock-up of how you want this done?
Former Nagios Employee.
me.
opene2
Posts: 18
Joined: Wed Apr 27, 2016 4:46 pm

Re: How to graph numeric values from messages

Post by opene2 »

Thanks to both of you. I've changed chart value/type to "mean" (instead of the default value "count") and I was able to generate the graph I wanted.

1) Yes, I am extracting the portion of the text that contains the number.
2) Correct, I want to graph the number itself.

Thanks again.
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: How to graph numeric values from messages

Post by rkennedy »

Are we good to mark this thread as resolved?
Former Nagios Employee
opene2
Posts: 18
Joined: Wed Apr 27, 2016 4:46 pm

Re: How to graph numeric values from messages

Post by opene2 »

Yes.