Saturday, August 30, 2014

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
(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

No comments:

Post a Comment