Statistics of how users are connected to Exchange 2010 - Using OWA and Outlook
Hi One & All...........
I want to find out the how users ( Using OWA or Outlook) connected to exchange 2010....
Get-LogonStatistics -Server Server01 ---> returns logon statistics for all users connected( Live users) to the server Server01
but here my concern is find out statistics for Date Range i.e. like , in this month how many users connected using OWA and how many connected using Outlook
Plz somebody help me
July 23rd, 2012 2:21pm
Hi,
Logparser:
http://blogs.technet.com/b/exchange/archive/2007/09/12/3403903.aspxRegards from www.windowsadmin.info | www.blog.windowsadmin.info
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 2:22pm
Hi,
Logparser:
http://blogs.technet.com/b/exchange/archive/2007/09/12/3403903.aspxRegards from www.windowsadmin.info | www.blog.windowsadmin.info
July 23rd, 2012 2:27pm
You need to capture historical data first. You can use the script below which will take daily records and run queries.
Sanitizing Get-LogonStatistics cmdlet data to view better Logon stats in Exchange 2007
http://gsexdev.blogspot.com/2009/03/sanitizing-get-logonstatistics-cmdlet.html#!/2009/03/sanitizing-get-logonstatistics-cmdlet.htmlJames Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 2:34pm
Hi,
You can find the output when you run get-logonstatistics from the article below:
View Logon Statistics
http://technet.microsoft.com/en-us/library/ff653211.aspx
Besides, you can use logparser to analyze it
C:\Program Files (x86)\Log Parser 2.2\logparser.exe" "SELECT TOP 10 cs-username, Count(*) AS OWAHits INTO OWAActivity.gif FROM C:\Inetpub\logs\LogFiles\W3SVC1\u_ex*.log WHERE cs-uri-stem LIKE '/OWA/' AND cs-username IS NOT NULL GROUP BY cs-username ORDER BY
OWAHits DESC" -charttype:Bar3D -o:CHART -view:ON
Or:
"C:\Program Files (x86)\Log Parser 2.2\logparser.exe" "SELECT TO_STRING(time, 'HH') AS Hour, COUNT(*) AS Hits INTO hitPerSecond.jpg FROM C:\Inetpub\logs\LogFiles\W3SVC1\u_ex*.logGROUP BY Hour ORDER BY Hour ASC" -i:IISW3C -o:CHART -chartType:ColumnClustered
-chartTitle:"Hourly Hits" -groupSize:420x280
Besides, we can run the command below to get the current number of outlook or OWA user who is connecting to Exchange Servers.
Get-Counter "\MSExchange RpcClientAccess\User Count" -ComputerName name|ft
Get-Counter "\MSExchange OWA\Current Unique Users" -ComputerName name |ft
Xiu Zhang
TechNet Community Support
July 25th, 2012 3:01am