For the following search, which command would further filter for only IP addresses present more than five times?
To filter for only IP addresses that appear more than five times in the search results for index=games, you can use a combination of the stats and where commands. The stats command counts the occurrences of each IP address and assigns the count to IP_count. The where command then filters the results to include only those IP addresses with a count greater than five.
Here is how the complete search would look:
index=games | stats count as IP_count by IP | where IP_count > 5
Splunk Docs: stats command
Splunk Docs: where command
Splunk Answers: Filtering results using stats and where commands
Serina
4 days agoCordell
6 days agoDomitila
7 days agoFrancine
9 days agoDaryl
22 days agoKirk
25 days agoKaycee
27 days agoReta
30 days agoGolda
2 days agoColton
4 days agoKandis
1 months agoGianna
2 days agoArdella
3 days agoCordelia
11 days ago