Skip to content

Instantly share code, notes, and snippets.

@jfrantz1-r7

jfrantz1-r7/duplicate assets

Created December 6, 2018 15:19
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save jfrantz1-r7/b07d05513f62936f041e28c3ebca620d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
duplicate assets
SELECT
da.host_name, da.ip_address, COUNT(*)
FROM
dim_asset da
GROUP BY
da.host_name, da.ip_address
HAVING
COUNT(*) > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment