How can I see a list of all users who access Exchange via the Outlook Web Access (OWA)?

How can I see a list of all users who access Exchange via the Outlook Web Access (OWA)?

I need to see who accessed OWA/ActiveSync in the last 90 days.

I have tried this article, but the sql seems to be giving me some issues:
http://windowsitpro.com/windows/q-how-can-i-see-list-all-users-who-access-exchange-outlook-web-access-owa

The error on log parser 2.2 is this:
Error: Syntax Error: 'AS' not followed by <alias> (\[Date\],)


The SQL is following:
Select

 date as \[Date\],
 time as \[Time\],
 s-ip as \[Server IP\],
 cs-username as \[UserName\],
 c-ip as \[Client-IP\],
 cs-method as \[Request Verb\],
 cs-uri-stem as \[Request URI\]

 FROM C:\inetpub\logs\LogFiles\W3SVC1\*.log

 WHERE cs-method LIKE 'GET' AND cs-uri-stem LIKE '/exchange'
 AND cs-username LIKE'%'
cdshreveAsked:
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.

Steven CarnahanNetwork ManagerCommented:
Have you looked at Microsoft's article?

http://support.microsoft.com/kb/246248
0
Rajitha ChimmaniCommented:
Try this and see.

Select

*

 FROM C:\inetpub\logs\LogFiles\W3SVC1\*.log

 WHERE cs-method LIKE 'GET' AND cs-uri-stem LIKE '/exchange'
 AND cs-username LIKE '%'
0
cdshreveAuthor Commented:
Unfortunately neither of the suggestions work.  The article was about 5.5 and the sql command still received no results.
0
cdshreveAuthor Commented:
Actually found this and it works!
then I use Powershell to sort and de-dup


http://myriadofthings.com/outlook-web-access-owa-and-activesync-reporting-using-iis-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
cdshreveAuthor Commented:
Actually found the solution elsewhere.
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
Exchange

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.