Solved: The sum of users per VLAN - Splunk Community

Splunk Enterprise

Hi,

I am looking to have the sum of users per vlan, for example vlan=xxx is used by username=A, B, C so I would have a table with VLAN = xxx and sum of users = 3,

Thx

1 Solution

Solution

Have you tried the stats command?

...
| stats distinct_count(username) as users by VLAN
...

---
If this reply helps you, Karma would be appreciated.

View solution in original post

Solution

Have you tried the stats command?

...
| stats distinct_count(username) as users by VLAN
...

---
If this reply helps you, Karma would be appreciated.

Thank you richgalloway ! it's works

Get Updates on the Splunk Community!

What's New in Splunk Observability - November 2025

Feature Highlight Analyze your dimensions and metrics with Usage Analytics To help optimize telemetry data ...

Splunk Enterprise Security(ES) 7.3 is approaching the end of support. Get ready for ...

Hi friends! At Splunk, your product success is our top priority. With Enterprise Security (ES), we're here ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk, and empower your SOC to reach new heights! Duration: 1 hour Prepare to ...