SCRS_GetServicePack1 Stored Procedure
System Center
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>'
@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.
| Column name | Data Type | Description |
|---|---|---|
| OSServicePackVersion | String | Output value from SCRM 2006 SCRS_ManagedNode_Dimension_View.OSServicePackVersion. |
Show: