Data modification audit

 2 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
olgab
New Member
Posts: 4
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
    ridjayc
    Veteran Member
    Posts: 191
    Veteran 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
      Posts: 4
      New Member
        Jay,
        I got it. Thank you for help.