FAQs - ApexSQL Audit Viewer

ApexSQL Audit supports Microsoft SQL Server versions 7.0, 2000 or 2005.

See our Getting Started topic. You will have to pass three main steps: connect to the database and choose the appropriate report type (Standard or Aggregate), set up the filter criteria and press the Filter button.

Standard reporting provides a straight forward way to view your data basically as it is stored in the Audit log. The data is transactional NOT row based meaning that each Cell - not database row - makes up a row in the Standard Report.

Aggregate reporting is Transaction based. For example, where an insert could generate 4 rows in the Standard table, one row for each field affected, it can only ever generate a maximum one row in Aggregate reporting. Aggregate reporting allows more powerful tracking of individual usage patterns for error diagnostics or to track missing/bad data to the source.

First select Standard Report and then set your filter criteria. Then click the Filter button.

A powerful feature of the standard reporting form is Column Grouping which allows you to group data by any column on the grid for even more powerful analysis. For example - if you group by Table, Primary Key and Modified Date you have grouped the audit data by the actual row of data affected. You can group by Table, User, Computer or any number of combinations.

First select Aggregate Report and then set your filter criteria. Then click Filter button.

In the Group By section, you are presented a list of fields to select from which currently include Database, Table Name, Modified By, Action, Computer, Application and Date. Selecting Table_Name for example will display the Table name in the report results and will also group by Table Name. So, if you simply choose Table_Name and no other field, your audit viewer report would display the number of Audit Transactions that have occurred for each table in the database.

After you have selected the filter criteria and chose your report type, press the Filter button.

Yes. Once the report was generated you can choose between Data, Excel and Text File reports, under Report Output menu.

In Command Line Interface you can choose between csv / xls and pdf output format:

/rf:csv
/rf:xls
/rf:pdf

For example: apexsqlauditviewer.com … /rf:csv

Yes. On Filter Criteria you can change your Row Count. The default value is 1000 rows.

Filter Criteria are basically options regarding reporting. Under Custom Filter you are able to write your own expressions.

Yes, ApexSQL Audit Viewer supports Command Line Interface mode. Simply run apexsqlauditviewer.com file from the installation folder.