Wednesday, April 15, 2015

SCCM report for installed versions of Google Earth

The following report will provide all installed versions of Google Earth along with the version number, user name and machine name
*******************************************************************************
SELECT DISTINCT sys.Netbios_Name0 AS [Machine Name], sys.User_Name0 AS [User Name],
    arp.DisplayName0 AS [Google Earth version]
FROM       v_R_System AS sys
INNER JOIN v_Add_Remove_Programs AS arp ON sys.ResourceID = arp.ResourceID
WHERE      (arp.DisplayName0 LIKE '%Google Earth%')

*******************************************************************************
More SCCM custom reports can be found here

No comments:

Post a Comment