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

[wailoont]

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 ?

[richgalloway · Accepted solution]

Perhaps something like this will work for you.

query | stats list(repo_name) as repo_names by user_login | where mvcount(repo_names) > 4

[wailoont]

Many thanks. it works. 🙂