max successfull VPN users per day by monthly.

[riqbal47010]

Initially I have query with successful VPN user logings.(usernames) Now I want to get the max(high) nubmber of users per day per month for 3 months.

so initially how to extract the date and month and then count the users by day by moth.

[richgalloway]

What do you mean by "by day by month"? Are you looking for 90 numbers for the days and 3 other numbers for the last 3 months?
Can you share your current query?