New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Splunk Exam SPLK-1002 Topic 6 Question 103 Discussion

Actual exam question for Splunk's SPLK-1002 exam
Question #: 103
Topic #: 6
[All SPLK-1002 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: A

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

Contribute your Thoughts:

Serina
4 days ago
It's like a game of 'Where's Waldo' but with IP addresses instead of a guy in a red-and-white striped shirt. I wonder if there's a 'Where's Waldo' game for network admins?
upvoted 0 times
...
Cordell
6 days ago
Ah, the age-old question of IP address filtering. I'm just glad I don't have to deal with that in my day-to-day work. I'll stick to counting sheep instead of IP addresses!
upvoted 0 times
...
Domitila
7 days ago
D is also not correct. 'search IP > 5' would return all IP addresses greater than 5, not just the ones that appear more than 5 times.
upvoted 0 times
...
Francine
9 days ago
C is definitely the wrong answer. 'where IP > 5' doesn't make any sense, since that would just filter for IP addresses greater than 5, which isn't the requirement.
upvoted 0 times
...
Daryl
22 days ago
I'm not sure, but I think B) index=games | search IP_Count > 5 could also work to filter for IP addresses present more than five times.
upvoted 0 times
...
Kirk
25 days ago
I agree with Kaycee, because using stats count will help us filter for IP addresses present more than five times.
upvoted 0 times
...
Kaycee
27 days ago
I think the answer is A) index=games I stats count as IP_count by IP B. | where IP_count > 5
upvoted 0 times
...
Reta
30 days ago
I think B is the way to go. Directly filtering on the IP_Count field seems simpler and more straightforward.
upvoted 0 times
Golda
2 days ago
User2: Yeah, I agree. B is the correct command to further filter for IP addresses present more than five times.
upvoted 0 times
...
Colton
4 days ago
User1: I think B is the way to go. Directly filtering on the IP_Count field seems simpler and more straightforward.
upvoted 0 times
...
...
Kandis
1 months ago
Option A looks like the right choice to me. The 'stats' command can be used to count the number of unique IP addresses, and then the 'where' clause filters for those with a count greater than 5.
upvoted 0 times
Gianna
2 days ago
I'm not sure, but option A does seem to make sense. It's always good to use the 'stats' command for counting.
upvoted 0 times
...
Ardella
3 days ago
Yes, I agree. Option A is the best choice for filtering IP addresses that appear more than five times.
upvoted 0 times
...
Cordelia
11 days ago
I think option A is correct. It uses the 'stats' command to count IP addresses and then filters for those with more than 5 occurrences.
upvoted 0 times
...
...

Save Cancel