Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

User names - laua

 4 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Roger French
Veteran Member
Posts: 549
Veteran Member
3/3/2008 12:39 PM

    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
    3/3/2008 1:32 PM
      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
      3/3/2008 1:34 PM
        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: 3353
        3/3/2008 1:40 PM
          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
          3/4/2008 1:32 PM
            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