SCRS_GetOfficeandVersion1 Stored Procedure

System Center

In SCRM 2006, SCRS_GetOfficeandVersion1 gets the installations of a specific Microsoft Office version.


SCRS_GetOfficeandVersion1 @LocaleID
,@MicrosoftOfficeName
,[ @Version1 = ] '<ALL>'
,[ @MicrosoftOfficeName1 ]= '<ALL>'

@LocaleID

Type: int

Locale identifier for the installed product.

@MicrosoftOfficeName

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserDisplayName.

@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

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

Type: int

Value: Always 0.

Column name Data Type Description

ARPUserVersion

String

Output value from SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserVersion.

ARPUserVersionLabel

String

Output value from SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserVersion.

Show: