Hi is there anything i can do to de-dup the ips on here using tags, as it very repetitive ips but because there are lots of custom tags with each one, how would i get rid and just keep one of each of the ips?
If i switch “custom” to owner it doesnt give me but a few that i have listed, i need all ips but only one time.
I’m trying to use this to report on Discovered from a new site we have implemented. So inventory report that has any tags associated with them, with first scan and last scan (although not sure what last scan is last time it was scanned maybe? ) ip and host name. This seems to work but triples my findings.
SELECT da.ip_address, da.host_name, da.mac_address,dos.name AS “OS Name”, fad.first_discovered, fad.last_discovered,
FROM fact_asset_discovery fad
JOIN dim_asset da USING (asset_id)
JOIN dim_tag_asset dta USING (asset_id)
LEFT JOIN dim_operating_system dos USING (operating_system_id)
JOIN dim_tag dt USING (tag_id)
WHERE dt.tag_type = ‘CUSTOM’
GROUP BY da.ip_address, da.host_name, da.mac_address,dos.name, fad.first_discovered, fad.last_discovered,