Share via


SCRS_GetOperatingSystemFirst3 Stored Procedure

In SCRM 2006, SCRS_GetOperatingSystemFirst3 gets all installations of three operating system versions.

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

Arguments

@LocaleID

Type: int

Locale identifier for the installed product.

@OSServicePack1

Type: nvarchar

Value for conditioning query against all service pack versions of the operating system versus one specific version available through the name of the product.

@OSVersion1

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSCaption.

@OSServicePack2

Type: nvarchar

Additional value for conditioning query against all service pack versions of the operating system versus one specific version available through the name of the product.

@OSVersion2

Type: nvarchar

Additional value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSCaption.

@OSServicePack3

Type: nvarchar

Additional value for conditioning query against all service versions of the operating system versus one specific version available through the name of the product.

@OSVersion3

Type: nvarchar

Additional value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSCaption.

Return Code

Type: int

Value: Always 0.

Result Sets

Column name Data Type Description

OSCaption

String

Output value from SCRM 2006 SCRS_ManagedNode_Dimension_View.OSCaption.

OSCaptionLabel

String

Output value from SCRM 2006 SCRS_ManagedNode_Dimension_View.OSCaption.

See Also

Other Resources

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