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