View database modifications

For more information on modification tracking, see Track modifications.

You can search for all database modifications or apply filtering to return modifications for only those tables and columns you specify.

Note: To view database modifications, you must enable modification tracking. For more information, see Turn modification tracking on/off.

To view a current list of modifications:

1. In the Operations Control Management Console, expand a server group, and then expand a server.

2. Right-click Configuration Editor (or any sub-items in the console tree) and then click Track Modifications. The Modification Tracker - Selection dialog box appears.

   

3. In the Modification Date area, configure the time span for the search.

   All Modification Dates

   Returns all changes to table columns made since modification tracking was first enabled.

   Between

   Returns all modifications between the start date and end date that you specify. Click the date arrow to access a calendar in which you can pick the date.

   During the Previous

   Returns all modifications for a recent time period. Durations can be in minutes, hours, days, weeks, or months.

4. In the Modification Type area, select the types of modifications to search for.

5. In the Object Type area, set the type of modifications to search for.

   Table Name

   Returns modifications for all tables in the database or for a specified table. Only tables that currently have modifications appear in the list.

   Column Name

   Returns modifications for a specified column in the selected table. This option is only available if you select to filter on a single table.

   Object Key

   The key identifier for the column modified in the table. For example, TagName for the Tag table, Name for the Topic table, and so on.

6. To reset the dialog box options back to the defaults, click Clear.

7. Click Search to search for database modifications according to the filter options you select. A list of all matching modifications appears.

   

   Column descriptions are as follows:

   Date and Time

   The timestamp of when the modification occurred.

   Table

   The name of the modified object.

   Column

   The name of the modified column.

   Modification Type

   The type of modification.

   Row Key

   The key identifier for the column modified in the table. For example, TagName for the Tag table, Name for the Topic table, and so on.

   New Value

   The new value stored in the column, if the modification was to a configuration table. For modifications to history data, this column contains the total count of consecutive value updates attempted.

   Old Value

   The value stored in the column before the modification was made, if the modification was to a configuration table. For modifications to history data using SQL INSERT and UPDATE statements, this column contains the timestamp of the earliest data affected by the INSERT or UPDATE operation. If multiple changes are made to the same data, then only the most recent change will be contained in this column. This column is not used for modifications made to history data using a CSV file.

   User

   The name of the database user that made the modification. The value of this column reflects the Windows authentication user name (for example, DOMAIN\user_login_name) or the SQL Server authentication user name (for example, dbo), depending on how the user is logged into the SQL Server when the modification is made. In the case of a CSV file import, this column contains the user name as it appears in the CSV file.

8. To sort on a column, click the column name at the top of the window.

9. Click Cancel to close the dialog box.