InsightVM - SQL Query - specified softrware, version

I’m trying to figure out a way to get a list of verisons we have for Adobe products. As you know there could be multiple of software for adobe with multiple verisons. Wondering if someone can assist.

I’m stealing a similar answer from another post that helped me in the past (Custom report - List asset with specific software installed - #3 by jay_godbole).

The below query will give you a list of all assets with Adobe software on them, and include the software product and versions for each entry. You could do some Excel magic to group by the different software products, and then grab the distinct versions of each (or you could do it through some extra SQL if you wanted to).

SELECT da.ip_address AS "IP Address", da.host_name AS "Hostname", dos.NAME AS "OS", ds.vendor AS "Software Vendor", AS "Software Family", as "Software Name", ds.version AS "Software Version", date(da.last_assessed_for_vulnerabilities) AS "Last Scan Date"
FROM dim_asset_software das
JOIN dim_software ds using (software_id)
JOIN dim_asset da on da.asset_id = das.asset_id
JOIN dim_operating_system dos USING (operating_system_id)
WHERE ds.vendor ~* 'adobe'
ORDER BY da.ip_address, ds.version, da.last_assessed_for_vulnerabilities DESC

Thank you!!! :slight_smile: