Splunk Search

How to group results that has 5 or more distinct values in list(repo_name) ?

wailoont
Engager

Hi,

I have a search query as below.

query | stats list(repo_name) by user_login

This returns username with their repository listed grouped by the user_login.

For example :

Name Repository
user_login XXX

How can i enhance the query to only return searches ONLY if the list of repository has 5 or more values ?

Tags (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Perhaps something like this will work for you.

query | stats list(repo_name) as repo_names by user_login | where mvcount(repo_names) > 4
---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Perhaps something like this will work for you.

query | stats list(repo_name) as repo_names by user_login | where mvcount(repo_names) > 4
---
If this reply helps you, Karma would be appreciated.
0 Karma

wailoont
Engager

Many thanks. it works. 🙂

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...