How to generate a search for url's accessed by user

[rashi83]

I have many URI's and a user field available and want to count the times URI has been accessed by user.
Like:

URI         user      count
/google.com testuser1 1000
/bing.com   testuser2 2
/bing.com   testuser1 100

[richgalloway · Accepted solution]

That's a job for the stats command. Add stats count by URI, user to your search.