SCCM report for App-v client versions

The following SCCM report will provide Machine Name, User ID, User domain, App –V client name and Client version excluding the language pack.

*************************************************************************

SELECT     sys.Netbios_Name0 AS [Machine Name], sys.User_Name0 AS [User ID], sys.User_Domain0 AS [User Domain], arp.DisplayName0 AS [App Name], arp.Version0 AS [App Version]

FROM v_R_System AS sys INNER JOIN v_Add_Remove_Programs AS arp ON sys.ResourceID = arp.ResourceID

WHERE    

(arp.DisplayName0 = 'Microsoft Application Virtualization Desktop Client') OR

(arp.DisplayName0 = 'Microsoft App-V 5.0 Client UI') OR

(arp.DisplayName0 = 'Microsoft Application Virtualization (App-V) Client 5.0 Service Pack 2') AND

(arp.DisplayName0 NOT LIKE '%Microsoft Application Virtualization Client en-US Language Pack x64%')

****************************************************************************

More SCCM custom reports can be found here