I had a need to know how the node status was being calculated vs how the node was being polled. I added a 'Custom Query' widget to my 'Node Details' page and used the following attached query.
I also created this as a report to list all nodes with the status vs polling method. You can see those details here.
