User with name per most used application

[Gib10920]

I want to run a query on a server to display all users with their names per application. It is about finding out which users need which program most on a particular server. However, I have no idea how I could write such a script. Can someone help me, please!

[alonsocaio]

Hi,

If you want to list which users are using each application, maybe the "| stats values()" can be useful:

...
| stats values(username) by application

Also, if you don't mind, you can share any query you have already tried so I can help you to to include the stats command.