Show alerts on DB

[oz123]

Hi,

can you please provide me the select query for the Service Status online alerts where status not "OK" ?

Thanks

[abrist]

You can get this information from the backend api:

Code: Select all

http://<XI IP>/nagiosxi/backend/?cmd=getservicestatus&brevity=3&current_state=nin:0

Or from bash(query in quotes):

Code: Select all

echo "use nagios; select current_state,service_object_id,name1,name2 from nagios_servicestatus inner join nagios_objects on service_object_id=object_id where (current_state != 0)order by name1;" | mysql -t -pnagiosxi

[oz123]

Thank you !!