Re: Telnet came from where

[~TA~ <tadair@xxxxxxxxxxxxxxxx>]

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