Avatar of pramod1
pramod1
Flag for United States of America asked on

exchange, OWA, scripts

I  am trying to collect users list who connect through owa.

 I have used log parser and running below command, THIS QUESTION RELATES TO ALREADY CLOSED QUESTION WHICH I THOUGHT was correct but have  a question regarding this Script (QUESTION WAS CLOSED ON 3-28-2017)
https://www.experts-exchange.com/questions/29012333/exchange-owa-script.html


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:datagrid

above script runs fine and I see it collects the same info again and again, as I ran today and yesterday , I tried myself connecting through OWA, it didn't pull my name in the list?
ExchangeOutlook

Avatar of undefined
Last Comment
Patrick Bogers

8/22/2022 - Mon
Saber

Do you have more than 1 Exchange server? If so, are you going through a load balancer? Exchange also delays writing to the IIS log files by a minute or 2 depending on server load. The log files are not updated immediately.
pramod1

ASKER
ok

let me check again
pramod1

ASKER
no this script didn't pull my name as I had logged in through owa yesterday, any thing this script is missing
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
pramod1

ASKER
I had logged in yesterday , it is pulling the same records and my cs-username is not showing up in the list that when I logged in through owa yesterday

only the count of OWA HITS changes that for same cs-username by 200 or 300 i.e if cs-username owa hits shows 4718 now it shows 4449 ?
ASKER CERTIFIED SOLUTION
Patrick Bogers

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.