User names - laua

 4 Replies
 0 Subscribed to this topic
 28 Subscribed to this forum
Sort:
Author
Messages
Roger French
Veteran Member
Posts: 549
Veteran Member
New Poster
New Poster
Congrats on posting!

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
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
Posts: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
You can try 'finger' as well as grep against /etc/passwd
Thanks for using the LawsonGuru.com forums!
John
John Costa
Veteran Member
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