Splunk Search

filter by duplication of records

kunalpatil111
New Member

|tlp|lasttime|reporttime|count|itype|indicator|cc|asn|asn_desc|confidence|description|tags|rdata| provider .... i have the data as above, my aim is to filter data in such way so that i could get only duplicates, for eg: from indicator field i want only duplicates IP address

Tags (1)
0 Karma

niketn
Legend

@kunalpatil111 can you add some sample data? What do you want to output just the IPs that are duplicate in field Indicator?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

gcusello
SplunkTrust
SplunkTrust

HI kunalpatil111
try something like this (to modify for your real needs):

index=my_index
| stats count BY IP
| where count >1

Bye.
Giuseppe

Get Updates on the Splunk Community!

Monitoring Postgres with OpenTelemetry

Behind every business-critical application, you’ll find databases. These behind-the-scenes stores power ...

Mastering Synthetic Browser Testing: Pro Tips to Keep Your Web App Running Smoothly

To start, if you're new to synthetic monitoring, I recommend exploring this synthetic monitoring overview. In ...

Splunk Edge Processor | Popular Use Cases to Get Started with Edge Processor

Splunk Edge Processor offers more efficient, flexible data transformation – helping you reduce noise, control ...