Audit Log Consolidation (ALC) Database Schema

This topic attempts to explain the ALC database schema—the current structure of the tables and database views in the database; thus empowering you to create custom queries, which are not possible through ALC Reports.

The ALC database consists of six user-defined tables:

Note: BindView recommends that you do not modify the tables in the ALC database manually.

The ALC database consists of the following two user-defined views:

Based on the above information, you can create custom queries to suit your individual needs and extract relevant information directly from the ALC database.    

Sample Queries:

If you wish to know the total number of users that were created in a specified time range...

If you wish to know the number of times a logon attempt was made using a disabled account...