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
Stefany
9 months agoMaricela
10 months agoRessie
8 months agoOna
9 months agoJordan
9 months agoDoretha
10 months agoCathern
10 months agoDoretha
10 months agoRichelle
10 months agoPeter
9 months agoVivan
9 months agoTommy
10 months agoRaymon
10 months agoReena
10 months agoLeah
10 months agoGeraldo
10 months ago