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

Avatar of undefined
Last Comment
pramod1

8/22/2022 - Mon
Patrick Bogers

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
pramod1

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

ASKER
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
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.
Patrick Bogers

Be ware of the " signs in the command.
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
pramod1

ASKER
I got this , where it is saved
C--Users-ic1pxk-Desktop-Capture.JPG
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
pramod1

ASKER
I don't know where the file is saved
pramod1

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

can I change above
Patrick Bogers

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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
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
Patrick Bogers

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

Here two good articles with examples
pramod1

ASKER
it says invalid parameter "charttype"
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
pramod1

ASKER
ok it is running, attached snapshot
C--Users-ic1pxk-Desktop-Capture.JPG
Patrick Bogers

Patrick Bogers

Yes that is what you want....
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
pramod1

ASKER
it is still running it will pop up or save somewhere
Patrick Bogers

I think both.
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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
pramod1

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