I have a need for SOX compliance to prove that a User’s account has been deactivated promptly upon an employee’s termination. I have created a custom report from the framework of the User List Report and need to pull in the date/time the user’s account is deactivated OR date/time a user’s role is removed. I have auditing turned on for these, but am not sure how to relate the audit values with User’s table. Any ideas?
Best answer by DavidEichner
View original
+10
Hi
I just created a generic inquiry for audit history associated with the Users screen after activating audit history for the Users. Attached is the sample generic inquiry in XML so you can load it into your system. You should be able to take it from here in terms either using the GI on a screen or if you want to create a report with similar fields from the AUAuditValues table.
Hope this is helpful.
David Eichner, CPA
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
