Page 1 of 1

how to search from Object-Notes

Posted: Wed Sep 26, 2018 4:32 am
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"

Re: how to search from Object-Notes

Posted: Wed Sep 26, 2018 2:09 pm
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!