How to export query results to a text file?

This support forum board is for support questions relating to Nagios Log Server, our solution for managing and monitoring critical log data.
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: How to export query results to a text file?

Post by mcapra »

I made this thing a while back:
https://github.com/mcapra/nagios-nlsexport

It's a bit complicated if you aren't comfortable with Elasticsearch queries, though. Or if you just want everything from a single day's index, or a certain type of events from X days indices, you can skip the query part. If you're running it from the NLS machine itself, you can just use localhost for the -host argument.

If it breaks or you're not sure how to do something with it, best to post on the GitHub page.
Former Nagios employee
https://www.mcapra.com/
User avatar
eloyd
Cool Title Here
Posts: 2190
Joined: Thu Sep 27, 2012 9:14 am
Location: Rochester, NY
Contact:

Re: How to export query results to a text file?

Post by eloyd »

I'd still like to see an "export" button that includes at least a CSV option. The data is already there. I don't know why the button is not.
Image
Eric Loyd • http://everwatch.global • 844.240.EVER • @EricLoyd
I'm a Nagios Fanatic! • Join our public Nagios Discord Server!
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: How to export query results to a text file?

Post by dwhitfield »

This is still an open feature request, by which I mean it has not been denied. Trevor is out until Tuesday, and he'll be catching up then. Perhaps checking on this on Wednesday next week. I know Trevor has pushed the devs on this particular issue in the past.
User avatar
eloyd
Cool Title Here
Posts: 2190
Joined: Thu Sep 27, 2012 9:14 am
Location: Rochester, NY
Contact:

Re: How to export query results to a text file?

Post by eloyd »

I know he has, too. And I know where he is. And I know his cell phone number. :-) I just want to be on record that it's been a year with no word about this particular improvement.
Image
Eric Loyd • http://everwatch.global • 844.240.EVER • @EricLoyd
I'm a Nagios Fanatic! • Join our public Nagios Discord Server!
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: How to export query results to a text file?

Post by dwhitfield »

@onthax, anyone else...let us know if you are still interested in this feature.
onthax
Posts: 11
Joined: Mon Aug 17, 2015 10:26 pm

Re: How to export query results to a text file?

Post by onthax »

@dwhitfield

Yes, still need this feature.
currently we store 2 copies of all logs so we can give vendors logs for their product.
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: How to export query results to a text file?

Post by dwhitfield »

Thanks @onthax!

@robjohn, what about you?
jkatz
Posts: 9
Joined: Wed Sep 06, 2017 4:36 pm

Re: How to export query results to a text file?

Post by jkatz »

Also would like this feature. We installed a PoC of NLS back in April and the lack of this feature was a show-stopper. Just checked again and downloaded a current version and was somewhat dismayed that it is still the same version.

The product roadmap says NLS v2 is due Q4 of this year. Unfortunately, there is no mention of this feature on that list. Is this feature still a priority?

I realize that data can be exported via methods mentioned above, but that is not feasible for most of the people that will be using the portal.

Just need a button that prompts to download a CSV with the syslog data.
User avatar
eloyd
Cool Title Here
Posts: 2190
Joined: Thu Sep 27, 2012 9:14 am
Location: Rochester, NY
Contact:

Re: How to export query results to a text file?

Post by eloyd »

Agreed. This post was originally opened in August of 2015. 2015! That's over two years ago. I know that there's been a lot of development work on other projects within Nagios, but as @jkatz said, a simple "export CSV" button would solve 99% of everyone's requests for this feature.
Image
Eric Loyd • http://everwatch.global • 844.240.EVER • @EricLoyd
I'm a Nagios Fanatic! • Join our public Nagios Discord Server!
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: How to export query results to a text file?

Post by scottwilkerson »

eloyd wrote:Agreed. This post was originally opened in August of 2015. 2015! That's over two years ago. I know that there's been a lot of development work on other projects within Nagios, but as @jkatz said, a simple "export CSV" button would solve 99% of everyone's requests for this feature.
I put this on the roadmap and should be included when 2.0.0 is released.

https://www.nagios.com/roadmaps/
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked