list AuditMaster Schema Maintenance list utility. Description Displays all schemas currently in the audit configuration. Syntax amschemamaint list [-a folder] Options Option Description -a Data directory on remote server where AuditMaster amserver file resides. Optional if amserver resides on the same machine as the client. -h Help Example C:\>amschemamaint listCurrent schema configurations:Pervasive PSQL Generic [<default version>]Pervasive PSQL Demo [10.0]Pervasive PSQL Demo [10]Pvideo [1.0] C:\>amschemamaint list -a \\server_name\volume_name\audit\dataCurrent schema configurations:Pervasive PSQL Generic [<default version>]Pervasive PSQL Demo [10.0]Pervasive PSQL Demo [10]Pvideo [1.0] Querying Audit Data Directly through SQL The AuditMaster Viewer client and its query builder are not the only means of access to audit records. You also can run direct SQL queries against audit records. To do so, you must first use the Query Data-Model Generator (QDMG) utility provided with AuditMaster. The utility generates a script to create a virtual database of views linked to audit records in the AuditMaster system. Both current view and archived audit records can be queried directly using the query data-model method. Direct queries can support applications to create reports or otherwise display audit records, as well as serve development and debugging purposes. Use cases are provided to demonstrate how to apply the direct query method to the Demodata database included in the Pervasive PSQL installation. This section covers the following topics: n Query Data-Model Generator Utility n Creating a Virtual Database n The Structure of an Audit Record n Running a Query on the Current View File n Running a Query on an Archived File n Summary of Direct Query Methods