SCRM 2006 SC_EventFact_View

  • Article

SC_EventFact_View lists the events that MOM either collects or generates.

SC_EventFact_View

Column Type Constraint Description

Computer_FK

bigint

Not Null

The computer where the event occurred.

ComputerLogged_FK

bigint

Not Null

The computer where the event was collected.

ConfigurationGroup_FK

bigint

Not Null

The management group where the event is defined.

DateGenerated_FK

bigint

Not Null

The date the source event—for example, a Windows NT event log entry—was generated.

DateOfFirstEvent_FK

bigint

Not Null

For consolidated events, the date the first event was generated.

DateOfLastEvent_FK

bigint

Not Null

For consolidated events, the date the last event was generated.

DateStarted_FK

bigint

Not Null

For consolidated events, the date the first source event was generated.

DateStored_FK

bigint

Not Null

The date the event was added to the MOM database.

DateTimeGenerated

datetime

Not Null

The date and time the source event—for example, a Windows NT event log entry—was generated.

DateTimeOfFirstEvent

datetime

Null values allowed

For consolidated events, the date and time the first event was generated.

DateTimeOfLastEvent

datetime

Null values allowed

For consolidated events, the date and time the last event was generated.

DateTimeStarted

datetime

Null values allowed

For consolidated events, the date and time the event consolidation started.

DateTimeStored

datetime

Not Null

The date and time the event was added to the MOM database.

EventData

image

Null values allowed

The event data (binary).

EventDetail_FK

bigint

Not Null

Additional details about the event.

EventID

uniqueidentifier

Not Null

The Windows event log ID corresponding to the MOM event.

EventMessage

nvarchar(3500)

Null values allowed

The message describing the details of the event.

EventType_FK

bigint

Null values allowed

The event type. Possible types include the following:

  • 0 — Success
  • 1 — Error
  • 2 — Warning
  • 4 — Information
  • 8 — Audit Success
  • 16 — Audit Failure

IsAlerted

bit

Not Null

Indicates whether the event generated an alert.

IsConsolidated

bit

Null values allowed

Indicates whether multiple events of the same kind are being reported as a single event.

LocalDateGenerated_FK

bigint

Not Null

The date the source event—for example, a Windows NT event log entry—was generated. This value includes the database server's local date and time offset.

LocalDateStored_FK

bigint

Not Null

The date the event was added to the MOM database. This value includes the database server's local date and time offset.

LocalDateTimeGenerated

datetime

Not Null

The date and time the source event—for example, a Windows NT event log entry—was generated. This value includes the database server's local date and time offset.

LocalDateTimeStored

datetime

Not Null

The date and time the event was added to the MOM database. This value includes the database server's local date and time offset.

LocalTimeGenerated_FK

bigint

Not Null

The time the source event—for example, a Windows NT event log entry—was generated. This value includes the database server's local date and time offset.

LocalTimeStored_FK

bigint

Not Null

The time the event was added to the MOM database. This value includes the database server's local date and time offset.

ProviderDetail_FK

bigint

Not Null

The source of the event information.

RepeatCount

int

Null values allowed

For multiple events, the number of duplicates that occurred.

SMC_InstanceID

bigint

Not Null

The surrogate key for this item.

TimeGenerated_FK

bigint

Not Null

The time the source event—for example, a Windows NT event log entry—was generated.

TimeOfFirstEvent_FK

bigint

Not Null

For consolidated events, the time the first event was generated.

TimeOfLastEvent_FK

bigint

Not Null

For consolidated events, the time the last event was generated.

TimeStarted_FK

bigint

Not Null

For consolidated events, the time the first source event was generated.

TimeStored_FK

bigint

Not Null

The time the event was added to the MOM database.

User_FK

bigint

Not Null

If known, the Windows or MOM user or group associated with the event.

See Also

Reference

SCRM 2006 SCRS_ComputerDimension_View
SCRM 2006 SC_EventDetailDimension_View
SCRM 2006 SC_EventTypeDimension_View
SCRM 2006 SC_ProviderDetailDimension_View

Other Resources

SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures