SCRM 2006 SC_EventFact_View
SC_EventFact_View lists the events that MOM either collects or generates.
SC_EventFact_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| bigint | Not Null | The computer where the event occurred. | |
| 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). |
| 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. |
| bigint | Null values allowed | The event type. Possible types include the following:
| |
| 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. |
| 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. |
| bigint | Not Null | If known, the Windows or MOM user or group associated with the event. |