Page 1 of 1

Exporting data from Nagios Log Server

Posted: Tue May 31, 2016 8:36 am
by comfone
Hi All
Is it possible to export the filtered/listed information from Nagios Log Server to for example a csv file?
Thank you in advance for your help.

Re: Exporting data from Nagios Log Server

Posted: Tue May 31, 2016 9:21 am
by scottwilkerson
comfone wrote:Hi All
Is it possible to export the filtered/listed information from Nagios Log Server to for example a csv file?
Thank you in advance for your help.
Not at this time for CSV, it is possible to get the data via json for your query/filter

If you look at the table after performing your query, in the upper right side you will see an "i" (inspect) which will give you details on how to pull the table data and get the JSON return.

Re: Exporting data from Nagios Log Server

Posted: Thu Jun 30, 2016 3:55 am
by comfone
Thank you for your answer.
I tried that, but I get only 10 records back? :-(
Is this problem known on your side?

Re: Exporting data from Nagios Log Server

Posted: Thu Jun 30, 2016 9:22 am
by hsmith
Try putting &size=99999 at the end of your query if you use the API to do it. https://www.elastic.co/guide/en/elastic ... earch.html

Re: Exporting data from Nagios Log Server

Posted: Fri Jul 01, 2016 5:01 am
by comfone
It's not working. I still get only 10 recors.

"order": "desc",
"ignore_unmapped": true
}
},
{
"@timestamp": {
"order": "desc",
"ignore_unmapped": true
}
}
]
}&size=99999' -o /tmp/curl_results.txt

Re: Exporting data from Nagios Log Server

Posted: Mon Jul 04, 2016 12:48 am
by Box293
This forum post here explains the 10 size limit:

https://support.nagios.com/forum/viewto ... 70#p152130

Does this help?

Re: Exporting data from Nagios Log Server

Posted: Tue Jul 05, 2016 5:02 am
by comfone
No it doesn't. If I put the size on the beginning it gives me an error.
It seams, that there is a feature request pending. Do you have any update on the progress?

Re: Exporting data from Nagios Log Server

Posted: Tue Jul 05, 2016 9:30 am
by hsmith
Unfortunately, I do not have any update as to the progress on this particular feature. I'll pin this tab and see if I can get a better answer on the number of query results this afternoon. Just getting back from a four day weekend, it's a busy one.

Re: Exporting data from Nagios Log Server

Posted: Tue Jul 05, 2016 2:15 pm
by hsmith
Can you try with the size of 250?

Re: Exporting data from Nagios Log Server

Posted: Tue Jul 05, 2016 4:49 pm
by Box293
comfone wrote:No it doesn't. If I put the size on the beginning it gives me an error.
It seams, that there is a feature request pending. Do you have any update on the progress?
Can you paste the command and the error it is producing please.