VPM Enterprise activity tracking is a system management tool that tracks where a user goes in an application. Activity tracking maintains a log of a user’s:

·       Entry into and exit from an application.

·       Forms that are run.

·       Build and Run Application selections (in VPM Enterprise).

You can reach the Activity form from the PM-Admin menu or from the Admin menu of an application. The Activity form lets you view each user’s activity records.

Find Form

System tables are accessed using filtered views that can become remote views in a client-server application. Therefore, when you access the Activity form, a custom SQL Find Form appears to let you select the Activity records you wish to view.

On the Find form, you can select:

·       Date Range: Enter a date range of activty records to select.

·       Users - All: If you’ve turned on User Access Security in your application, you can view activity for all users who have run the application by clicking the All option button in the Users box.

·       Origins - All: If the application is sharing its activity file with another application, you can view activity for all applications by clicking the All option button in the Origins box.

Make your selections and a list grid will appear from which you can select the Activity record to view first.

Activity Form

When the Activity form appears, the activity records selected are shown in descending order of the time and date the activity occurred. 

You can:

·       Order: Change the order to ascending through the Order button on the Form Toolbar.

·       Form Controls: You cannot edit or add activity records but you can delete them. 


You use the information on the Activity form if questions arise regarding a user’s activity in an application.

Tip: You should delete the activity records before you package your application for distribution.

Tip: You can add your own records to the activity table to keep track of whatever type of activity you desire. You add a record to the activity table with the following call: _SCREEN.oApp.RunAdminTool(“ACTIVITY”,”<Type>”,”<Description>”)

The following table explains the fields on the Activity form.

Activity Fields


User ID

Blank if User Access Security is not on in the application; otherwise, contains the ID of the user who experienced the activity.


The Origin entry from the Options - Environment form in VPME, or if blank, the 3-character prefix, of the application that experienced the activity.


Date and time the activity occurred.


A description of the action that produced the activity record.


Identifies where the action occurred.

Activity Report

The application Report Manager contains an activity report. The activity report prints each user’s activity in the activity table. You can select the report’s order, filter and scope.

Activity Table

The activity records are stored in the SVPMActivity.DBF table.

Activity Management

If an application gets a lot of use, the number of records in the activity table can get large very quickly. Periodically, backup the activity table and delete its records. You can use the Group Delete Toolbar control on the Activity form or the Zap function in the Data Manager.


Audit Trail