Skip to content

Instantly share code, notes, and snippets.

@jfrantz1-r7

jfrantz1-r7/gist:055ed4e3aeacc0e5d2a68e64eccd7812

Created October 7, 2019 17:10
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jfrantz1-r7/055ed4e3aeacc0e5d2a68e64eccd7812 to your computer and use it in GitHub Desktop.
Save jfrantz1-r7/055ed4e3aeacc0e5d2a68e64eccd7812 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT count(da.asset_id) as asset_count, ds.vendor, ds.name as software_name, ds.family, ds.version
FROM dim_asset_software das
JOIN dim_software ds using (software_id)
JOIN dim_asset da on da.asset_id = das.asset_id
GROUP BY ds.vendor, ds.name, ds.family, ds.version, ds.cpe
ORDER BY asset_count DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment