State Change is not appearing in State History Log

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
meganwilliford
Posts: 101
Joined: Tue Aug 06, 2019 7:49 am

State Change is not appearing in State History Log

Post by meganwilliford »

Hello, we had a occurrence recently where we saw the state changed (OK to Warning) for a service but it can't be found anywhere in the state history log. In fact no state history changes appeared for anything being monitored on that day. Any ideas on why this may have occurred? As of today, state history records are appearing.

Here you can see the state change:
warning state.png
But when searching the state history log it does not appear:
no state history.png
You do not have the required permissions to view the files attached to this post.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: State Change is not appearing in State History Log

Post by ssax »

Please PM me a copy of your profile.zip, you can download it from Admin > System Profile by clicking the Download Profile button.

Additionally, please send the output of these commands:
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the first command if your DB is offloaded to another server and/or you've changed the root mysql password

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table
Locked