RE: Need a command or tool to display all printer device descriptions to an outfile or spoolfile

Rob,

For printer device descriptions, need to see

DEVD
DEVCLS
TYPE
MODEL
TRANSFORM
MFRTYPMDL
PPRSRC1
PPRSRC2
RMTLOCNAME
WSCST
USRDRVPGM
TEXT

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Wednesday, August 30, 2017 8:57 AM
To: Midrange Systems Technical Discussion
Subject: Re: Need a command or tool to display all printer device descriptions to an outfile or spoolfile

What particular information do you need? Like this?
SELECT
OBJNAME, OBJTYPE, OBJATTRIBUTE,
LAST_USED_TIMESTAMP, TEXT, A.*
FROM TABLE(QSYS2.OBJECT_STATISTICS('QSYS', '*DEVD')) AS a
WHERE OBJATTRIBUTE LIKE '%PRT%';


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 08/30/2017 08:24 AM
Subject: Need a command or tool to display all printer device
descriptions to an outfile or spoolfile
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Need a command or tool to display all printer device descriptions to an
outfile or spoolfile

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
http://www.pencor.com/