Simple daily ping status report

I might be over thinking it but I can't design a simple report to go out every morning that only lists devices with a Ping status of not OK... so just a list of every PING monitor across all devices that are NOT green.

Maybe unrelated but even if I try the stock/built-in "Ping Availability Group Report" all of the availability shows nothing, it's blank and says No Data Available.

Anyone use a report like this?