SCRS_GetMOMFullComputerName_Second_Search Stored Procedure

In SCRM 2006, SCRS_GetMOMFullComputerName_Second_Search gets a list of computer names matching the specified pattern but excluding the specified value, based on the supplied search criteria.

SCRS_GetMOMFullComputerName_Second_Search @LocaleID
,[ @NoALLOption = ] 0
,@SearchStr
,@ComputerName               

Arguments

@LocaleID

Type: int

Locale identifier for the installed product.

@NoALLOption

Type: bit

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

@SearchStr

Type: nvarchar

Pattern match value for conditioning query against SCRS_ManagedNode_Dimension_Latest_View.ComputerFullNTName.

@ComputerName

Type: nvarchar

Value to ignore when querying against SCRM 2006 SCRS_ComputerDimension_View.FullComputerName.

Return Code

Type: int

Value: Always 0.

Result Sets

Column name Data Type Description

ComputerFullNTName

String

Output value from SCRM 2006 SCRS_ComputerDimension_View.FullComputerName.

ComputerFullNTNameLabel

String

Output value from SCRM 2006 SCRS_ComputerDimension_View.FullComputerName.

See Also

Other Resources

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