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

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

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