Dear AllI need to generate a report about number of successful OWA login within specific date rage (i.e. who successfully login using OWA starting from 1st of Nov 2009 and 30th Nov 2009).I know it can be done by Logparser but I don't know the exact command.we are running Exchange CAS 2007 on two servers (Load Balance) ON WINDOWS SERVER 2003ANY IDEA IS HIGHLY APPRECIATEDSystems Specialist

Is that what you are looking for http://technet.microsoft.com/en-us/library/bb124415.aspxAlso you can hve a look at http://social.technet.microsoft.com/Forums/en/exchangesvrgeneral/thread/072e3496-6ef7-486d-9787-8816103192e0Raj

This should get you going in the right direction. http://almostdailytech.com/tag/logparser/Mark Morowczynski|MCT| MCSE 2003:Messaging, Security|MCITP:ES, SA,EA|MCTS:Windows Mobile Admin|Security+|http://almostdailytech.com

Dear AllI want to generate a report about number of successful OWA login within specific date rage (i.e. who successfully login using OWA starting from 1st of Nov 2009 and 30th Nov 2009).I know it can be done by Logparser but I don't know the exact command.we are running Exchange CAS 2007 on two servers (Load Balance) ON WINDOWS SERVER 2003. I need to collect the info from the two servers & combine them.ANY IDEA IS HIGHLY APPRECIATED Systems Specialist

HI,Alternatively You can gothird partyreal time scan tool for monitor how many users are conected thru OWA and can pull log further.Please have a look of below Link.how many users connected in realtime?http://www.petri.co.il/forums/showthread.php?t=19075 ExInsight for Microsoft Exchange http://bitrunes.com/ Statistics view of ExInsight http://bitrunes.com/ScreenShots.aspx?p=exinsight&s=exi_ss3Secondly, I would recommed you to enable diagnostic looging on OWA to generate reports As i know you are doing that and only have issue to pull the report, so please belo link for latest tool of log parser.http://www.msexchange.org/ExchangeNews/April-2005-Improved-Log-Parser-Tool.htmlHop these will help you :)Anil

Actually I want to generate the report from the existed logs. I don't need the realtime OWA users. I tried ExInsight but it requires to restart the information store service where this is not possobile on the production server.I need the SQL statement to find the successful login since the beggining of 2009. can anyone help me?Systems Specialist

You can grab the information from IIS logs by searching with Logparser utility but not sure if it can give result in SQL format... Using the Logparser Utility to Analyze Exchange/IIS Logs http://www.msexchange.org/tutorials/Using-Logparser-Utility-Analyze-ExchangeIIS-Logs.htmlAmit Tank MVP: Exchange Server | MCTS: Microsoft Exchange Server 2010, Configuration | MCITP: EMA | MCSA: M Blog: http://ExchangeShare.WordPress.com | User Group: http:/MUC-UG.org.in

what I want to to get the data in any format using logparser or any other utilitySystems Specialist

Hello, Logparser can do the trick. Please refer to the links provided by friends above. The syntax should be like: Logparser "select cs-username from C:\windows\system32\logfiles\w3svc1\ex*.log where cs-uri-stem like '%owa' order by cs-username asc" A related article: http://msexchangeteam.com/archive/2007/09/12/446982.aspx If you have further questions about using Logparser, I suggest you write the post on our Logparser forum: http://forums.iis.net/default.aspx?GroupID=51 Thanks, Elvis

Hi,Any update on the issue?