AnswerTo use the audit features in GFI Archiver a Microsoft SQL Server is required to store the audit data. The data can also be stored in the Express edition of Microsoft SQL Server. Two different modes audit modes can be enabled independently from each other:
Database Activity Auditing uses the tracing capabilities of Microsoft SQL Server to record all the activity affecting the GFI Archiver archive store databases. This auditing mode can only be used for archive stores of the type:
- Microsoft SQL Server
- Microsoft SQL Server with File Storage (GFI MailArchiver 2014 or newer only)
- Microsoft SQL Server Express with File Storage (GFI Archiver 2014 or newer only)
User Interaction Auditing allows you to record all activity that happens through the GFI Archiver web interface - such activity is logged into the Microsoft SQL Server database and viewed from the Reports node within the GFI Archiver web interface. This auditing mode be used in combination with all archive store types.
Note that if a mixture of Archive Stores is being used (both Firebird and Microsoft SQL Server), all user activity on the GFI Archiver web interface is logged, even though these actions are performed on a Firebird database.