Re: Telnet came from where

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


Rob Berendt wrote on 4/29/2020 3:36 PM:

When I telnet from SYS1 to SYS2 I get two ports in use 23 (or the ssl one) and a random port which can be determined. You can use a service to determine that. Then you can use another service, with 3 part naming, to get the job using the matching ports on the remote machine. That will determine the device. Really busy now...

Rob Berendt