SCRS_GetAlertNameByAlertSeverity Stored Procedure

  • Article

In SCRM 2006, SCRS_GetAlertNameByAlertSeverity gets the list of MOM alerts.

SCRS_GetAlertNameByAlertSeverity @LocaleID,
[ @NoALLOption = ] 0,
[ @AlertSeverity = ] 0

Arguments

@LocaleID

Type: int

Locale identifier for the installed product.

@NoALLOption

Type: bit

Determines whether output includes <ALL>; 1 excludes it, 0 includes it.

@AlertSeverity

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_AlertLevelDimension_View.AlertLevelName.

Return Code

Type: int

Value: Always 0.

Results Sets

Column name Data Type Description

AlertName

String

Output value from SCRM 2006 SCRS_AlertFact_View.AlertName.

AlertNameLabel

String

Output value from SCRM 2006 SCRS_AlertFact_View.AlertName.

See Also

Other Resources

Sample SCRM Stored Procedures
SCRM 2006 Report Customization
SCRM 2006 SQL Views
SCRM 2006 Stored Procedures