Re: Telnet came from where

I agree, this is a screwy request. Unfortunately, I need to pursue it.

This solution is the closest I've found to getting what I need. Which is...
"From the target system, reach back and get the workstation ID from the source system."

Two positive things working for me are:
1. The telnet is always IBM-i-to-IBM-i (both on v7.3)
2. The telnet is always _TO_ our corporate system, so the IP address will always be the same and the "remote host name" will always be the same. There is the current snag - I don't know how to determine the host name of our corporate system. I checked the TCP/IP Host Table Entries and tried both of those...

CORPORATE.xxxxxxxxxx.COM and
CORPORATE

and neither worked in the second SQL here.

How do I find the host name?

Thank you.

~TA~


On 4/29/2020 2:46 PM, Bryan Dietz wrote:

i know the best way is from the telnet command on the source system(from before)

otherwise if needed after words:

-first get information about your connection.
SELECT REMOTE_ADDRESS, REMOTE_PORT,
LOCAL_ADDRESS, LOCAL_PORT, JOB_NAME FROM
qsys2.netstat_job_info JI
where ji.job_name = (select aj.job_name from
TABLE (QSYS2.ACTIVE_JOB_INFO(job_name_filter => '*')) aj)

-then figure out the remote host name from the IP address above
and plug in the port information as well.

select job_name from "remote_host_name".qsys2.netstat_job_info
where local_port = (REMOTE_PORT from above)
and remote_port= (LOCAL_PORT from above)

seems way too hard.

Bryan