Are you talking every one of the 18 possible kinds of devices? Then it's API time (Retrieve Device Description (QDCRDEVD) API). RTVDEVATR is only for things attached to workstation controllers, RTVCFGSRC will give you all the settings to create each device in its own source member, and then you get to parse that out into Excel.

You can use List Objects (QUSLOBJ) to get the list of device descriptions - use format OBJL0200 to get the extended attribute, which tells you what kind of device you have. Then it's SELECT-CASE time.


At 02:40 PM 3/18/2004 -0800, you wrote:
I need to document our devices on the AS400 so I want device name, controller,
port, switch setting, etc. (from wrkcfgsts *dev) in a nice list I can import
into excel.


Jerry Draper
Trilobyte Software Systems

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.