We need to generate a report with a list of unique IPs featuring on all
logs for a given time period. Have tried using Chart builder, this is
the query for unique IPs and destination ports grouped by IP Address
select `srcip`, string_agg(distinct (`d...
why do you have the requirement to extract unique IPs?-to identify the
hosts on the network that are involved in the matter being worked upon.
Say, we are looking for hosts who've visited a given website, unique IPs
generating traffic to the website ...
what is the purpose of this report?Very often there is a requirement to
extract unique IPs between a given time period. Say, from midnight to 3
am for instance. This may be filtered down further based on other
parameters like say a destination IP or ...
thanks for the reply. how do i go about getting the first and last seen
times? Also, hope the query in the initial post on this thread is
accurate. The requirement is to extract a list of unique IP addresses
for a given period of time as a report.
