Show all host to hostgroup and parent relations

[cwscribner]

Hi all.

Is there a way to get a human readable list of all the host/hostgroup and parent host relationships? Perhaps a plugin or direct database query?

[mguthrie]

You can look at the network status map and it will show a visual representation of these relationships. I don't think there's a list representation of this anywhere though.

[cwscribner]

Any ideas on how I might be able to obtain one? The status map is unreadable because of the amount of devices I have. I also tried hypermap and Nagvis but have the same issues with those. They're displying ~2500 devices in a very poor fashion.

[mguthrie]

I think the backend API has some of that data there, I'll take a peek at it early next week and see what it would take to create something like that.

[cwscribner]

Just wanted to follow up on this. Any ideas?

[mguthrie]

There is a backend API call to get an XML list of all parent hosts.
http://<youraddress>/nagiosxi/backend/?cmd=getparenthosts

As far as host to hostgroup relationships, the clearest visual representation of that will still probably be the "Hostgroup Overview."

As far as a human readable view of these relationships that's not a mapping tool, what are your thoughts on having something like the Nagios BPI view for those relationships. Currently Nagios BPI is a grouping tool for business processes, but we could probably experiment with parent->host and hostgroup->host relationships as well. Thoughts?
http://assets.nagios.com/downloads/nagi ... _demo.html
http://exchange.nagios.org/directory/Ad ... ce/details

Or if that's not quite what you're looking for, can you elaborate a little more if you were to have a "wishlist" for this?

[cwscribner]

The API is somewhat helpful. I'll just have to figure out how to make it more usable...

As simplistic as this sounds, all I really need in the short term is a table: left column-hosts right column-parent device(s)

This same format would be perfect for the host/hostgroup relationships as well.

My Wishlist:

• A working mapping tool (like the network status map v2.0) where you can manipulate devices and change their parents via drag-n-drop. Would also have an option to highlight the hostgroups and group devices by hostgroup.

• A table printout to screen and PDF that allows parent/hostgroup manipulation via dropdowns

...possibly more to come.

[lmiltchev]

You can post your wishlist to our bug tracker as a "Feature Request".

http://tracker.nagios.com

[cwscribner]

I've already tried registering for the bug tracker 3 times and it has yet to work for me. It never sends a password. I successfully logged in one time but the password didn't work a second time. Is there any way you can set me up with a user name and password?

P.S. I've tried the forgot password/username links but the info never gets sent to me.

[mguthrie]

Yeah, sometimes the host IP that our tracker website gets stored on gets put onto a spam list, so the emails don't get out. We are looking into creating something like this. Not sure if it's of interested to you or not, but the nagiosql table in the mysql database has a table called "tbl_lnkHostToHost" that has host id's for all host parent->child relationships. That might be the easiest way to capture the info that you're looking for.