select node_id, node_ip, state, created_ts, node_port, isp_node_name from dp_physical node;

ACTIVE: The node is ready to take new user sessions.
SUSPECTED_UNREACHABLE: The node cannot accept new sessions as peer-check operation is failing on that node. The node might not be completely down as the server may recover after a brief period of high load.

select login_id, node_ip, a.node_id, isp_node_name from dp_physical_node a, dp_user u, dp_user_to_node_map m where a.node_id = m.node_id and u.id = m.user_id;