I am looking at a log of users logging into machines. The two fields I am interested in are: Username and Machine name.
What I am trying to get my report to look like is a list of usernames, with machine names and a count of the records per machine.
Hoping for something like this...
Bob Smith:
Machine 1 - 16 times
Machine 2 - 2 times
Machine 3 - 6 times
Sam Jones:
Machine1 - 3 times
Machine2 - 1 time
etc....
Right now I have stats count by Username, MachineName | sort - count
And I am lost at this point as to how to change the query to format the way I need it..
Thanks for your help!
... View more