You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Audit Report

Summary:

We did enable the audit for the PER_PHONES table. This reports on future phone number change history. 

We included date prompts. 

I updated the phone of the user on 11/21/2023 and pulled the report using dates 11/1/2023 – 11/21/2023 and the number did not populate in the report. When I used the end date of 11/22/23 I could see the number in the report.

The sql has <= last update date so I would have thought it would pull in the 21st but it seems the 22nd or greater is what pulls it in. Is it the expected behavior? How can I fix to pull in the 21st?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!