Skip to main content
Solved

Howreport on the Date/Time of a User's Deactivation

  • 4 November 2022
  • 1 reply
  • 62 views

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

Hi @audreyj 

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

View original

DavidEichner
Captain II
Forum|alt.badge.img+13

Hi @audreyj 

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings