• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Audit

adeel

VIP Member
Hello there.
In payroll workbench we had entry for Council which somehow got deleted as per user request is there a way to find how it got deleted or any other application caused this entry to removed. Any Audit i can find in JDE?
Thanks
 

Tom_Davidson

VIP Member
Adeel,

The easiest way I know of is to look at your DB logs/Journals. You don't specify what DB you are using. But each Db has a way to inspect the Journals.

Tom
 

Tom_Davidson

VIP Member
Hit post too quick.

The down side is if you are using the proxy user, that is the user that will show on the DB side, but you might be able to narrow it down by time. If you aren't using CFR 21, I don't know of any other audits.

Tom
 

adeel

VIP Member
Thanks Tom. I did not know that you can find CRUD operation from sql logs.
I believe we need to enable audit in sql as well for jd production database.
And we have proxy and issue still there.
What is cfr 21?
 

Tom_Davidson

VIP Member
CFR 21 is auditing, mostly for pharmaceuticals I think. But you can use it to audit any table.

We don't use it, from what I hear it is a real pain to set up. We don't use it here.

Tom
 
Top