Splunk Search

Count uniqe values over a certain period of time

Norling80
Path Finder

Hi

I´m trying to create a search that basically count the number of unique UserId generated over a certain time in the userlog, the UserId consist of 5 digits for example 12345 or 79365 etc.. need help to finalize it.

The search begins like this...
index=main sourcetype=userlog UserId="*" | ...?

regards
Magnus

Tags (1)
0 Karma
1 Solution

aweitzman
Motivator

| stats dc(UserId) should do the trick for you.

View solution in original post

Norling80
Path Finder

Thanks a lot, that worked.
/Magnus

0 Karma

aweitzman
Motivator

| stats dc(UserId) should do the trick for you.

Get Updates on the Splunk Community!

Alerting Best Practices: How to Create Good Detectors

At their best, detectors and the alerts they trigger notify teams when applications aren’t performing as ...

Discover Powerful New Features in Splunk Cloud Platform: Enhanced Analytics, ...

Hey Splunky people! We are excited to share the latest updates in Splunk Cloud Platform 9.3.2408. In this ...

Splunk Classroom Chronicles: Training Tales and Testimonials

Welcome to the "Splunk Classroom Chronicles" series, created to help curious, career-minded learners get ...