infor.com
concierge
infor u
developer portal
Home
Groups
Lawson - Supply Chain Management Customer Community [READ ONLY]
NT***** Usernames to Lawson User ID
Legacy Contributor
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
Comments
Legacy Contributor
KB1188402 on the support site gives you details, but in short, listusermap command makes the crosswalk.
Legacy Contributor
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.
Legacy Contributor
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.
Important Links
Community Hubs
Discussion Forums
Groups
Community News
Popular Tags
ION Connect
ION Workflow
ION API Gateway
Syteline Development
CPQ Discussion Ask a Colleague
Infor Data Fabric
Infor Document Management (IDM)
LN Development
API Usage
FAQs, How-To, and Best Practices