SCRM 2006 SC_EventFact_View

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