Nagios Support Forum

Hello,
this is just feature request.

Create a plain report component, that would contain some basic filtering options (like in Availability report). These filtering options might by user customizable. In addition to this, this report component would have just one more text area - where we (customers) will write our custom SQL query.
So your job would be:

• create user interface integrated within Nagios XI for custom reports
• add ability to create custom filters for these reports
• add ability to create multiple custom reports
• add ability to save, schedule, send, download custom reports (this one is easy )
• display SQL query results in table (and later in pie charts, bar graphs,...)
• add ability to include these tables (pie charts,...) in dashboards

Our (customers,community) job would be:

• develop, use, share SQL commands (this forum is good place for it...)

I believe this could significantly improve reporting possibilities of Nagios XI and thus increase it's value for us.

What's your thoughts on this?

This sounds interesting. According to our developers, most of this is doable, but it will take some time to implement. You are welcome to file a feature request on our public tracker here:

http://tracker.nagios.com/

or I can file it for you (if you want me to). Thank you!

Great. Please fill that request.. Thanks.
I'd suggest start small - just one input box (title), text area for description, text area for sql query and (optional) 1 available macro (e.g. %currect_user_id%) that could be used in SQL queries(to be able to create personalized reports). This might slightly decrease time to implement (for version 1.0 )... and even without filtering this could be very usable.
After filling that request, I think you can lock this thread. Thanks again.

I filed an internal feature request (TASK ID 7724) and included a URL link to this post. Thank you!