How do I print RRM user profile and network information? (NETIQKB45852)

goal
How do I print RRM user profile and network information?

goal
How can I create a list of RRM approved user profiles and networks?

fact
NetIQ Security Solutions for iSeries 8.0

fact
PSSecure 8.0

fact
PSSecure 8.0 Remote Request Management

fact

VigilEnt Security Agent for iSeries 7.5

fact

Remote Request Management (RRM)

fix

The RRM Work With Users and Work With Networks screens allow you to create and maintain RRM approved users and networks. To generate and print lists of RRM user profile and network information, run the following queries with PSCOMMON in your library list.

All approved users and user groups:

PSRUNSQL REQUEST('SELECT N17TEXT FROM pscommon/nw0N17f WHERE N17TYPE ="U") OUTPUT(*PRINT)

where N is the corresponding digit for the environment used on your server.

All approved networks and network groups:

PSRUNSQL REQUEST('SELECT N17TEXT FROM pscommon/nw0N17f WHERE N17TYPE ="N") OUTPUT(*PRINT)

where N is the corresponding digit for the environment used on your server.

Determining the Environment on Your Server

Depending on your server's configuration, there can be multiple environments on a server. You must determine which environment your server uses so you can use the appropriate value in the queries listed above.

To determine which environment your server uses:

1. From the NetIQ Product Access Menu, type 2 (PSSecure) and press Enter.
2. Type 3 (Remote Request Management) and press Enter.
3. Type 1 (Work with Secured Entires) and press Enter.
4. Press the SYS-REQ key or Shift+Escape.
5. Type 3 and press Enter.
6. Type 14 and press Enter.
7. Page down until you see file NW0*15F in library PSCOMMON, where * is 0, 1, or 2. This variable is the corresponding digit for the environment used on your server.

Formerly known as NETIQKB45852