Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5270

	People Online:
	Visitors: 390
	Members: 0
	Total: 390

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
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 Send Private Message

Posts: 0

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: 3351

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 Send Private Message

Posts: 0

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: 3351

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...