LINKS
SITE FEED
Support Forum
The fastest and most effective to get answers to your questions quickly. Click Here for more info.
FAQs 
Quick answers to common questions. Click Here for more info.
Troubleshooting
Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.
Knowledgebase
Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.
Online Documentation
All of our help files for download or convenient viewing online. Click Here for more info.
Videos
Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.
|
ApexSQL Knowledgebase Tips and How-to Articles for Apex SQL Tools Schedule Audit Report generation DESCRIPTION This KB article discusses how to schedule the generation of Audit reports in ApexSQL Audit. SOLUTION In Windows, create a scheduled task for ApexSQLAudit.com with parameters specifying your database and the report format you want (PDF, Excel, or CSV). (1) To schedule a standard report: apexsqlaudit.com /server:(local) /database:Northwind /reportformat:pdf /sreport /action:d (2) To schedule an aggregate report apexsqlaudit.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. How can you set a filter on reports via CLI? This is described in detail on the help file (Command Line > Switches > Filter Options for Reports) 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 Audit 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. SEE ALSO How To Schedule Tasks in Windows XP LAST REVIEW 20 August 2007 Labels: Apex SQL Audit |
© 2008 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy