How to work with the ApexSQL Log continuous auditing repository directly, including querying and reporting

word-image

Performing continuous auditing with ApexSQL Log enables users to seamlessly audit SQL Server databases for all DML and DDL changes that occur on the audited database, directly from the transaction log. The audited data is then stored in the repository tables which can be created in any SQL Server database on any connectible SQL Server instance, and these tables will then be continuously updated with new auditing data.

ApexSQL Log continuous auditing repository topography

When continuous auditing is performed, audited data is stored in one of two sets of repository tables, depending if user is performing general auditing or before-after auditing. In this article we are going to provide information on the structures of these tables.

ApexSQL Monitor ad hoc reporting functions (inventory, descriptions and examples)

word-image

Applies to
ApexSQL Monitor

Summary
This article shows the reporting functions needed for ad hock reporting including what each function is, why the function is needed, when each function should be used and how those functions should be used. The reporting functions are designed to help user in retrieving the needed data from the repository database without need to understand and know the data and schema structure of the repository database

Four ways of scheduling ApexSQL tools

word-image

Applies to
All ApexSQL console applications with Command line interfaces (CLI)

Summary
This article describes how to schedule ApexSQL tool tasks to run unattended, at a specific time/date, etc., using four different ways of scheduling.