ExamGecko
Question list
Search
Search

Question 254 - SPLK-1002 discussion

Report
Export

For the following search, which command would further filter for only IP addresses present more than five times?

A.
index=games I stats count as IP_count by IP B. | where IP_count > 5
Answers
A.
index=games I stats count as IP_count by IP B. | where IP_count > 5
B.
index=games | search IP_Count > 5
Answers
B.
index=games | search IP_Count > 5
C.
index=games | where IP > 5
Answers
C.
index=games | where IP > 5
D.
index=games I search IP > 5
Answers
D.
index=games I search IP > 5
Suggested answer: A

Explanation:

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

asked 23/09/2024
Kevin Intriago
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first