Viewing the record history
In SQL Server databases, you might be able to view the history of the changes that are made to records in the database (provided your organization uses this feature). How far back the history goes depends on how frequently your system administrator archives this data.
Select the records to view:
Note: If Audit History is not configured, these menu commands are missing.
- In any list of records, right-click on one or more selected records, and from the menu, select Show History.
- With a record open, click History.
- To select further records of interest, open the Audit History Viewer, and click Select.
- Refine your selection:
Note: Depending on the database, the number of times the records have been viewed, but not edited, is displayed in the Views column. Viewing includes all the following activities: listing in a record list, opening a record, listing or viewing in the Audit History.
- Filter the records that are displayed by user, entity and link type, and by time.
- To display all records touched by a specific user, in the Records to display area, select All records used by and select the username from the list. The selected username is displayed as a reminder.
- To filter by entity and link types, in the Types to display area,
select the entities and link types.Note: Only types with records in your selection are listed, and the records for a selected type are displayed only when the appropriate checkbox is turned on.
- To filter by time, in the Time period to display area, select a time period.
- Select the information to display in the edit history:
- Make sure that by all users is selected from the Show Edits list.
- Select from the following options:
- Show Headers - to hide or show the shaded line that displays either the date/time/username or the field name. You cannot expand and collapse when this option is turned off.
- Plus - to expand the history.
- Minus - to collapse the history.
- Audit - groups the entries by the name of the user who worked on the record and when they were created, updated, or deleted.
- Field - groups the entries by the data that has been added, updated, or deleted. Click again to sort in ascending or descending order by date edited.
- Edits - displays a history of the changes to the record (only available if the database is set to audit level 5)
- Views - displays a history of who viewed the record and when (only available if the database is set to audit level 5)
- To display the history for a specific user, from the Show Edits list, select the username.
|The old and current values.
|The logon name of the user who made the change.
|The date and time of the change.
|If required by the database, the reason given by the user for making the change.
|The Windows™ name of the user made the change.
|The machine that the user was working on.
|The location as entered in the User Information.
|When is turned off, the update was made outside iBase.
|You might see an Extra Detail column that displays additional information for the current record.
- The name of the icon if an alternative icon is assigned to the record.
- The icon color (which is blank if the standard icon color is used)
- The record status (applicable only if Soft Delete is used). The record status can be Soft Deleted, Normal (the record has been soft deleted and restored), and Purged.
- Security Classification, the old and new SC code (if this feature is used and if you have authority to view this information)