Skip to content

Instantly share code, notes, and snippets.

@jfrantz1-r7

jfrantz1-r7/Firefox

Created October 3, 2018 14:24
Show Gist options
  • Save jfrantz1-r7/83fe1d2347e0c54845c4ea5a409b50c0 to your computer and use it in GitHub Desktop.
Save jfrantz1-r7/83fe1d2347e0c54845c4ea5a409b50c0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Firefox
SELECT da.ip_address, da.host_name, 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
WHERE ds.name like 'Firefox'
@jfrantz1-r7
Copy link
Author 

SELECT da.ip_address, da.host_name, 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
WHERE ds.name like 'Firefox' and ds.version like `62.1.1'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment