Link to home
Start Free TrialLog in
Avatar of pramod1
pramod1Flag for United States of America

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
Avatar of Patrick Bogers
Patrick Bogers
Flag of Netherlands image

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
Avatar of pramod1

ASKER

I didn't get you, iam copying everything and pasting on command line, should I use exchange management shell
ASKER CERTIFIED SOLUTION
Avatar of Patrick Bogers
Patrick Bogers
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Be ware of the " signs in the command.
Avatar of pramod1

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
Avatar of pramod1

ASKER

I got this , where it is saved
C--Users-ic1pxk-Desktop-Capture.JPG
Avatar of pramod1

ASKER

I don't know where the file is saved
Avatar of pramod1

ASKER

charttype:Bar3D -o:CHART -view:ON

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
Avatar of pramod1

ASKER

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
No -charttype:bar3d can be deleted, not sure what view:on does

Here two good articles with examples
Avatar of pramod1

ASKER

it says invalid parameter "charttype"
Avatar of pramod1

ASKER

ok it is running, attached snapshot
C--Users-ic1pxk-Desktop-Capture.JPG
Yes that is what you want....
Avatar of pramod1

ASKER

it is still running it will pop up or save somewhere
I think both.
Avatar of pramod1

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
Avatar of pramod1

ASKER

owa hits -what does this mean
C--Users-ic1pxk-Desktop-Capture5.JPG