How to find a version number?

bconnor · June 15, 2023, 8:02pm

Hello

Does anyone know a quick way to search for version numbers of different software? I can search to see which assets of ours have particular software, but what I am looking is a quick way to see what version is installed without having to go into each asset individually. Thanks.

john_hartman · June 21, 2023, 2:39pm

This might be a good start. The example is using Firefox but you could switch it out to whatever software you want.

github.com

rapid7/insightvm-sql-queries/blob/master/sql-query-export/Software-Version.sql

-- Detection of Chrome / Firefox per version
-- *Example shows FF but replace with Chrome to check it
-- ** This works for any software listed on the Assets tab under the Software section. You can get the Software Class fields there, or just wildcard it with the %
-- If you want a report on all software, remove the following:
-- WHERE
-- ds.software_class like'Internet Client%'
-- AND ds.name like 'Firefox%'
-- AND ds.version < '67.04'
-- Copy the SQL query below
SELECT
    da.sites AS "Site_Name",
    da.ip_address AS "IP_Address",
    da.mac_address AS "MAC_Address",
    da.host_name AS "DNS_Hostname",
    ds.vendor AS "Vendor",
    ds.name AS "Software_Name",
    ds.family AS "Software_Family",
    ds.version AS "Software_Version",
    ds.software_class AS "Software_Class"
FROM

This file has been truncated. show original

bconnor · August 4, 2023, 5:56pm

Holy cow. I really appreciate it. I feel you might have given me a wee bit too much credit. One more question, can you point me to how I can create a report using the SQL you gave me? I see how I can build already built reports, but not how I can add the SQL in it. Thanks.

jbarry1 · August 6, 2023, 11:16pm

@bconnor

Creating reports based on SQL queries | InsightVM Documentation (rapid7.com)