Solved

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

Posted on 2014-11-24
5
722 Views
Last Modified: 2014-11-30
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'%'
0
Comment
Question by:cdshreve
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 26

Expert Comment

by:pony10us
ID: 40462492
Have you looked at Microsoft's article?

http://support.microsoft.com/kb/246248
0
 
LVL 16

Expert Comment

by:Rajitha Chimmani
ID: 40462588
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
 

Author Comment

by:cdshreve
ID: 40463010
Unfortunately neither of the suggestions work.  The article was about 5.5 and the sql command still received no results.
0
 

Accepted Solution

by:
cdshreve earned 0 total points
ID: 40464656
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
 

Author Closing Comment

by:cdshreve
ID: 40472353
Actually found the solution elsewhere.
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question