Skip to content

Instantly share code, notes, and snippets.

@jfrantz1-r7

jfrantz1-r7/check-for-npm

Created November 27, 2018 14:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jfrantz1-r7/97df8e691a2971a6455df0d07c38241c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jfrantz1-r7/97df8e691a2971a6455df0d07c38241c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
check-for-npm
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'%event-stream%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment