SCRS_GetServicePack1 Stored Procedure
In SCRM 2006, SCRS_GetServicePack1 gets a list of operating system captions matching the pattern of a specific version.
SCRS_GetServicePack1 @LocaleID
,@OperatingSystem
,[ @OSVersion1 = ] '<ALL>'
,[ @OSServicePack1 = ] '<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.
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. |
See Also
Other Resources
Sample SCRM Stored Procedures
SCRM 2006 Report Customization
SCRM 2006 SQL Views
SCRM 2006 Stored Procedures