SCRS_GetOffice3 Stored Procedure

In SCRM 2006, SCRS_GetOffice3 gets the Microsoft Office installations that match one of three versions.

SCRS_GetOffice3 @LocaleID
,[ @Version1 = ]  '<ALL>'
,[ @MicrosoftOfficeName1 = ]  '<ALL>'
,[ @Version2 = ]  '<ALL>'
,[ @MicrosoftOfficeName2 = ]  '<ALL>'
,[ @Version3 = ]  '<ALL>'
,[ @MicrosoftOfficeName3 = ]  '<ALL>'

Arguments

@LocaleID

Type: int

Locale identifier for the installed product.

@Version1

Type: nvarchar

Value for conditioning query against all versions of an Office product versus only one specific version available through the name of the product.

@MicrosoftOfficeName1

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserDisplayName.

@Version2

Type: nvarchar

Additional value for conditioning query against all versions of an Office product versus only one specific version available through the name of the product.

@MicrosoftOfficeName2

Type: nvarchar

Additional value for conditioning query against SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserDisplayName.

@Version3

Type: nvarchar

Additional value for conditioning query against all versions of an Office product versus only one specific version available through the name of the product.

@MicrosoftOfficeName3

Type: nvarchar

Additional value for conditioning query against SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserDisplayName.

Return Code

Type: int

Value: Always 0.

Results Sets

Column name	Data Type	Description
ARPUserDisplayName	String	Output value from SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserDisplayName.
ARPUserDisplayNameLabel	String	Output value from SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserDisplayName.

See Also

Other Resources

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