Sql-Query

OpenSSL Report from Sccm Database [Sql Query]

SELECT DISTINCT sys.Netbios_Name0 AS [Machine Name], sys.User_Name0 AS [User Name],arp.DisplayName0 AS [Specific Software]

FROM      v_R_System AS sys

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

WHERE      (arp.DisplayName0 LIKE '%OpenSSL%')

order by arp.DisplayName0