RE: Automate Netstat *CNN output to spoolfile, selected by port, dsplaying port numbers, etc

Aaron,

Thanks, that was easy.

However, I'm not finding job name, job user, and job number in the list of available fields.

SELECT REMOTE_ADDRESS , LOCAL_ADDRESS , LOCAL_PORT FRO
QSYS2.NETSTAT_INFO WHERE LOCAL_PORT = 23

01/04/17 15:35:47 PAGE 1
REMOTE_ADDRESS LOCAL_ADDRESS LOCAL_PORT
0.0.0.0 0.0.0.0 23
10.5.X.XX 10.5.XX.X 23
...

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Aaron Bartell
Sent: Wednesday, January 04, 2017 2:13 PM
To: Midrange Systems Technical Discussion
Subject: Re: Automate Netstat *CNN output to spoolfile, selected by port, dsplaying port numbers, etc

Have you considered using the latest DB2 Services?
http://bit.ly/db2-for-i-services

Look specifically at QSYS2.NETSTAT_INFO:
http://bit.ly/netstat_info-db2-service

Aaron Bartell
IBM i hosting, starting at $157/month. litmis.com/spaces


On Wed, Jan 4, 2017 at 1:01 PM, Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>
wrote:

We are currently migrating an app, using ports 23, 80 to a new app
using ports 443, 992.

I would like to be able to automate the netstat *CNN output to
spoolfile, selecting a certain port, displaying the port numbers.
The desired output would be:

Remote Remote Local Local
Job Job Job
Address Port Address Port Type
Name User Number

Can this be done with NETSTAT or some other cmd/tool?

Thank You
_____
Paul Steinmetz
IBM i Systems Administrator

Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071

610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home

psteinmetz@xxxxxxxxxx<mailto:psteinmetz@xxxxxxxxxx>
http://www.pencor.com/

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD