Hello, it's possible via "Custom query" resource, you can add to the view via "Customize page". This resource is using SWQL, which is very similar to SQL, but the objects are named a bit different.
The query for you will be like: SELECT Caption from Orion.Nodes WHERE Nodes.Status=2
There is also already a resource named "Down Nodes" that can be added to the page. No need for the custom query unless you just want the practice.