Identify All Recent Transactions For A User

We would like to review all transactions made over the past several days by a particular user. Does anyone know if there a report or query we could run to do this?

Find more posts tagged with

Infor Lawson Technology Group - Discussion

Comments

unknown

There is no single report. I report on a single user's activity in the AP system by filtering on the APAUDIT table, using a Crystal Report. Other systems have their own audit files. Also, some systems to have auditing turned on, or it won't work. (We are on Lawson S3 version 10.)

unknown

Thank you! This is helpful. I was able to run the query below to get results from the APAUDIT table. I'm also researching whether I can query other tables individually.

SELECT *

FROM app10.apaudit

WHERE operator = 'NTxxxxxxxx'

AND trans_date > TO_DATE('08/12/2018', 'mm/dd/yyyy')

ORDER BY trans_date,

trans_time

unknown

I was able to run another query (see below) to get a list of tables with a LAST_UPDATE_BY column, and produce a list of sub-queries I could run to see what the user had changed (although I realize it won't pick up any records the user may have changed which were subsequently changed by another user). Assuming the column names are named consistently, this should provide me with most of what I was looking for.

SELECT 'SELECT * FROM app10.' || table_name || ' WHERE LAST_UPDATE_BY = ''NTxxxxxxxx''' || ' AND LAST_UPDT_DATE > TO_DATE(''08/12/2018'', ''mm/dd/yyyy'');'

FROM all_tab_columns

WHERE column_name = 'LAST_UPDATE_BY'

AND owner = 'APP10'

ORDER BY owner

Copyright © 2025 Infor. All rights reserved.