Query node's IP address?

[cwilloug]

I've looked, and can't find my answer, I'm wondering if anyone has a query that will return a specific IP address for a node? Say I'm looking for all nodes on 345.87.765.xxx

Thanks!

 

[moon-buddy]

Something like this from the TSM server:

select node_name from nodes where tcp_address like '345.87.765.%'

But in your case, this will never return any - there is no IP above 255.255.255.255

 

[cwilloug]

Yes moon-buddy I know that, i was implement TV show security on my IP address. You know on (insert your favorite crime drama TV show here) when they are "tracing down" the bad guy's IP address, and you pause the DVR and it's some crazy combination of numbers... anywho.

Thanks, that worked like a charm!

 

[combato]

Is there a way where you can use the above command and print out both nodename and ipaddress?

 

[RecoveryOne]

Is there a way where you can use the above command and print out both nodename and ipaddress?

select node_name,tcp_address from nodes

Print out everything in one list.

 

[combato]

Great! Thank you!