Hello, I have an indexed list of internal IPs that I have been able to get a count for based on a CIDR list on a CSV Lookup table: sourcetype="rapid7:insightvm:asset" "tags{}.name"="*" index=rapid7 | dedup id | fields ip | lookup GracoSubnet2.csv CIDR_range as ip OUTPUT CIDR_range as CIDR Latitude Longitude | where CIDR != "NONE" | stats count, values(ip), as Unique_IP by CIDR This gives me a great table with a count based on how many Unique internal IPs fall under one CIDR range. I have been unable to figure out how to take that count and reference the Lat and Lon data for those CIDRs that are in the CSV Lookup table. Any Ideas?
... View more