Help to create a query

This support forum board is for support questions relating to Nagios Log Server, our solution for managing and monitoring critical log data.
Post Reply
jabi27
Posts: 34
Joined: Thu Jan 19, 2017 4:30 pm

Help to create a query

Post by jabi27 »

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
User avatar
danderson
Posts: 98
Joined: Wed Aug 09, 2023 10:05 am

Re: Help to create a query

Post by danderson »

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
kg2857
Posts: 233
Joined: Wed Apr 12, 2023 5:48 pm

Re: Help to create a query

Post by kg2857 »

It seems I'm missing it too--what is simple in SQL is hard in ES it seems.
User avatar
swolf
Developer
Posts: 294
Joined: Tue Jun 06, 2017 9:48 am

Re: Help to create a query

Post by swolf »

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