Поделиться через


SCRM 2006 SCRS_AlertFact_View

SCRS_AlertFact_View lists all MOM alerts currently in the SCRM presentation database.

SCRS_AlertFact_View

Column Type Constraint Description

AlertDescription

nvarchar(2000)

Null values allowed

The AlertDescription column stores the alert description.

AlertID_PK

uniqueidentifier

Not Null

The GUID identifying the MOM alert.

AlertLevel_FK

bigint

Not Null

The AlertLevel_FK column stores the severity of the alert.

AlertName

nvarchar(255)

Not Null

The AlertName column stores the name of the alert.

AlertResolutionState_FK

bigint

Not Null

The resolution state of the alert.

Computer_FK35a0da97-2140-4988-8185-f5ee2907eff1

bigint

Not Null

The name of the computer that raised the alert.

ConfigurationGroup_FK

bigint

Not Null

The management group containing the computer that raised the alert.

Culprit

nvarchar(255)

Null values allowed

The name of the Windows service that was the source of the alert.

DateAdded_FK

bigint

Not Null

The date the alert was added to the MOM operations database.

DateOfFirstEvent_FK

bigint

Not Null

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

DateOfLastEvent_FK

bigint

Not Null

For consolidated events, the date the latest event was raised.

DateRaised_FK

bigint

Not Null

The date the alert was raised.

DateTimeAdded

datetime

Not Null

The date and time the alert was added to the MOM operations database. Values are based on the UTC standard.

DateTimeLastModified

datetime

Not Null

The date and time when the alert was last modified.

DateTimeOfFirstEvent

datetime

Null values allowed

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

DateTimeOfLastEvent

datetime

Null values allowed

For consolidated events, the date and time the latest event was raised.

DateTimeRaised

datetime

Not Null

The date and time the alert was raised.

DateTimeResolved

datetime

Null values allowed

If the alert is resolved, this is the date and time when it was resolved.

DateTimeStateModified

datetime

Null values allowed

The date and time when the state of the alert was last modified.

LocalDateAdded_FK

bigint

Not Null

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

LocalDateRaised_FK

bigint

Not Null

The date the alert was raised. This value includes the database server's local date and time offset.

LocalDateTimeAdded

datetime

Not Null

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

LocalDateTimeRaised

datetime

Not Null

The date and time the alert was raised. This value includes the database server's local date and time offset.

LocalDateTimeResolved

datetime

Null values allowed

If the alert is resolved, this is the date and time when it was resolved.

LocalTimeAdded_FK

bigint

Not Null

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

LocalTimeRaised_FK

bigint

Not Null

The time the alert was raised. This value includes the database server's local date and time offset.

ProcessRule_FK

bigint

Not Null

The rule that raised the alert.

RepeatCount

bigint

Null values allowed

For consolidated events, the number of repeat occurrences.

SMC_InstanceID

bigint

Not Null

The surrogate key for this item.

TimeAdded_FK

bigint

Not Null

The time the alert was added to the MOM operations database.

TimeOfFirstEvent_FK

bigint

Not Null

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

TimeOfLastEvent_FK

bigint

Not Null

For consolidated events, the time the latest event was raised.

TimeRaised_FK

bigint

Not Null

The time the alert was raised.

UserResolvedBy_FK

bigint

Not Null

If the alert is resolved, this is the user that resolved it.

See Also

Reference

SCRM 2006 SCRS_AlertLevelDimension_View
SCRM 2006 SCRS_ComputerDimension_View
SCRM 2006 SC_ProcessRuleDimension_View

Other Resources

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