Query Data-Model Generator Utility Query Data-Model Generator utility for Pervasive AuditMaster. Description Generates a script, consisting of a set of SQL statements, to run against an empty database. The script populates this virtual database with views that link to audit records stored in the AuditMaster log file. Once the views are created, you can then run queries against them to return results from audit records within AuditMaster. Syntax qdmg -d DDF_path [-m password] -p name ‑o file [‑l logfile] [-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. -d Path name of database schema (.ddf files) to import -m Master password if database is secure -p Name of application in the Product Name field in Audit Configuration window. With spaces, use quotation marks. -o Path and file name of output (.sql) file for generated SQL. If no path name is given, the file is written to the current directory. -l The default is amlog. -h Help The log file contains records for the current view file in AuditMaster Viewer. You can also access audit records in archived files, but queries on the current view file must be enabled first. Follow these short procedures in the order given: 1 Creating a Virtual Database 2 Running a Query on the Current View File 3 Running a Query on an Archived File