SCRM 2006 SC_ClassInstanceFact_View

System Center

SC_ClassInstanceFact_View lists MOM class instances.

SC_ClassInstanceFact_View

Column Type Constraint Description

ClassDefinition_FK

bigint

Not Null

Represents the class definition of the class instance. Foreign key to the ClassDefinitionDimension.

ClassInstanceID

Unique identifier

Not Null

The GUID identifying the class instance.

ConfigurationGroup_FK

bigint

Not Null

The management group where the class instance is defined.

DateAdded_FK

bigint

Not Null

The date the class instance was added to the operations database.

DateLastModified_FK

bigint

Not Null

The date the class instance was last changed.

DateTimeAdded

datetime

Not Null

The date and time the class instance was added to the operations database.

DateTimeLastModified

datetime

Not Null

The date and time the class instance was last changed.

DateTimeOfTransfer

datetime

Not Null

The date and time the class instance was transferred to the reporting database.

KeyValue

nvarchar(400)

Not Null

The key value of the class instance.

SMC_InstanceID

bigint

Not Null

The surrogate key for this item.

State

int

Null values allowed

The state of the class instance.

TimeAdded_FK

bigint

Not Null

The time the class instance was added to the operations database.

TimeLastModified_FK

bigint

Not Null

The time the class instance was last changed.

UserLastModified_FK

bigint

Not Null

The last user to change the class instance.

See Also

Show: