We help IT Professionals succeed at work.

exchange, owa, script

pramod1
pramod1 asked
on
206 Views
Last Modified: 2018-02-06
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
Comment
Watch Question

Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
Hi

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

Author

Commented:
I didn't get you, iam copying everything and pasting on command line, should I use exchange management shell

Author

Commented:
Datacenter platform engineer Lindows
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
Be ware of the " signs in the command.

Author

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

Author

Commented:
I got this , where it is saved
C--Users-ic1pxk-Desktop-Capture.JPG

Author

Commented:
I don't know where the file is saved

Author

Commented:
charttype:Bar3D -o:CHART -view:ON

can I change above
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

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

Author

Commented:
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 -view:ON

is this correct
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
No -charttype:bar3d can be deleted, not sure what view:on does

Here two good articles with examples

Author

Commented:
it says invalid parameter "charttype"

Author

Commented:
ok it is running, attached snapshot
C--Users-ic1pxk-Desktop-Capture.JPG
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
Yes that is what you want....

Author

Commented:
it is still running it will pop up or save somewhere
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
I think both.

Author

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

Author

Commented:
owa hits -what does this mean
C--Users-ic1pxk-Desktop-Capture5.JPG
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.