Querying Audit Records : Stopping an Alert

Stopping an Alert
To stop an alert from running, you can disable its action or delete the alert entirely.
Note Deleting an alert does not delete any email group associated with its action. Email groups associated with an EmailAlert action remain in the system for use with other alerts.
1
The Edit Alert window appears.
2
Clear the Enabled checkbox, and click OK.
The alert action is disabled. You can enable it again later.
1
Click the alert to select it.
2
Click the Delete button.
A window prompts you to confirm the deletion.
3
Click Yes to confirm.
The alert is deleted and can no longer run.
Printing Reports
AuditMaster lets you print reports from the audit record grid.
1
2
Select File Report.
The Report Builder window appears.
Figure 7-7 Report Builder after Running a Query and Selecting Audit Records
3
If you want to load and customize a saved report, click the Open Report File button and select the settings file for an existing report.
The report is loaded.
4
In the Report Title field, enter a name for this report.
This name will appear at the top of your printout.
5
You may select up to 30 columns. If you already selected a range of columns and rows, these are listed under Selected Columns. You may double-click other column names to move them to Selected Columns. Clicking Select All moves over all columns.
6
Select the Rows to Print.
w
All Rows. Click to select all rows of the columns you selected.
w
A Range of Rows. Click to define a range of rows and change the row numbers shown, which by default indicate the rows you highlighted in the audit record grid before you opened Report Builder.
7
w
Table Border. If you want the tables to have borders, select the border type from the drop-down list.
w
Print Page Numbers. Check the box beside the option to include the page number. Select whether to print the page number in the Left Footer or Left Header of the printout, as well as whether to include Date and Time.
w
Print Report Title. Select whether you want the report title to appear On Every Page or On the First Page Only.
w
Print Date and Time. Select if you want the date and time to appear in the footer of each printed report page.
8
The Report Print Preview window displays the report on-screen as it will be printed.
9
From the File menu in the Report Print Preview window, you may do the following:
w
Select Save Report As to save the current report settings for future reuse.
w
Select Open Report to use the settings in a saved report.
w
Select Page Setup to adjust standard page settings.
w
Select Print Setup to adjust standard printer settings.
w
Select Print to print the report.
w
Select Exit to return to Report Builder.
Searching Audit Records
You can use the search command to find particular users, operation types, or values for the current audit records grid view. AuditMaster uses a sophisticated search engine, so it is easy to use different search options and directions. Searches can also be made case-sensitive.
Note Depending on the number of records and the complexity of the search criteria, it may take some time to complete your search. Whenever possible, try to narrow your criteria.
1
Run a query, if needed.
2
Select Tools Search.
The Search window appears. Also, if you have clicked in the audit record grid, the field you clicked is highlighted in blue as the current column and its row is highlighted in yellow.
3
Your search entries are saved in the drop-down list for the current session.
4
w
In the Direction drop-down list, select a direction to start the search. These include, From Top row down, the Next row down, and the Previous row down.
w
In the Position drop-down list, select a search position. Select Anywhere or Beginning of cell, as appropriate.
w
w
5
w
Select Entire Grid to search all columns.
w
Select Current Column to search only the column selected, which is indicated as a blue field in the yellow highlighted field that you have clicked. If this column is not the one you want to set as the current column to search, close the Search window, click the desired column, and search again.
w
Select Specific Column and select a column name from the drop-down list.
6
Found items, if any, appear highlighted in the audit record grid. Otherwise, the status bar at the bottom of the Search window displays the message, “The text was not found.”
Sorting Audit Records
Audit records can be sorted on up to three visible data fields. If needed, reset Visible Columns to add columns for sorting.
1
Run a query, if needed.
2
3
Select Tools Sort.
The Sort window appears.
4
For example, User Name to order records alphabetically by user.
5
Select Ascending or Descending order for sorting.
For example, if you are sorting by Time, to start the list with the most recent records, choose Descending.
6
To sort again using a second and third column, select from each Then By drop-down list, including Ascending or Descending.
7
The audit record grid displays the sorted records.
Exporting Audit Records to Other Applications
AuditMaster can export any query result to a comma- or tab-delimited text file for importing into other applications.
Note Only records and fields visible in the query result are exported.
1
Run a query, if needed.
2
Select Tools Export.
The Export window appears.
3
4
5
Click OK to export the file to filename.txt.
The export file is saved to the location and name you provided.
Note You can also extract audit data directly by copying from the AuditMaster audit record grid and pasting the rows and columns into another application, such as a spreadsheet.
Displaying Audit Records under Pervasive PSQL Security
If you run AuditMaster with Pervasive PSQL security enabled, field values in the User Name and Database Name columns vary with the DefaultDB database security policy and the type of database operation as shown in the following table.
 
Audited Btrieve operations include Select/Read, Insert, Update, Delete, Login, and Logout. For Begin Transaction, End Transaction, Abort Transaction, and Reset operations, which are not associated with a specific database, the database name is not available.
Login errors are listed with the invalid user name and/or database name. For SQL logins, the host name is not known at login time but afterward the host name becomes available and is displayed for SQL operations.
Under Mixed security, database logins match OS or network logins.
Note For more information on database operations in a Pervasive security environment, see the security chapter in Pervasive PSQL Advanced Operations Guide.
Using AuditMaster Undo
On Windows platforms, the AuditMaster Undo command makes it possible to reverse certain database events. Successful results depend on the operation to be undone and the current state of the record involved, which may have changed again since the event occurred (e.g., unique indexing). In the case of updates to application data fields, the Before and After columns in the detail view identify what data value AuditMaster can attempt to restore to the Before state.
 
Caution Before attempting an undo, consider the following:
w
w
w
w
Note: Remote client logins do not support undo.
1
The shortcut menu appears.
2
Select Undo Operation(s).
The system prompts you to confirm the undo attempt.
3
Click Yes, or Cancel if you change your mind.
If you selected multiple records to undo, you may select Yes to All to attempt to undo all of them without further interaction, or use the Skip and Yes buttons to work through them one at a time.
Note An undo operation is itself captured as an audit record and can be reversed by an additional undo.