You can download the script, which has been attached to this blog post.
The Exchange support team relatively frequently receives cases where mobile devices using Exchange ActiveSync (EAS) protocol ...
Updated Apr 27, 2020
Version 3.0
Blog Post
I'm getting an error when running the script that cs-uri-query is an unknown field. I've tried it with and without the -disablecloumndetect switch, it doesn't help.
[PS] F:Program FilesMicrosoftExchange ServerScriptsCustom Scripts>.ActiveSyncReport.ps1 -IIS
Log "\<servername>e$logfilesW3SVC1" -LogparserExec "C:Program FilesLog Parser 2.2LogParser.exe"
-ActiveSyncOutputFolder F:_SourceCAS -MinimunHits 1000 -disablecolumndetect "cs-uri-query"
Building Log Parser Query...
Gathering Statistical data
Running Log Parser Command against the IIS Log(s): \<servername>e$logfilesW3SVC1*.log
Error: SELECT clause: Syntax Error: unknown field 'cs-uri-query'
To see valid fields for the W3C input format type:
LogParser -h -i:W3C
LogParser Command finished CSV, File location: C:TempEASyncOutputReport-cs-uri-query_.csv