2.7 NC_CompChanges View

The NC_CompChanges contains information about hardware and software changes.

Column

Key

Type

Null

Description

CompChangesOID

PK

binary(16)

No

Internal ID number used as primary key.

TypeOfChange

smallint

No

Created, field value edited, deleted, etc. The complete list with codes is:

0 Created

1 Edited

2 Deleted

3 Moved

4 Retired

SourceOfChange

smallint

No

Collector, Collection Server, Mgr, etc. The complete list with codes is:

0 Collector

1 Field Editor

2 Collection Server

3 Manager

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

 

Date that the change was captured by the collector.

PrevWkstnOID

 

binary(16)

 

Workstation with which the component was associated.

ComponentOID

FK

binary(16)

No

Reference to the component changed.

NOTE: The NC_CompChanges View is a union of all CompChanges tables like NC_BiosChanges, NC_CDRomChanges, NC_HotfixChanges and so forth.