Enabling and Using Audit Trails

Note: If you are a cloud customer you will need to contact Technical Support to change this setting for you, and all users in your company will need to be logged out of the cloud program.

Our software programs have basic auditing functionality, which is disabled by default. We call these "Audit Trails."

When enabled, the Audit Trail will automatically record the date, time and user name when you save the record (Recipe, Ingredient, etc).  You also have the option of recording any changes made or other comments in the comment box. 

Later, you can view that record's history, by selecting the Audit Trail button from the record's home ribbon.

Enable the Audit Trail

If you are using the ESHA instance of SQL Server to host the database

  1. Open Database Utility
  2. Connect to the correct SQL Server and the ESHA Database. Note: Under Windows 7 and possibly Windows 2008 Server, you must right-click Database Utility and Run As Administrator.  Once connected, you can enable the Audit Trail by 
  3. Go to Users and click Enable Audit Trail.

If you are using your own instance of SQL Server (This is an advanced operation)

Update the proper row in the database to enable Audit Trails:

IF EXISTS ( SELECT 1 FROM UPreferences WHERE OwnerID = 0 AND PreferenceName = 'ShowAuditTrail' ) UPDATE UPreferences SET PreferenceValue = 1 WHERE OwnerID = 0 AND PreferenceName = 'ShowAuditTrail'
IF NOT EXISTS ( SELECT 1 FROM UPreferences WHERE OwnerID = 0 AND PreferenceName = 'ShowAuditTrail' ) INSERT INTO UPreferences VALUES (0, 'ShowAuditTrail', '1')

Setting the above to PreferenceValue = 0 will then disable the audit trail.

Note: Enabling (or disabling) the Audit Trail must take place when all users are out of the client application.  Settings are not kept if anyone is running the program while changing the setting.

See below for an example of using the Audit Trail Feature


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request