SCRS_GetOfficeandVersion1 Stored Procedure
In SCRM 2006, SCRS_GetOfficeandVersion1 gets the installations of a specific Microsoft Office version.
SCRS_GetOfficeandVersion1 @LocaleID
,@MicrosoftOfficeName
,[ @Version1 = ] '<ALL>'
,[ @MicrosoftOfficeName1 ]= '<ALL>'
Arguments
@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.
Return Code
Type: int
Value: Always 0.
Results Sets
| 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. |
See Also
Other Resources
Sample SCRM Stored Procedures
SCRM 2006 Report Customization
SCRM 2006 SQL Views
SCRM 2006 Stored Procedures