SCRS_GetServicePack3 Stored Procedure

In SCRM 2006, SCRS_GetServicePack3 gets list of operating system captions matching the pattern of three specific versions.

SCRS_GetServicePack3 @LocaleID
,@OperatingSystem
,[ @OSVersion1 = ] '<ALL>'
,[ @OSServicePack1]= '<ALL>'
,[ @OSVersion2 = ] '<ALL>'
,[ @OSServicePack2 ]= '<ALL>'
,[ @OSVersion3 = ] '<ALL>'
,[ @OSServicePack3]= '<ALL>'

Arguments

@LocaleID

Type: int

Locale identifier for the installed product.

@OperatingSystem

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSCaption.

@OSVersion1

Type: nvarchar

Value for flag determining whether output should exclude value provided by @OSServicePack1.

@OSServicePack1

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSServicePackVersion.

@OSVersion2

Type: nvarchar

Value for flag determining whether output should exclude value provided by @OSServicePack2.

@OSServicePack2

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSServicePackVersion.

@OSVersion3

Type: nvarchar

Value for flag determining whether output should exclude value provided by @OSServicePack3.

@OSServicePack3

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSServicePackVersion.

Return Code

Type: int

Value: Always 0.

Result Sets

Column name	Data Type	Description
OSServicePackVersion	String	Output value from SCRM 2006 SCRS_ManagedNode_Dimension_View.OSServicePackVersion.
OSServicePackVersionLabel	String	Output value from SCRM 2006 SCRS_ManagedNode_Dimension_View.OSServicePackVersion.

See Also

Other Resources

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