The sum of users per VLAN

[Redha]

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

[richgalloway · Accepted solution]

Have you tried the stats command?

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

[Redha]

Thank you richgalloway  ! it's works