Audit Trail - Revision history

Wikiadmin: /* A generated Audit Trail Window */

2018-10-26T09:34:55Z

‎A generated Audit Trail Window

Wikiadmin: /* The 'Deleted Records' view */

2018-10-26T09:32:04Z

‎The 'Deleted Records' view

Wikiadmin: /* The Audit Trail Popup */

2018-10-26T09:27:39Z

‎The Audit Trail Popup

Wikiadmin: /* Running the 'Update Audit Trail infrastructure process' */

2018-10-26T09:25:30Z

‎Running the 'Update Audit Trail infrastructure process'

Wikiadmin: /* Audit Inserts */

2018-10-26T09:18:38Z

‎Audit Inserts

Wikiadmin: Created page with "{{BackTo|General Setup}} == '''Introduction''' == Audit Trail allows to monitor every data change done in any table or entity through the user interface. Audit trail featur..."

2018-10-26T09:15:41Z

Created page with "{{BackTo|General Setup}} == '''Introduction''' == Audit Trail allows to monitor every data change done in any table or entity through the user interface. Audit trail featur..."

New page

{{BackTo|General Setup}}

== '''Introduction''' ==

Audit Trail allows to monitor every data change done in any table or entity through the user interface.

Audit trail feature monitors data changes such as:
* Insert
* Update
* Delete

Audit trail feature must be enabled by the "System Administrator Role" in the Application Dictionary as the first thing to do is to configure the table/s for which this feature is going to be enabled.

Once a change has been done in a table for which audit trail feature has been enabled, it is be possible to monitor that change through the user interface by using the action button "Audit Trail".

[[file:AuditTrail_History.png]]

=== '''Audit Trail''' ===
Audit Trail view displays read-only infromation about all the recorded data changes done in the tables for which the audit trail feature has been enabled.

[[file:AuditTrail_Window.png]]

=== '''Configuration''' ===
In order to track audit information the system administrator needs to perform two tasks:
* Enable the audit trail for one or more tables in the system
* Run the 'Update Audit Trail infrastructure' process
----
'''Note''': From Openbravo PR18Q2 on the Update Audit Trail Infrastructure process will not be available, and the update of the audit trail instrastructure will require to stop Tomcat, rebuild Openbravo and start Tomcat again
----

In the following sections, a step-by-step guide with more detailed information is provided.

== '''Enabling audit trail for a table''' ==
Enabling/disabling the audit trail feature for a table is done in the Table definition in the Application Dictionary.
* Switch to the System Administrator role
* Goto Application Dictionary -> Tables and Columns
* Navigate to the table for which you want to enable the Audit Trail
* Switch to Edit View
* Mark the "Fully Audited" checkbox and save

=== '''Audit Inserts''' ===
When a table is flagged as Fully Audited, the user can decide if he wants to audit the insertions done in that table.

Full list of '''Audit Trail''' window fields and their descriptions is available in the [[Screenshot:Audit Trail| '''Audit Trail Screen Reference''']].

{{BackTo|General Setup}}

[[Category:User Guide]]

← Older revision		Revision as of 09:34, 26 October 2018
Line 159:		Line 159:
	Simultaneously this window allow a much more flexible filtering/searching.		Simultaneously this window allow a much more flexible filtering/searching.

		+	[[File:AuditTrailWindowDoc.png]]
		+
		+	== '''Limitations''' ==
		+	The audit trail feature will record all data changes (for the table for which it has been enabled) with the following exceptions:
		+	* text fields of types (char,varchar) with a length >= 4k will not be audited
		+	* text fields of types (nchar,nvarchar) with a length >= 2k will not be audited
		+	* BLOB fields (binary stored inside the database) will not be audited

← Older revision		Revision as of 09:32, 26 October 2018
Line 114:		Line 114:

	Then a grid displays all deleted records belonging to this tab/entity. Here one row shown corresponds to a single deleted record and the columns shown are the same as the ones shown in the normal grid view of the same tab.		Then a grid displays all deleted records belonging to this tab/entity. Here one row shown corresponds to a single deleted record and the columns shown are the same as the ones shown in the normal grid view of the same tab.
		+
		+	[[File:Audittrail popupDeleteDoc.png]]
		+
		+	This view offers a number of navigation choices to view related or more detailed information.
		+
		+	Navigation: '''Back to history'''
		+	The first one being '''Back to history'''. Following this link the view is just switched back to 'Record History' showing the same records as shown before going to the deleted records view.
		+
		+	'''Navigation: History of selected record'''
		+	The next one '''View history of selected deleted record below''' allows to examine the detailed history of a deleted record, instead of the summary view which is shown here.
		+
		+	This detailed history is displayed in the same 'Record History' view, however its top info area notes the fact that the history of a deleted record is displayed.
		+
		+	The following screenshot shows an example for the history view of the same deleted 'Sales Order' entry. Comparing with the previous example of this view new history entries corresponding to the deletion are shown in addition to the older information about the record creation and modification.
		+
		+	[[File:Audittrail popupRecordHistoryDoc.png]]
		+
		+	'''Navigation: Child Tabs'''
		+	As the last method of navigation the popup allow filtering of records based on a parent record. This can be useful to i.e. search for deleted lines belonging to some sales order.
		+
		+	There are two possible ways based on if status the parent record: still existent or already deleted.
		+
		+	If the parent record (i.e. a Sales Order) does still exist, then the following steps can be done two view its deleted lines:
		+	* Go to the the lines tab of the Sales Order
		+	* Click the audit trail icon to open the record history view
		+	* Use the 'Deleted Records' links to switch to deleted records view
		+
		+	As the lines tab is not a top level tab (it has a parent tab Sales Order) the deleted records view is automatically filtered to only show lines belonging to the current Sales Order. As a visual information that the information shown is filtered, the top info area shows:
		+
		+	[[File:Audittrail popup4.png]]
		+
		+	If the parent record (i.e. a Sales Order) does not exist anymore, then the same can be accomplished by using the following steps:
		+	* Goto the 'Deleted Records' view of the Sales Order tab
		+	* Search the Sales Order for which the deleted lines should be shown
		+	* Click on the Lines link just below the grid
		+
		+	Then the deleted records view will show the deleted lines belonging to the selected (deleted) Sales Order.
		+
		+	== '''A generated Audit Trail Window''' ==
		+	The second interface to view audit data is a normal generated window which is based on the AuditTrail entity, and allows browsing all audit information filtered by the currently active client. Open the Application menu and navigate to General Setup, Security and select Audit Trail.
		+
		+	It offers a raw view on the audit data meaning that no translation of raw values is done but instead the raw column values of each change are displayed.
		+
		+	Simultaneously this window allow a much more flexible filtering/searching.
		+

