how to search from Object-Notes

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
zaji_nms
Posts: 616
Joined: Tue Oct 16, 2012 12:28 am

how to search from Object-Notes

Post by zaji_nms »

Dear Expert

Please ref attached, is there any simple way to search via Object Notes
an example if our customer report some issue for this CID (Circuit-ID) : ZX7861102152 , we want to search via NOTES (Obj_Notes) to find the Host/Service

if no option, how to add one of menu option under HOME (need your advice). html/php script we will write, please guide.

In later version, can you please add at least 2 options under HOME at bottom
Custom-Option1 , when we click it will show "Dear User, please modify this HTML file nag_custom_option1.html as you wish with your own risk"
Custom-Option2 , when we click it will show "Dear User, please modify this PHP file nag_custom_choice2.php as you wish with your own risk"
You do not have the required permissions to view the files attached to this post.
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: how to search from Object-Notes

Post by lmiltchev »

Please ref attached, is there any simple way to search via Object Notes
an example if our customer report some issue for this CID (Circuit-ID) : ZX7861102152 , we want to search via NOTES (Obj_Notes) to find the Host/Service
Currently, there is no option in the GUI to search the Object Notes for a pattern. However, you could search the nagiosxi db (from the CLI) in order to find the host/service.

Example:

Code: Select all

echo "select * from xi_options where value like '%ZX7861102152%';" | mysql -t -uroot -pnagiosxi nagiosxi
You should see something like this as an output:

Code: Select all

+-----------+--------------------------------------------+--------------+
| option_id | name                                       | value        |
+-----------+--------------------------------------------+--------------+
|       269 | objectnotes_HostName____ServiceDescription | ZX7861102152 |
+-----------+--------------------------------------------+--------------+
Note: The query above would be used if nagiosxi db were in mysql. If you had an older (upgraded) XI, which still uses postgresql, this command would need to be adjusted. Let us know if you need the postgresql version.
if no option, how to add one of menu option under HOME (need your advice). html/php script we will write, please guide.
This still would be considered a "custom development". You could contact our sales team at [email protected] and request a quote. Thank you!
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked