SCRS_GetServicePack_SWCompliance Stored Procedure

System Center

In SCRM 2006, SCRS_GetServicePack_SWCompliance gets the list of captions for a given operating system with output used by compliance reporting.


SCRS_GetServicePack_SWCompliance @LocaleID
,@OperatingSystem 

@LocaleID

Type: int

Locale identifier for the installed product.

@OperatingSystem

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSCaption.

Type: int

Value: Always 0.

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.

Show: