Search results matching tag 'CHART output target'

Charting with LogParser and OWC

circle.hk — Thu, 28 Feb 2008 10:37:51 GMT

Hi all,

I know that LogParser uses the MS Office Web Component (OWC) to create chart images. Does anybody know which version is it using exactly? Or does it vary on different computers, depends on version installed? If it does, it may be interesting for LP to have different charting capability on different computers.

Besides, I found a list of available chart types for excel 2003 from here, are they equivalent to those available in OWC? If they are, can they be used in LP too? I noticed that the list contains some extra ones compared to that returned by the -h -o:CHART switch of LP. This seems to require more knowledge in the internal design of LP, maybe only the author knows the answer, but I would really appreciate anyone who can tell me more about it.

Thanks,

circle

using vbs config script with logparser

nigeldude — Tue, 06 Nov 2007 23:49:54 GMT

a year or so ago I found 2 good word documents I believe written by Igor on manipulating the charts with some advanced techniques. I am trying to find those documents but all the links I find on the site go to logparser.com and are not valid. Mainly I recall they had ways to adjust the colors of certain parts of the bar charts, for example if processor was over 70, then the portion above the 70 would be yellow or red, and below 70 would be say green. The documents were great but I can no longer locate them on here and would like to review them again.

Some of the examples were something similar to this, below I am dynamically building the config before running the chart.

echo chart.Title.Font.Size=16 >> chart_config.vbs
echo chart.Title.Font.Name="Trebuchet MS" >> chart_config.vbs
echo chart.GapDepth = 30 >> chart_config.vbs
echo chart.GapWidth = 30 >> chart_config.vbs
echo chart.ChartDepth = 75 >> chart_config.vbs
echo chart.Rotation = %therotation% >> chart_config.vbs
echo chart.Inclination = %theincline% >> chart_config.vbs
echo chart.LightNormal = 0.8 >> chart_config.vbs
echo chart.AmbientLightIntensity = 0.7 >> chart_config.vbs
echo chart.DirectionalLightRotation = picnum >> chart_config.vbs

Thanks for the help,

Nigel

Re: Problem with graphing statement

vji6697 — Wed, 17 Oct 2007 06:34:34 GMT

Sorry about the original post, I tried to re-edit but couldnt save the changes. Hope this is clearer

Hi,

Im new to logparser and my SQL is gained by reading the logparser help file, so please go easy :)

I have a huge CSV file that I have managed to split into unique CSVs using a SELECT DISTICT statement, however I am having great trouble trying to graph the output.

The source file looks like this (the real file is over 1000000 lines long)

Application,Time,Alert

Fred,15/10/2007 12:00,234

Fred,15/10/2007 13:00,42

Fred,15/10/2007 14:00,4354

Fred,15/10/2007 15:00,3453

Fred,15/10/2007 16:00,654

Fred,15/10/2007 17:00,756

Dave,15/10/2007 13:00,234

Dave,15/10/2007 14:00,764

Dave,15/10/2007 15:00,876

Dave,15/10/2007 16:00,353

Dave,15/10/2007 17:00,645>

I use the statement...

logparser "SELECT DISTINCT Application, * INTO *.csv FROM test.txt"" -i:CSV -o:CSV

This will give me a separate csv for Fred and for Dave. I now want to plot, via a scattergraph the Alerts over Time for each Application.

This is where I am getting stuck.

I tried...

logparser "SELECT DISTINCT Application, * INTO *.csv FROM test.txt group by time order by alert" -i:CSV -o:Chart -chartType:ScatterMarkers

but i got

Error: Semantic Error: SELECT clause field-expression "Application" is not an aggregate function and does not contain GROUP BY field-expressions

Im a bit stuck as I cant understand what the error is telling me so am now stuck.

Any help ?

RE: Empty samples not showing

LogParser User : DEinspanjer — Wed, 20 Jun 2007 12:57:00 GMT

I believe someone else posted a solution to this a while back. Do some searching here on the forums for chart and grouping.

Empty samples not showing

LogParser User : ClasG — Wed, 20 Jun 2007 06:56:00 GMT

I'm using LogParser to make beautiful graphs. Typically using our database logs and statistic files as input, showing how many times a certain event has happened each hour over a day.

There are however hours when no activity has taken place and i can't get theese to show in the graph. If I output to a the default table format or a DATAGRID I can see the empty hours.

This is the SQL question I use:

SELECT

QUANTIZE(EventStart,3600) AS Time,

SUM(CASE Action when 'Login' THEN 1 ELSE 0 END) As Login,

SUM(CASE Action when 'Search' THEN 1 ELSE 0 END) As Search,

SUM(CASE Action when 'Query' THEN 1 ELSE 0 END) As Query,

SUM(CASE Action when 'Raise' THEN 1 ELSE 0 END) As Raise

into stat.gif

from 'c:\statistics\Actions_070610.log'

where User<>'' AND SUBSTR(User,0,3)<>'WWW'

group by Time

