JDE Users (User IDs) & and their Names

[mnarewec]

There are alot of Ghost Users in our system. I am trying to delete those users who have several user IDs or are no longer employed. I am able to get a list of all UserIDs butI am able to get their Description i.e. their Names as text description in their IBM profile.. Please help. Which files am I supposed to get this info.

Please help.

Thank you.

 

[Jim_rubino]

Are you doing the command: WRKOBJPDM LIB(QSYS) OBJ(*ALL) OBJTYPE(*USRPRF)
and then from this list are you pressing F21 to print the list? If so the
description prints on the list.
Are you trying to get this from within JDE's F0092 file? If you are the
description is not in there, you would need to do the command: DSPUSRPRF
USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(YOURLIB/USERPRFS)
After doing this you can them create a WW using the F0092 as primary and
chain to the new file you created linking ULUSER to UPUPRF.

Is this any help to you or do you need more? If you need more tell me more
details.

Thank you,

Jim Rubino
Senior Business Systems Analyst
FIKE CORPORATION
704 South 10th Street
Blue Springs, Mo.  64015
(816) 229-6216  Ext. 213

 

[slandess]

users
list of
text
you.


You need to use an AS/400 command to display the user profile information to
an outfile, then you can get this information from the resulting outfile.
You need to get someone with *ALLOBJ, *SECOFR, or *SECADM privileges to
run this command on the AS/400 (Replace YOURLIB with a valid library name on
your system):

DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE)
OUTFILE(YOURLIB/USRPRF)

The resulting output in YOURLIB/USRPRF will have a list of users. The user
profile name is in the field UPUPRF, and the description of the user profile
is in field named UPTEXT. You can query this file or join it with F0092 to
display the information you need.

HTH
Steve Landess
Austin, Texas
(512) 423-0935
iSeries A7.3 c9

<[email protected]>
To: <[email protected]>
Sent: Tuesday, March 18, 2003 5:10 PM



Steve Landess
V4R4 A7.3 cume9
EDI
(512) 423-0935

 

[ekempter]

DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(MYLIB / MYFILE)

Then a run a query on MYLIB / MYFILE



.......................

 

[mnarewec]

Re: RE: JDE Users (User IDs) & and their Names

Thank you so much.. but doing WRKOBJPDM etc I am able to get them.. but I am wondering why when I am doing DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(YOURLIB/USERPRFS)... the TEXT part did not get written on to the outfile... only other information.

 

[tpayne]

Provided you have password expiration set, you ought to be able to determine
those users with expired passwords and the date these accounts were last
used.
If you then delete these AS400 profiles, when you review the JDE users
(9/G94) it's obvious which have no AS400 profile. You can then just scroll
through the screen and blow then away.
Hope this helps.


----- Original Message -----
From: "mnarewec" <[email protected]>
To: <[email protected]>
Sent: Tuesday, March 18, 2003 6:11 PM
Subject: JDE Users (User IDs) & and their Names


users who have several user IDs or are no longer employed. I am able to get
a list of all UserIDs butI am able to get their Description i.e. their
Names as text description in their IBM profile.. Please help. Which files
am I supposed to get this info.Please help.Thank you.



Best Regards
Tony Payne - Senior Analyst/Programmer
Aker Plastics, Plymouth, Indiana
--------------------
4+ yrs JDE World Financials / Manufacturing
V5R2 / A7.3 cum11