listusermap record location for LSF9?

Did you try just using listusermap (with no options)?

Roger - Yes, I tried that but that didn't resolve the problem. However, I have made some headway on this issue though I still have a problem with it. I found that if first run 'listusermap -n' to clean the cache, and I then log into LID and run LAUA, the environment cache gets populated with all users. I can then run 'listusermap -c' and pipe the output to a text file and finally import that text file into a SQL table for use with my various interfaces. What I don't like about this process is that I have to manually go into LID to run LAUA and refresh my listusermap cache. It would be a lot easier for me if I could find some automated means of pulling this information, either via ProcessFlow or some other tool that I could schedule.

Yeah that will work too.

You can manually export the ID's also by exporting the right "hive" of the registry using regedit. There are several references on how to do this on Google. I've done it a few times when I wanted to export users from one Windows server and import those users using the same NT id's onto another server.

You could probablly do it using processflow integrator somehow.

Thanks Roger, but that's part of the problem. In a LSF9 environment, user info is no longer stored in the Windows registry so there's nothing there to export. All user data is stored encrypted within my MS-ADAM LDAP repository. I thought there might have been a way to pull from the LDAP using ProcessFlow and a ResourceQuery task, but it doesn't look like I have the option to specifically pull the "NTxxxxxxxx" value.

You can use ProcessFlow's ResourceQuery node to 1) get the RMID, 2) get the UID and 3) get the Windows account info for your LSF9 service. Then use an Assign node with javascript to convert the UID to the NTxxxxxxxx. If you can wait a couple of weeks, that's the article in May 1 LawsonGuru Letter...

Here's a sneak preview :

I like John's method; it's relatively clean and easy if you have PFI.

If you don't have PFI, then the NT id's are also stored in GEN\USERINFO and GEN\R_USER. The table contains the NT Id's but not the user names.

Posted By John Costa on 04/09/2009 09:14 AM
Thanks Roger, but that's part of the problem. In a LSF9 environment, user info is no longer stored in the Windows registry so there's nothing there to export. All user data is stored encrypted within my MS-ADAM LDAP repository. I thought there might have been a way to pull from the LDAP using ProcessFlow and a ResourceQuery task, but it doesn't look like I have the option to specifically pull the "NTxxxxxxxx" value.

 

Yes, I too, like John's method.  We just purchased PF integrator and are looking forward to leveraging it's capabilities.  I can't wait to see next month's newsletter.