pramod1
asked on
exchange, owa, script
I am trying to collect users list who connect through owa.
I have used log parser and running below command
attached please find the error which I am getting
I a running the script on exchange 2007.
C--Users-ic1pxk-Desktop-official-EXC.txt
C--Users-ic1pxk-Desktop-official-EXC.JPG
I have used log parser and running below command
attached please find the error which I am getting
I a running the script on exchange 2007.
C--Users-ic1pxk-Desktop-official-EXC.txt
C--Users-ic1pxk-Desktop-official-EXC.JPG
ASKER
I didn't get you, iam copying everything and pasting on command line, should I use exchange management shell
ASKER
error received
C--Users-ic1pxk-Desktop-Capture.JPG
C--Users-ic1pxk-Desktop-Capture.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Be ware of the " signs in the command.
ASKER
it finally ran but came with error I am running on my cas server can I change something in command so it comes with different output
C--Users-ic1pxk-Desktop-Capture.JPG
C--Users-ic1pxk-Desktop-Capture.JPG
ASKER
I got this , where it is saved
C--Users-ic1pxk-Desktop-Capture.JPG
C--Users-ic1pxk-Desktop-Capture.JPG
ASKER
I don't know where the file is saved
ASKER
charttype:Bar3D -o:CHART -view:ON
can I change above
can I change above
Yes, you can skip it and replace by e.g.
-o:datagrid
This should pop-up logparser GUI with a kind of excel look overview
-o:datagrid
This should pop-up logparser GUI with a kind of excel look overview
ASKER
logparser.exe "SELECT TOP 10 cs-username, Count(*) AS OWAHits INTO OWAActivity.gif FROM C:\Inetpub\logs\LogFiles\W 3SVC1\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 -view:ON
is this correct
is this correct
No -charttype:bar3d can be deleted, not sure what view:on does
Here two good articles with examples
Here two good articles with examples
ASKER
it says invalid parameter "charttype"
ASKER
ok it is running, attached snapshot
C--Users-ic1pxk-Desktop-Capture.JPG
C--Users-ic1pxk-Desktop-Capture.JPG
Here two good articles with examples
https://www.simple-talk.com/blogs/using-logparser-part-2/
Https://mlichtenberg.wordpress.com/2011/02/03/log-parser-rocks-more-than-50-examples/
https://www.simple-talk.com/blogs/using-logparser-part-2/
Https://mlichtenberg.wordpress.com/2011/02/03/log-parser-rocks-more-than-50-examples/
Yes that is what you want....
ASKER
it is still running it will pop up or save somewhere
I think both.
ASKER
GOT IT CLEAR sir, but against user name owahits is written with numbers
against user name -5854
4449
4155
what does 0wa hits mean
thank you for help
against user name -5854
4449
4155
what does 0wa hits mean
thank you for help
ASKER
owa hits -what does this mean
C--Users-ic1pxk-Desktop-Capture5.JPG
C--Users-ic1pxk-Desktop-Capture5.JPG
In the txt file the command starts with logparser.exe which looks ok.
In command line you start with the sql query which does not look ok.
Copy paste from txt to command line and Please try again.
Cheers