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:
The error on log parser 2.2 is this:
Error: Syntax Error: 'AS' not followed by <alias> (\[Date\],)
The SQL is following:
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\]
WHERE cs-method LIKE 'GET' AND cs-uri-stem LIKE '/exchange'
AND cs-username LIKE'%'