Extracting a list of Lawson user IDs

Sort:
You are not authorized to post a reply.
Author
Messages
ryanhoag
New Member
Posts: 1
New Member

    How can I extract a list of users from Lawson?

    Better yet, does anyone know the name of the table that stores the user information (username, user's Security Class, active/inactive, etc.)?

    This client does not have Monarch, so I'm hoping I can have their DBA run a query in Oracle if there is no easy way to do it straight from the app itself.

    Thanks-

    Chris Martin
    Veteran Member
    Posts: 277
    Veteran Member
      The table name is USER. It's not stored on the db. You can access using Lawson app utilities or via a dme call.
      k-rock
      Veteran Member
      Posts: 142
      Veteran Member
        you could run the User ID listing from the LAUA security forms if you can't get to the USER table. This report has the data you're looking for, you would need to get it into a nicer format though.
        John Henley
        Senior Member
        Posts: 3348
        Senior Member

          If you are running LSF9, the GEN / USER table is stored in the RDBMS, so you can query it from Oracle. 

          Thanks for using the LawsonGuru.com forums!
          John
          Chris Martin
          Veteran Member
          Posts: 277
          Veteran Member
            Sorry, still a noob when it comes to LSF9...thanks for clarifying.
            amylynanderson
            Advanced Member
            Posts: 26
            Advanced Member
              The gen user file does not contain last login information. Is there a table to get that information?
              John Henley
              Senior Member
              Posts: 3348
              Senior Member
                Which platform / OS ? Which Env/LSF9?
                Thanks for using the LawsonGuru.com forums!
                John
                John
                New Member
                Posts: 1
                New Member
                  What is the name of the file on the iSeries, how would we query it from Crystal?
                  Frank Z
                  Advanced Member
                  Posts: 32
                  Advanced Member
                    Posted By John Henley on 08/26/2008 09:19 AM
                    Which platform / OS ? Which Env/LSF9?

                    John-

                    We are running 9.0.0 on NT with LSF9 and we are having this same issue right now.  My auditors are eating me alive, and I'm new to the Lawson world.  Before I came in, Auditing + Logging was not even enabled so I would I not be able to get a record of when and how users were set up and by whom? 

                     

                    You are not authorized to post a reply.