Create an audit report in Microsoft Excel
This example shows you how to import audit data from the SQL Server database and analyze the data in Microsoft Excel 2010.
The following sections describe how to create an audit report in Microsoft Excel by following these key steps:
- Set up a connection to the auditing database (create a new data source).
- Create a query in Microsoft Query.
- Return data to Excel.
- Create a report in Excel (a table or a PivotTable report).
Note We recommend using numeric IDs instead of string values if you want to bind any
external logic to exported audit data. For example, instead of using values from the
TargetType field, use the values from the
TargetTypeId field. This will help to avoid potential
compatibility issues should any string values change in a future release of Sophos Enterprise Console. For a table of numeric IDs, see
Appendix: Numeric IDs of the data field values.
For more information about importing SQL Server data and creating reports in Excel, see Microsoft documentation.