Applies to
ApexSQL Trigger
Summary
This KB article explains how to schedule the generation of ApexSQL Trigger audit reports
Description
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:
apexsqltrigger.com /server:(local) /database:Northwind /reportformat:pdf /sreport /action:d - Command to generate an aggregate report
apexsqltrigger.com /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
