How do I pull in data from most recent "down" node?

I'm very new to python, but I hope I can help at least a bit.

You'll want to install this python client for interacting with the API:  GitHub - solarwinds/orionsdk-python: Python client for interacting with the SolarWinds Orion API

Then, you can connect to the SolarWinds Information Service (swis):

import orionsdk

swis = orionsdk.SwisClient("server", "username", "password")

Now, you can query the database for any information you need:

response = swis.query("SELECT NodeID, IPAddress, Caption, Status FROM Orion.Nodes WHERE NodeID = ##")

Here, ## would be the ID of the node that went down

You may also be interested in inspecting alerts to identify what needs attention.  You can find details about using the Orion SDK to interact with alerts here:

Alerts · solarwinds/OrionSDK Wiki · GitHub

Awesome thank you! I tried reaching our server but it timed out because it couldn't connect properly. Would i need admin rights to access the server this way? Because I'm trying to use my individual user/pass that was assigned to me but I can't connect to the server.

Thank you! I'm still trying to figure out how to connect properly, if I have more questions after that I will reply!

I figured it out, I was having firewall issues.

So I am now able to pull Node Data but I still don't know how to get the most recently downed node. I'm querying like this.

query = "SELECT Caption, Status FROM Orion.Nodes WHERE Status = 2"

results = swis.query(query)

for row in results['results']:

    print("{Caption}:{Status}".format(**row))

this outputs:

TEST-B:2

TEST-A:2

(So it ouputs the caption name, then the status which is 2 which means down.

Except TEST-B went down first and TEST-A went down second, unless the output is based on what went down first. Example if I had a third test machine that was named TEST-C and it went down would the output be as follows:

TEST-B:2

TEST-A:2

TEST-C:2

Test C being the most recently downed Node. Is that how the format follows for querying? Unless there is any easier way to get the most recently downed node.

Any help would be awesome

You probably want information from the Orion.Events table.  See this for an example query:

Node Downtime with Duration and Minimum Length Filtering