WkstnChangesOID |
PK |
binary(16) |
No |
Internal ID number used as a primary key. |
TypeOfChange |
|
smallinit |
No |
- 0 = Created
- 1 = Edited
- 2 = Deleted
- 3 = Moved
- 4 = Retired
|
SourceOfChange |
|
smallinit |
No |
- 0 = Collector
- 1 = Field editor
- 2 = Collection server
- 3 = Managed
- 4 = Admin server
- 5 = Web Console
|
FieldId |
|
int |
|
Field ID from the data model. |
FieldLabel |
|
nvarchar(50) |
|
Field name label from the data model. |
Value1 |
|
nvarchar(255) |
|
Old value that was changed. |
Value2 |
|
nvarchar(255) |
|
New value. |
CreateDate |
|
datetime |
No |
Date that the change was entered in the database. |
WorkstationOID |
FK |
binary(16) |
No |
Reference to the workstation changed. |