Notes tab in Host Status Details

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
ockmeyer
Posts: 74
Joined: Mon Jun 25, 2012 2:17 pm

Notes tab in Host Status Details

Post by ockmeyer »

Where is the information entered on the "Notes" tab of the Host Status Detail page in Nagios XI stored? We have nearly 1000 hosts and I would like to export that information.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Notes tab in Host Status Details

Post by slansing »

We do not have a export feature for this however that information is stored in the postgres database. I would not recommend fiddling around with it though.
ockmeyer
Posts: 74
Joined: Mon Jun 25, 2012 2:17 pm

Re: Notes tab in Host Status Details

Post by ockmeyer »

Darn - - I wanted to duplicate that data on another instance of Nagios XI without having to touch every host.

If I could request a feature update, it would be to have a simple way of getting information about contacts into the Notes field. We have NOC employees that don't have access to the core.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Notes tab in Host Status Details

Post by scottwilkerson »

it certainly won't be in the best format but you may be able to extract it with this

Code: Select all

echo "select * from xi_options where name like 'objectnotes%';"|psql nagiosxi nagiosxi
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
ockmeyer
Posts: 74
Joined: Mon Jun 25, 2012 2:17 pm

Re: Notes tab in Host Status Details

Post by ockmeyer »

That script works well. I have to massage it a bit as you indicated, but it is usable.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Notes tab in Host Status Details

Post by slansing »

Good to hear, did you get the information you were after?
ockmeyer
Posts: 74
Joined: Mon Jun 25, 2012 2:17 pm

Re: Notes tab in Host Status Details

Post by ockmeyer »

I did. Now I have to try and turn it around and import it into our other instance of Nagios XI.
Locked