Splunk Search

Unique number of users

rashi83
Path Finder

Hi , I am running a query to get count of unique users like
| stats dc(user)

How do I get list of those unique users?

Tags (1)
0 Karma

gcusello
Legend

Hi @rashi83,
Try this:

your_search
| dedup user
| sort user
| table user

Ciao.
Giuseppe

0 Karma

whrg
Motivator

Try this:

| stats values(user)

You can combine it with the distinct count like this

| stats values(user) as users dc(user) as usercount

Alternatively:

| stats count by user
0 Karma
Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...