Hi
I need a query that will return the count of
- host:* , program:*
sql would be something like:
select host, program, count(*) group by 1,2
It is properly simple but I am missing something
Thanks
Jan
Help to create a query
Re: Help to create a query
Thanks for reaching out @jabi27,
You can access our documentation here: Log Server Docs
Here's a link I found that may answer your question
https://assets.nagios.com/downloads/nag ... Server.pdf
You can access our documentation here: Log Server Docs
Here's a link I found that may answer your question
https://assets.nagios.com/downloads/nag ... Server.pdf
Re: Help to create a query
It seems I'm missing it too--what is simple in SQL is hard in ES it seems.
Re: Help to create a query
Hi @jabi27,
I think what you're looking for is the value count aggregation. I'm not confident that you can use aggregations easily from the dashboard/query interface (you may have some luck with raw queries, I'm not as sure), but that's the closest match I was able to find.
Hopefully that helps - please let me know if you have any further questions or concerns.
-Sebastian Wolf
I think what you're looking for is the value count aggregation. I'm not confident that you can use aggregations easily from the dashboard/query interface (you may have some luck with raw queries, I'm not as sure), but that's the closest match I was able to find.
Hopefully that helps - please let me know if you have any further questions or concerns.
-Sebastian Wolf
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy