Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5205

	People Online:
	Visitors: 342
	Members: 0
	Total: 342

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
Roger French	1315
mark.cook	1244

HRHISTORY USER_ID

3 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

KHUMPHREYS

New Member

Posts: 3

4/6/2007 5:28 PM

Hi,

How can the user_id (ie NT0000013) be translated to the login username?

We'd like to be able to identify who made a change.

Thanks!

John Henley

Posts: 3353

4/6/2007 6:24 PM

Assuming your on Windows Environment 7x/8x, it is the Lawson-assigned equivalent (e.g., NT00000002) for their NT login. You can determine the user’s Lawson username by using the listusermap utility in the Lawson Environment.

KHUMPHREYS

New Member

Posts: 3

4/6/2007 6:45 PM

We're trying to identify users as part of a sql query, is there a table that can be queried?

John Henley

Posts: 3353

4/6/2007 7:52 PM

Unfortunately not.
In Env 7/8, it's stored in the NT registry.
In LSF9, it's stored in the LDAP repository.
The easiest thing to do is to create a (perhaps daily) script that puts 'listusermap' output into a table, and they query off of it...