This is a very basic question. I have a set of data that gives me a list of groups and the names of each user in each group. instead of having the names per group I would like to have a number that represents the number of people in a group.
Eg. My table shows ID|GroupName
Under "ID" are users listed by their names EX. USER1, USER2,USER3,USER4 -- They all are a part of WindowsGRoup
I would like for it appear as ID=4 GroupName=WindowsGroup.... So when looking at the table you can see 4 users are apart of the Windows Group.
(I hope i explained that fine)
Take your existing search and add to it this:
... | stats dc(ID) AS IDcount values(ID) AS ID BY GroupName
thank you so much!!!!!
If that solved it, be sure to come back and click Accept
to close the question (and UpVote
any other useful comments/answers).
@darrenaefc Come back and close the question!