Exporting data from Nagios Log Server

This support forum board is for support questions relating to Nagios Log Server, our solution for managing and monitoring critical log data.
Locked
comfone
Posts: 127
Joined: Fri May 01, 2015 3:28 am

Exporting data from Nagios Log Server

Post 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.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Exporting data from Nagios Log Server

Post 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.
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
comfone
Posts: 127
Joined: Fri May 01, 2015 3:28 am

Re: Exporting data from Nagios Log Server

Post by comfone »

Thank you for your answer.
I tried that, but I get only 10 records back? :-(
Is this problem known on your side?
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:

Re: Exporting data from Nagios Log Server

Post 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
Former Nagios Employee.
me.
comfone
Posts: 127
Joined: Fri May 01, 2015 3:28 am

Re: Exporting data from Nagios Log Server

Post 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
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: Exporting data from Nagios Log Server

Post by Box293 »

This forum post here explains the 10 size limit:

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

Does this help?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
comfone
Posts: 127
Joined: Fri May 01, 2015 3:28 am

Re: Exporting data from Nagios Log Server

Post 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?
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:

Re: Exporting data from Nagios Log Server

Post 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.
Former Nagios Employee.
me.
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:

Re: Exporting data from Nagios Log Server

Post by hsmith »

Can you try with the size of 250?
Former Nagios Employee.
me.
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: Exporting data from Nagios Log Server

Post 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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked