How to know which hosts are down and since how long in cmd?

[aanataliya]

I am new to nagios. I am using nagios core to monitor AWS Auto scaling group machines. I am implementing dynamic solution using php and ansible to automatically re-configure nagios based on live ip addresses.

when I open nagios host detail page, i can see status for host as "Down (for 2d 6h 5m 12s)".

Where this information is stored in nagios and is there any way to get all hosts with down status along with its time using command line?

I am using Amazon linux. Thanks in advance.

[aanataliya]

when I open nagios host detail page, i can see status for host as "Down (for 2d 6h 5m 12s)".

where does nagios core store this information (2d 6h 5m 12s)? Is it possible to configure nagios core to store host details in mysql?

[scottwilkerson]

it is stored in the status.dat file