Schedule ApexSQL Trigger report generation

Applies to
ApexSQL Trigger

This KB article explains how to schedule the generation of ApexSQL Trigger audit reports

First, create a command line statement specifying database and the report format you want (*.pdf, plain text, or *.csv)

  • Command to generate a standard report: /server:(local) /database:Northwind /reportformat:pdf /sreport /action:d
  • Command to generate an aggregate report /server:(local) /database:Northwind /reportformat:pdf /areport /action:d

What is standard reporting?
Standard reporting provides a straightforward way to view data stored in the Audit log. The data is transactional and NOT row-based. This means that each Cell is a row in the Standard Report. This is done to provide a granular, before and after analysis of the effect of the audited action

What is aggregate reporting?
Unlike Standard Reporting (which is Field level-based), Aggregate reporting is Transaction based. For example, an insert can generate 4 rows in the Standard report, that is, one row for each field affected; in Aggregate Reporting, it can only generate a maximum of one row

In Aggregate reporting, transactions are always grouped rather than displayed individually

What does /action:d do?
It displays delete operations on the report

If you omit connection details, does it login with integrated security automatically?
Yes. ApexSQL Trigger logs in with integrated security automatically if connection details are not defined

How can you determine where the report file is written to? What is the default dir?
The default directory is your current directory and not where the application is located

How do I schedule the report generation?
Note the CLI commands above and use either the Windows Scheduler, SQL Server, or Job scheduler’s GUI to run them on a schedule

Using SQL Server
Using Windows Scheduler

See also
How To Schedule Tasks in Windows XP