mysql query to push history of the problems to ELK

[velkrish]

Hi Friends,

Could someone help to form mysql query to get the history of the recovered problems occurred for hosts and it is status?
My need to push this data to logstash to track it.

Thanks,
Velu.