The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Audit Trail
Posted: 21 Jun 10 10:58 AM
|
Hi,
Is there any place SL keeps audit trail? I could not find any relevant tables.
We are using SLX 7.0 window client.
Thanks!
|
|
|
|
Re: Audit Trail
Posted: 21 Jun 10 11:08 AM
|
It depends on why you mean by Audit Trail.
On the Windows Client, you could turn on Tracking on certain fields (per Control), and it will create an Entry on the History table (Type = Database Change) with the Old and New Value and the user who made the change.
This audit trail will not capture Deletes.
|
|
|
|
Re: Audit Trail
Posted: 21 Jun 10 1:15 PM
|
Hi Raul,
Nice to hear from you. Lot of other products come with this in built audit trails where system captures all database updates in separate audit tables. We were hoping to have something similar in SalesLogix including 'Delete' captures as well. But if not we can take whatever it offers. Can you provide us any pointers on how to turn tracking as you suggested?
Thank you for your response,
Sundari
|
|
|
|
Re: Audit Trail
Posted: 21 Jun 10 1:41 PM
|
Well, it does not.
It includes a partial Tracking where you can turn the Auditing on certain fields.
On the Web Client there is a new Implementation, but still lacks behind your expectation.
Now, how to get around it?
I have ran into many implementations where this was accomplished by writting SQL Triggers to capture the Events you want to track. |
|
|
|
Re: Audit Trail
Posted: 12 Aug 10 7:31 AM
|
We did the same thing Raul. one of the issues is that SLX USers are all SYSDBA as far as SQL triggers is concerned. You have to write the triggers to capture the ModifyUser and UserInfo.Username as well.
|
|
|
|