Audit data

The auditing functionality allows you to access differences between events occurring in a given context. Example: user accesses, changes in fields, person responsible for the change...

Backoffice configuration

• In the Generation tab, go to the Generate client menu and change the client settings
• On the Settings tab, check the Data audit checkbox

Definition of fields to audit

• In the field definitions there is a checkbox that allows you to mark the field to audit:

WebAdmin

• In the System Configuration menu, go to Audit tab and select the most relevant options to audit

• Then, in the Database Maintenance menu:
  • Expand the advanced options
    • Select the options for creating an Audit Database

• The field audits are present in tables "log[sysname]all" or "log[sysname]pro".

Move logs to a separate database

It might be necessary to put the logs in a separate database. This section assumes that your system already has data auditing enabled in the Genio settings.

Then:

• In the Webadmin project, open the Configurations.xml file
• Insert the following code snippet into the DataSystem tag

<DataSystemLog Name="0">
            <Type>SQLSERVER2008</Type>
            <Server>EXAMPLESERVER</Server>
            <Port />
            <Login>EXAMPLE</Login>
            <Password>EXAMPLE</Password>
            <Data Id="EXAMPLE" Schema="EXAMPLED0" ConnEncrypt="false" ConnWithDomainUser="false" />
</DataSystemLog>

• In the System Configuration menu, go to Audit tab and select the most relevant options to audit

• You can find the audit table on the server