How find KBA attached in all Services & Hosts

[ashok.verma]

Hi All,
We try to fetch all KBA attached related hosts and service in nagios xi 5.8.6. Please help us.

[benjaminsmith]

Hi,

My apologies, can you elaborate on KBA attached.

Are you using Nagios XI or Core?

Benjamin

[ashok.verma]

We using Nagios Xi 5.8.6 enterprise version. We configured 1500 Server & 140000 services in Nagios Xi 5.8.6.
Inside "service Management" -> Misc setting -> "Action URL".
inside "Action URL" , we using some url inside "Action URL" for alerts escalation process called KBA..
i want to fetch all "action URL" detail from 1500 Server & 140000 services.

[benjaminsmith]

Hi,

That data is stored in the nagiosql database, so you could get at it using the REST API or an SQL query. For example,

Code: Select all

echo "select host_name, action_url  from tbl_host;" | mysql -uroot -pnagiosxi nagiosql


Hope that helps.
--Benjamin

[ashok.verma]

Thanks Sir, it is working fine

[benjaminsmith]

Hi,

Thanks Sir, it is working fine

Cool, we'll go ahead and close this but feel free open another one in the future.

Also, as this is a community forum, we would love to have you share your expertise with the other members. Thank you for visiting.

--Benjamin