@@ Line 85: / Line 85: @@
 * 'Record history' of a single record
 * 'Deleted records' of a single tab
 == '''The 'Record History' view''' ==

← Older revision		Revision as of 09:25, 26 October 2018
Line 56:		Line 56:
	== '''Running the 'Update Audit Trail infrastructure process'''' ==		== '''Running the 'Update Audit Trail infrastructure process'''' ==

		+	'''Note''':
		+	* From Openbravo PR18Q2 on the Update Audit Trail Infrastructure process will not be available, and the update of the audit trail instrastructure will require to stop Tomcat, rebuild Openbravo and start Tomcat again
		+	* Executing this process causes database to be locked, which might stop any other parallel process.
		+	Therefore, it is '''highly discouraged''' to run in while there is activity in the system. It should be executed while in non working hours, or with the system in maintenance by compiling the application from command line.

		+	The audit trail system uses a number of generated triggers (one per table to be audited) to collect the audit data for all changes.

		+	These triggers need to be regenerated once the following actions have been performed:
		+	* The Audit Trail feature has been enabled or disabled for a table
		+	* There has been any structural change to a table being audited (i.e. new columns, changed columns)
		+
		+	This process can be execute as described below:
		+	* Switch to System Administrator role
		+	* Go to Application Dictionary
		+	* Start the 'Update Audit trail infrastructure process'
		+	* After confirmation, the process starts and recreates all audit triggers (by removing and creating them again).
		+	* While this process is executed the background scheduler is suspended
		+
		+	'''NOTE''': This process is also automatically executed on each compilation if the audit trail feature has been enabled for any table.
		+
		+	[[File:AuditTrailUpdateAuditTrail.png]]
		+
		+
		+	== '''The Audit Trail Popup''' ==
		+	For the set of tables for which the audit trail feature has been enable a new button [[file:WIK button Audit.png]] is shown in the toolbar of the corresponding windows. It gives access to the Audit Trail Popup.
		+
		+	This popup allows examination of the history of the record which is currently shown in the window. It has two main view modes which allow to examine the following data:
		+	* 'Record history' of a single record
		+	* 'Deleted records' of a single tab
		+
		+
		+	== '''The 'Record History' view''' ==
		+	This view is displayed when the popup is opened from an existing record via the new toolbar button.
		+
		+	The top area always shows a reference to the entity (i.e. Sales Order) and the record "1000175 - 2016-04-03 00:00:00.0-0.00" for which the history is displayed.
		+
		+	Then a number of filters are available which allow some restriction on the changes displayed to ease the use for record with many modifications.
		+
		+	The grid in the lower area shows all changes done to this record while the audit trail feature was enabled. The changes are shown sorted from the most recent change back to earlier changes.
		+
		+	'''Note''':
		+	* Only fields which are visible in the corresponding tab are shown here
		+
		+	A row in this grid corresponds to a single changed field. For changes to an existing record the number of grid entries shown correspond to the number of fields changed. For new record creations or record deletion one row in the grid is shown per field of the inserted/deleted record.
		+
		+	[[File:Audittrail popup.png]]
		+
		+	Finally a link just on top of the grid allow switching to the 'Deleted Records' view. Following that link will show deleted records for the tab from which the Audit Trail popup was opened.
		+
		+
		+	== '''The 'Deleted Records' view''' ==
		+
		+	This view allow examination of records which have been deleted from a tab and are otherwise no longer accessible in the user interface.
		+
		+	The general layout of the view is similar to the record history view.
		+
		+	An info on the top shows a reference to the entity for which the deleted records are shown. Directly below a number of filters is available to restrict the records shown.
		+
		+	Then a grid displays all deleted records belonging to this tab/entity. Here one row shown corresponds to a single deleted record and the columns shown are the same as the ones shown in the normal grid view of the same tab.

@@ Line 42: / Line 42: @@
 === '''Audit Inserts''' ===
 When a table is flagged as Fully Audited, the user can decide if he wants to audit the insertions done in that table.
 Full list of '''Audit Trail''' window fields and their descriptions is available in the [[Screenshot:Audit Trail| '''Audit Trail Screen Reference''']].