Activity Log |
The Activity Log screen tracks user’s transactions within the application. It can be used to determine which user (or users) executed any of the following transactions on any screen:
Insert (new record)
Update (change existing record)
Delete
The Activity Log screen provides an audit trail for security purposes. It does not display information entered on the System Mgmt -> Setup -> Access Rights Change Password screen.
Note to System Administrators: Because this screen displays potentially sensitive information, consider granting access only to system administrators. Two screens on the System Mgmt -> Setup -> Access Rights menu determine which screens users can access: the Rights Templates tab of the User Groups screen and the Groups Currently Assigned tab on the Users screen.
Tip: To limit the display of information in the grid and maximize performance, use the filter. You can sort on user ID, date range, screen ID, key values, or action (INSERT, UPDATE, DELETE).
The field in the top section of this tab defines the data that displays.
User ID
Identifier of the user who processed the activity. The user name displays to the right of the ID.
Data in the fields on the bottom section of this tab display the transactions. All fields are display only.
Activity date and time
Date and time that the activity was processed.
Screen ID
Identifier of the screen on which the activity was processed.
Tip: To determine the screen ID for a specific screen, go to How to display a field's properties (screen, window, and control IDs; and table and column name).
Key values
Identifying information about the row that was inserted, updated, or deleted by the activity (transaction) selected in the grid. For example, a user uses the Locations - Primary Information screen to update a shop's fax number. The Key value field on the Primary Information screen is the location ID. The affected location ID displays in this field.
Tip: The Activity Log records activities performed on the Work Order Center screen with equipment ID as one of the key values. To filter on all activities processed on the Work Order Center for equipment ID ABC123, for example, enter values in the filter for Screen ID: 2037 and Key values: %ABC123%.
Tip: The Advanced Info tab on the System Mgmt -> Setup -> Screen Design -> Controls screen designates controls (fields) as key values on screens.
Action
Type of action performed. The list of actions includes the following:
INSERT: A new data record was inserted.
UNKNOWN: The application cannot determine the type of action processed.
UPDATE: An existing data record was updated.
DELETE: An existing data record was deleted.
CONTINUE: This action is a continuation of the transaction data from an INSERT, UPDATE, OR DELETE action where the data that is being saved for that action is over 2000 characters. There may be multiple CONTINUE rows to contain all the data in the respective transaction. The CONTINUE action row contains the same Screen ID, Key Values, and User ID as the initial transaction.
Transaction row ID
The row of the transaction.
Screen instance
The instance of the screen. This is a number auto-assigned by the system to the screen at the time it is opened, and extra data used by the system.
Transaction data
Data processed in the action. Generally this data is the same for each screen, as shown in the following sample transaction data string (spacing and text effects added for emphasis):
3; 152;2, F14117A; 152;2 E317499; 155;10; IS; 7;0;0;0;1
Where:
Window ID and Control Order: 152;2 152;4 155;10
Primary key (usually EQ ID or work control number): F14117A
E: An E added in front of data means the data has been encoded. Encoding is only for text information, not numeric information.
Row number of data in the database: 317499
Data that was inserted/updated/deleted: IS
Use the System Mgmt -> Setup -> Screen Design -> Controls screen to filter on the Screen ID, Window ID, and Control Order to determine which field was changed. The User Title field will display the field name.
For example, in the filter on the Controls screen, type the screen ID that you are interested in (2024) and the transaction data listed in the example: window ID 155 and control order 10. The User Title field indicates that the life cycle status code ID was changed.