v_ModTracking

DateTime

datetime2(7) NOT NULL

The timestamp of when the modification occurred.

Table

varchar(50) NULL

The name of the modified object.

Column

nvarchar(128) NOT NULL

The name of the modified column.

ModType

char(1) NOT NULL

The type of modification. U = Update; I = Insert; D = Delete; 1 = SQL insert; 2 = SQL original insert; 3 = SQL update; 4 = CSV insert; 5 = CSV original insert; 6 = CSV update; 7 = CSV multi-point update; 8 = CSV "fast load" insert.

RowKey

sql_variant NOT NULL

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.

NewValue

sql_variant NULL

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.

OldValue

sql_variant NULL

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

nvarchar(256) NOT NULL

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.