Data modification audit

 2 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
olgab
New Member Send Private Message
Posts: 0
New Member
When a user does an update there is a field USER_ID that tells who made the change. It looks like NT00000038 , NT0000000c
How can we find who is this user?

Thanks
Deleted User
New Member Send Private Message
Posts: 0
New Member
Try the utility listusermap. What we have done is had a job that dumps the data out to a file. Then another job pulls it into a custom table in Lawson. One thing to note. The NT... ids in say your development environment may not match what is in your production environment. This can be interesting when you copy data from prod to dev.
olgab
New Member Send Private Message
Posts: 0
New Member
Jay,
I got it. Thank you for help.