-- Software list temp tableWITH software_temp AS (SELECT DISTINCT name, MAX(version) AS version, meta_hostnameFROM xdr_dataWHERE query_name = 'windows_programs'Group BYname, meta_hostname)select name AS Software_Title,version,COUNT(version) AS Total_Installsfrom software_temp--Add software name below for testing--WHERE name LIKE '%DC%'GROUP BYname, versionORDER BYname This query will count the installed software by version
-- Software list temp tableWITH software_temp AS (SELECT DISTINCT name, MAX(version) AS version, meta_hostnameFROM xdr_dataWHERE query_name = 'windows_programs'Group BYname, meta_hostname)select name AS Software_Title,version,COUNT(version) AS Total_Installsfrom software_temp--Add software name below for testing--WHERE name LIKE '%DC%'GROUP BYname, versionORDER BYname
This query will count the installed software by version
SOftware name is blank