User names - laua

 4 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Roger French
Veteran Member Send Private Message
Posts: 549
Veteran Member

In 8.0.3, how can I dump the user name (the long, real name such as Joe Smith, not jsmith) from GEN? I tried USER, USERINFO, etc. but none contain the actual user name (first , last). Is this stored at the OS level? If so, is it possible to extract? This is on AIX platform.

Thanks in advance,

-R

Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
I think what you are after is LOGAN. Go into Portal, and bring up RD30 screen... find the fields that you need by pressing Ctrl-O
Something similar to this command-
rngdbdump -ct logan webuser -f "field1 field2 field3...." -v name_field=

Sorry, I don't have access to an 803 environment anymore, so I can't give you the exact command that we used... it changes in LSF9.
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
Ooops... stored at the OS level?? I didn't read that part until now.
grep /etc/passwd | cut -f 5 -d:
Should give you the user name at the OS level.
John Henley
Send Private Message
Posts: 3351
You can try 'finger' as well as grep against /etc/passwd
Thanks for using the LawsonGuru.com forums!
John
John Costa
Veteran Member Send Private Message
Posts: 154
Veteran Member
I use a combination of data from both GEN and LOGAN. I first dump the GEN/USERMAP table which gives me the NT User ID and NT User Name for each authorized user. I then dump the LOGAN/USERWEB table which provides me the NT User Name along with the last name & first name for each user who has an RD30 record. It's then just a matter of matching up the two record sets, joining on the NT User Name value.
_________________________
JohnC - Kechi, KS
_________________ John - Wichita, KS