Table where I can query Full name and Login username (Using Lawson ADDINS)?

Sort:
You are not authorized to post a reply.
Author
Messages


willz06jw











Basic Member



Posts: 24




Basic Member



    Thanks for your help,

    I am trying to find a table where I can query the username (that people log in with) and the full name attached to it.

    I am trying to pull this in Excel using Lawson Addins.

    Thanks for your help,
    Will



    jrbledsoe001











    Veteran Member



    Posts: 91




    Veteran Member



      We are on LSF9 so there are canned reports for this - export to csv and your are done. In earlier version that stuff was stored in RD30 logan RD30; see lawson kb Article ID: 103612.

      A trick I recently picked up was matching laua accounts to the full name. It's not straight forward but it got the job done for me. maybe some has a much easier way??

      rngdbdump -c gen user |lashow or create file
      transfer file from lawson server \etc directory file name= passwd
      i had to parse the file using : as the delimiter
      then i match up the user table to the name in the \etc\passwd file from the lawson server

      I use Monarch so this takes just a few seconds once I had it set up.

      Write back and share how you wrote your query


      willz06jw











      Basic Member



      Posts: 24




      Basic Member



        Unfortunately, I don't have access to the Lawson command line.

        I will look for the canned report and try the CSV file solution.

        Thanks again,
        Will
        You are not authorized to post a reply.