NT***** Usernames to Lawson User ID

Hi,

Is anyone familiar with how to convert an "NT" username/userID in Lawson V10 to their original username.

For example, before we upgraded from V9, the operator ID's within lawson would show as jdoe (for John Doe). However, now they are showing up as NT00000005b (etc). We are struggling to find the table that stores the "NT" userID and how to map that to a lawson userID.

Let me know if anyone needs further clarification.

Find more posts tagged with

Infor Lawson Supply Chain Management - Discussion

Comments

unknown

KB1188402 on the support site gives you details, but in short, listusermap command makes the crosswalk.

unknown

Here's the quick and dirty we use once a month to get an updated list. There is a ZX02 program that our former Lawson admin knew how to update for easier access but this is what we're left with now.

From the LID command line just enter: “listusermap > list”. It will create a list file that contains the NTID and usernames.

Remote desktop (mstsc) into “inforappcl1.uch.ad.pvt”

Log in using your LA ID.

Open F: lsfprod launt UCH_LAWSCMJOBS

Look for the file named “list” - double click open in Notepad

Crtl A and select All

Ctrl C and Copy

Copy in Excel back on your PC….

May have to clean up depending how it looks in Excel.

acollins

There is no table. If you look in security and see the UID, that is the number which is converted to the NT ID after being converted to hexadecimal (ie, base 16 math). If the UID is 11, it is NT00000000a. 12 is b, 13 is c, 14 is d, and 15 is f. 16 is 10 in base 16, so UID 16 corresponds to NT00000010. If the field contains the NT ID and a COBOL is used, you can use an API to convert the NT ID to the . Look at AP135 for how OPERATOR is converted.

I wrote an IPA to go from userid to NT ID using the RM Node to get the UID. I selected our environment agency and the attribute password since UID was not in the list. I then changed the password to UID. After I got the UID, I had to convert it to hexadecimal if the UID was not empty using the following JavaScript which I got from the Lawsonguru site but had to modify a bit:

var j=ResourceQuery900_UID;
var hexchars = "0123456789ABCDEF";
var hv = "";
for (var i=0; i
{
k = j & 15;
hv = hexchars.charAt(k) + hv;
j = j >> 4;
}
sNTID = "NT";
for (var x = hv.length; x
{ sNTID = sNTID + "0" };
sNTID = sNTID + hv;

If I were to have to go from NT ID to user ID, I would have to change the last 8 digits on the NT ID to a decimal number. I am sure you can find some JavaScript to do this. I just haven't had a need for it. You can also create a table of all user IDs to the NT ID using something like the IPA I wrote to convert the user ID to the NT ID. Then, you could go both ways.

There is a KB article about listusermap which tells you how to get this information using deleteuser prior to it.

unknown

We have just recently moved to Lawson 10 from V9, previously we were on an AIX system so all the reports in Lawson were using the UID to tell us who ran certain jobs or did certain functions.

Now in Lawson V10 on windows we always get the NT ID on those reports... we used the listusermap command to give the business users the crosswalk but they are still not happy. They want to see the UID so they can easily tell who did what when they go to do an audit.

any ideas? Infor says working as designed but it would be great if we could config this on the reports to not use NT ID but use UID.

Copyright © 2025 Infor. All rights reserved.