Page 1 of 1
Notes tab in Host Status Details
Posted: Wed Oct 03, 2012 3:59 pm
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.
Re: Notes tab in Host Status Details
Posted: Wed Oct 03, 2012 4:27 pm
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.
Re: Notes tab in Host Status Details
Posted: Wed Oct 03, 2012 4:40 pm
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.
Re: Notes tab in Host Status Details
Posted: Wed Oct 03, 2012 5:03 pm
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
Re: Notes tab in Host Status Details
Posted: Thu Oct 04, 2012 4:53 pm
by ockmeyer
That script works well. I have to massage it a bit as you indicated, but it is usable.
Re: Notes tab in Host Status Details
Posted: Thu Oct 04, 2012 4:58 pm
by slansing
Good to hear, did you get the information you were after?
Re: Notes tab in Host Status Details
Posted: Fri Oct 05, 2012 12:53 pm
by ockmeyer
I did. Now I have to try and turn it around and import it into our other instance of Nagios XI.