topic Unique number of users in Splunk Search

Unique number of users

rashi83 — Mon, 23 Mar 2020 17:48:36 GMT

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?

whrg — Mon, 23 Mar 2020 17:52:35 GMT

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

gcusello — Mon, 23 Mar 2020 17:52:45 GMT

Hi @rashi83,
Try this:

your_search
| dedup user
| sort user
| table user

Ciao.
Giuseppe