Hi all,
I have a list of IP addresses in a spreadsheet that I would like to associate with their devices hostnames, some of them are SVIs so that might require further lookup in the database later, what SWQL query can I use to get the management IPs associated with their hostnames?
I used the one below but it can only look one at a time and I'm not sure how I can give it my full list, I have hundreds of addresses!
SELECT n.caption, n.NodeID, n.IPAddress
FROM Orion.Nodes n
WHERE n.IPAddress = '0.0.0.0'
Maybe there's a better way to do this? Somewhere where I can feed it an excel sheet? I don't know, maybe a list syntax in SWQL would suffice but I don't what that might be.
Thank you!