Advanced Operations : Delta Alert Example
Delta Alert Example
This section provides steps to create and configure a delta query to alert recipients by email when billing amounts are changed in the Demodata database.
‰
To set up a delta alert
1
In AuditMaster, be sure the table or tables to be monitored have been added to an audit configuration. In this example, the table is Billing in Demodata.
2
Follow the instructions under Creating a Virtual Database.
You must use the qdmg utility on the monitored database to enable the delta alert feature to run. This example uses Demodata.
If you’ve already created DemodataV, go to the next step.
3
In AuditMaster, using the steps given under Working with Alerts, create the following alert:
4
In the query for Operations, under Pervasive PSQL(Btrieve) select Modify After.
5
For Tables, under User Tables select Billing.
Query Builder should now look like the following:
6
In the Action for Alert dialog box, select RunProgram.
7
To configure RunProgram, add and select amda.exe, which is found in a default installation in C:\<installation directory>\Audit\bin\.
The Configure Programs dialog box will look like the following:
8
To store the amda command parameters, click Set Parameters and make entries based on the following:
amda -d DemodataV -t Billing -r @RecID -c Amount_Owed,Amount_Paid
For information on this step, see Setting a RunProgram Action and Parameters for the amda Utility.
The entries will look like the following:
9
Set email recipients in amdaemail.cfg. For information on this step, see Setting Delta Alert Email Recipients.
10
Close AuditMaster Viewer and restart Pervasive services to activate the delta alert.
11
In Pervasive PSQL Control Center, open the Billing table in Demodata and change a value in the Amount_Paid column.
A command prompt window announces that column values have changed and email is being sent to recipients.
Recipients receive a message with a header like the following:
From: Auditmaster
Sent: Wednesday, June 08, 2005 3:14 PM
To: DeltaAlertRecipients
Subject: Delta Alert Fired on Record ID 11392
Record ID is the number of the audit record that triggered the alert. The body of this sample mail message looks like this:
Figure B‑1 Structure of a Delta Alert Email Message