@AjayKumar No I didn't use any query. I just exported the logs into Excel and used Pivot Table. Then used Event and Event Context to drill down on activities.
P.S. The exported log file was in 100s of MB and took several minutes to get exported, so beware to do it on live production site.
P.S. The exported log file was in 100s of MB and took several minutes to get exported, so beware to do it on live production site.