This results in a nice graph from the time the actions start until they end, but the hours prior and after, and more importent, any empty hours in the middle of the sample just aren't displayed.

Can any one help me on what to do to see the empty samples?

Thanks in advance,

Clas

RE: When reading from CSV, chart is actually charting data instead of placing on x or y axis.

LogParser User : nigeldude — Thu, 19 Apr 2007 22:16:00 GMT

Jeff,

Thank you very much for the assistance. You are correct.

Here is the final Resolution:

logparser "Select TO_STRING(Hour) AS theHour, count(*) as distinctuser INTO Unique_HITS_PER_HOUR_03_TESTING.gif from nigel.log group by theHour" -q -i:csv -o:CHART -values:off -chartType:BAR3d -chartTitle:"TESTING Unqiue Hits By Hour" -groupSize:600x480 -view

This ends up making the desired graph!

The help is much appreciated.

-Nigel

RE: When reading from CSV, chart is actually charting data instead of placing on x or y axis.

LogParser User : Jeff — Thu, 19 Apr 2007 16:04:00 GMT

I think to_string() is what you need to do. Logparser likes to graph numbers so forcing it to not be a number should fix your problems (assuming I read it all correctly).

RE: When reading from CSV, chart is actually charting data instead of placing on x or y axis.

LogParser User : nigeldude — Wed, 18 Apr 2007 20:49:00 GMT

Sample graphs included.

-Nigel

When reading from CSV, chart is actually charting data instead of placing on x or y axis.

LogParser User : nigeldude — Wed, 18 Apr 2007 20:47:00 GMT

Problem:

When selecting via the input format CSV, it charts differently than reading from the

IISW3C. The subsequent graphs do not come out as expected.

1) This works fine and creates a wonderful graph:

query 1:
logparser "SELECT TO_STRING (TO_localtime( to_timestamp ( date, time) ), 'HH' ) AS Hour,

COUNT(*) AS Hits INTO %filename%HITS_PER_HOUR_03_Working.gif FROM %_inputfile% where cs-

uri-stem like '%webpage%'GROUP BY Hour ORDER BY Hour ASC" -i:IISW3C -o:CHART -values:off

-chartType:%1 -chartTitle:"Hits Per Hour Working" -groupSize:620x460

In above case the input file is the IISLOG. It ends up creating a superb graph utilizing

either line or bar3d as the chartType, and places the hour either along the X or Y Axis,

(depending on graph type) which is great.

2)
Unfortunately, I want to capture the distinct c-ips per our, so I run this, and throw it

into a file for later reading, since we cannot utilize distinct with group by.

rem grab distinct IP's per hour
logparser "Select TO_STRING (TO_localtime( to_timestamp ( date, time) ), 'HH' ) AS Hour,

c-ip into nigel.log from %_inputfile% group by Hour, c-ip " -q -o:csv -i:IISW3C

And then to create the graph:

rem create chart
logparser "Select Hour, count(*) as distinctuser INTO %filename%

Unique_HITS_PER_HOUR_03.gif from nigel.log group by Hour order by Hour asc " -q -i:csv -

o:CHART -values:off -chartType:%1 -chartTitle:"%1 Unqiue Hits By Hour" -groupSize:300x200

The graph does not come out at all as expected it graphs the hour as values instead of

placing on the x or y axis.

So I attempted a little test, and this should work, I place the data from query 1 above

and then create the graph from that data, unfortunately this messes up the x and y axis

as well and plots the hours instead of running them along the x or y.

Place data from query 1 above into file hitstomainpage.txt

logparser "SELECT TO_STRING (TO_localtime( to_timestamp ( date, time) ), 'HH' ) AS Hour,

COUNT(*) AS Hits into Hitstomainpage.TXT FROM %_inputfile% where cs-uri-stem like '%

webpage%'GROUP BY Hour ORDER BY Hour ASC" -i:IISW3C -q -o:csv

This gives us simple data:
Hour,Hits
00,22
01,19
02,1
03,4
04,33
05,31
06,110
07,135
08,288
09,365
10,466
11,346
12,394
13,382
14,321

And now all I would like to do is create a simple graph with the hour along the x or y

axis, and the HITS graphed. So this query should work well for that:

logparser "Select Hour, Hits INTO %filename%TOTAL_HITS_PER_HOUR_03_TEST.gif from

Hitstomainpage.TXT order by Hour asc " -q -i:csv -o:CHART -values:off -chartType:%1 -

chartTitle:" hits to main page not working" -groupSize:640x480

Unfortunately the above creates a line or bar3d graph, graphing the hour as well as the

hits number, instead of the desired results.

I believe it may be the way logparser is reading the data type, or for some reason chart

is acting differently with input as a CSV as opposed to the actual raw iisw3c format.

Thanks for any help,
Nigel

Any way to get 45 degree angle in chart?

LogParser User : jake20 — Fri, 06 Apr 2007 21:56:00 GMT

i got just about everything else i need, but just cannot figure out how to get a 45 degree angle for my x axis time labels using a config script .

anyone?