SCRS_GetApplicationNameVersion3 Stored Procedure

In SCRM 2006, SCRS_GetApplicationNameVersion3 gets the list of versions of an application by using its Add Remove Program display name and excluding three specific members.

SCRS_GetApplicationNameVersion3 @LocaleID
,@ApplicationName
,[ @ApplicationName1 = ]  '<ALL>'
,[ @Version1 = ]  '<ALL>'
,[ @ApplicationName2 = ]  '<ALL>'
,[ @Version2 = ]  '<ALL>'
,[ @ApplicationName3 = ]  '<ALL>'
,[ @Version3 = ]  '<ALL>'

Arguments

@LocaleID

Type: int

Locale identifier for the installed product.

@ApplicationName

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPDisplayName.

@ApplicationName1

Type: nvarchar

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

@Version1

Type: nvarchar

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

@ApplicationName2

Type: nvarchar

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

@Version2

Type: nvarchar

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

@ApplicationName3

Type: nvarchar

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

@Version3

Type: nvarchar

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

Return Code

Type: int

Value: Always 0.

Results Sets

Column name Data Type Description

ARPVersion

String

Output value from SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPVersion.

ARPVersionLabel

String

Output value from SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPVersion.

See Also

Other Resources

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