How to get a report for OWA users?

Hi Experts,

I have a farm of servers running Exchange 2003 SP2 and Exchange 2007 SP1. My team leader asked me to get some kind of report or stats of all users using OWA , POP3 and Imap4.

Is there any way to get this report into a csv file or spreadsheet for both scenarios (Exchange2003&2007)

A third party tool is not an option.

Can anyone point me on the right direction?

Thanks
Jerry SeinfieldAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

flyingskyCommented:
If this is SBS, you can get some reports from Windows
http://technet.microsoft.com/en-us/library/cc719952.aspx

If not, you either need third party software for this, (like Quest), or you enable IIS logging and get the information you want from the logs.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Justin OwensITIL Problem ManagerCommented:
IIS logging will help with the OWA report, but it will not help with POP or IMAP queries.  I am not aware of a built in utility to either Exchange 2003 or 2007 that will give you this info.  You could turn on network monitoring and trap all POP and IMAP requests, but that would be a pain to parse in a large environment.  I have always used 3rd party software for this type of request.
0
MesthaCommented:
OWA is easy enough. The standard IIS logs will give you the raw information, then anything IIS log processing tool will process it.
POP3/IMAP - they both having logging capabilities.

However all three will generate a high number of logs and without a tool to process them you will be wading through a lot of log files.

Nothing built in for either version of Exchange to produce any kind of reports - that has been left to third parties.

Simon.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.