Advanced Operations

Features for Power Users and Programmers

This advanced operations chapter is for power users and programmers who need utilities and methods for accessing audit system beyond what is offered in AuditMaster Viewer.

n	Managing Schemas from the Command Line

n	Querying Audit Data Directly through SQL

n	Using the Delta Alert Utility

 

Managing Schemas from the Command Line

AuditMaster Schema Maintenance Wizard has a command-line version amschemamaint.exe, located under <installation directory>\Audit\Bin in a default installation. The AuditMaster installation calls this utility to create the Pervasive PSQL Demo and Pervasive PSQL Generic audit configurations by importing the following two files from the Schema folder in the install image root:

n	Pervasive.SQL_Demo_V9.add

n	Pervasive.SQL_Generic.add

In third-party applications, amschemamaint.exe can be used in scripts to export a schema to a file in the \Schema folder on a custom CD-ROM to automate its importing at installation time. The sequence of usage would be as follows:

1	Install your application.

2	Install AuditMaster.

3	Run amschemamaint.exe to import from the \Schema folder.

Note If you use amschemamaint.exe to customize an installation CD-ROM and wish to delete Pervasive.SQL_Demo_V9.add so that it does not appear in the Audit Configuration window, you may do so. However, do not remove Pervasive.SQL_Generic.add, since it is needed for successful operation of AuditMaster.

The amschemamaint.exe utility has four forms:

n

import

n

export

n

remove

n

list

Each of these is explained in the rest of this section.