Hello, 

Beside AESPION table, which is when the login and out, if you want details of exactly what the user is doing then auditing the tables , I think that is the only choice. 

Which of course you can set up purge or archiving on the audit . 

Also did you make sure to filter the audit by that user?

See this thread also

https://sagecity.na.sage.com/support_communities/sage_erp_x3/f/sage-x3-general-discussion-forum/103199/user-list-audit-history

Regards, 

Thank you for your repply Esfahani. We have decided with the customer to activate the audit in the sensitive fields and views and then clean and store in a diferent database the audit tables. The problme with AESPION table is the number of entries it records, it is to short for the 5 year audit log track that the customer is requesting.

Thank you for your repply Esfahani. We have decided with the customer to activate the audit in the sensitive fields and views and then clean and store in a diferent database the audit tables. The problme with AESPION table is the number of entries it records, it is to short for the 5 year audit log track that the customer is requesting.

Hi, you could consider to recreate/move the table to another RDBMS datafile and with some periodicity  pump the data out to another database and after use AHISTO.

" number of entries it records, it is to short for the 5 year audit log" 

Why?