Need help in capturing an hourly request count specific to login sessions only.
I found a command set online while doing some searches. The command returns an hourly count of requests found in the access.log.
grep "23/Jan" progolfdeal.com | cut -d[ -f2 | cut -d] -f1 | awk -F: '{print $2":00"}' | sort -n | uniq -c
I was trying to obtain an hourly request count however it returns all type of requests and the count returned is not matching a specific login count that I'm trying to obtain.
Please help with a query that can include the as well the login count specific to the URL found the access.log. I will see entries in the log pertaining to the website in the following format \mysite\logon.jsp 200 xxxx & that is what I'm trying to count as well.
Thank you.