I'm almost certain the CustomPollerStatistics* tables hold the information you're looking for. If you're looking to include the value in an e-mail by way of an SQL query, you'll want the CustomPollerStatistics_Detail table. The column you're looking for will probably be RawStatus or Status.
I suspect you are correct. The reason its not working for me might be due to an on-going issues we have been experiencing.
The database shows that this table stopped getting updates on the 12th of this month. We have an on-going problem with Orion missing data... I'm wondering if this is one more of our symptoms. I'll bring this up with support and see.