• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Query node's IP address?

cwilloug

ADSM.ORG Senior Member
Joined
Sep 13, 2006
Messages
392
Reaction score
11
Points
0
Location
North Dakota
Website
Visit site
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

ADSM.ORG Moderator
Joined
Aug 24, 2005
Messages
7,033
Reaction score
404
Points
0
Location
Somewhere in the US
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

ADSM.ORG Senior Member
Joined
Sep 13, 2006
Messages
392
Reaction score
11
Points
0
Location
North Dakota
Website
Visit site
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

ADSM.ORG Member
Joined
Mar 22, 2012
Messages
144
Reaction score
1
Points
0
Location
Sweden
Is there a way where you can use the above command and print out both nodename and ipaddress?
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 19 18.3%
  • Keep using TSM for Spectrum Protect.

    Votes: 63 60.6%
  • Let's be formal and just say Spectrum Protect

    Votes: 13 12.5%
  • Other (please comement)

    Votes: 9 8.7%

Forum statistics

Threads
31,824
Messages
135,716
Members
21,788
Latest member
ajay24983
Top