Re: Telnet came from where

[mlazarus <mlazarus@xxxxxxxxxxxx>]

TA,

 Try looking into the TELNET exit points.  That might do the trick for 
you.  Here's a link for reference:

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzaiw/rzaiwexitsample.htm

 -mark

On 4/30/2020 9:38 AM, ~TA~ wrote:
> 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