Chart csv data RSS

• • Reply
  

  Anonymous

  6623 Posts

  Chart csv data

  Nov 14, 2006 12:34 AM|LINK

  THis should be soooo simple but it isn't - yet. Help!

  I have a csv file which has data similar to this:

  TIME,COUNTed
  2006-11-09 13:51:24,3279
  2006-11-09 13:56:24,3285
  2006-11-09 14:01:24,3295
  2006-11-09 14:06:24,3000.....

  I want to simply have a chart that depicts the last ten events in the log similar to

  3300 |       x
  3200 |X     X
  3100 |X     X
  3000 |X     X
  2900 |X___X__________
           1     6     1     6
           5     5     0     0
           :      :     :      :
           3     3     4     4
           1     1     1     1

  Any ideas how to accomplish this?

   

  ADS input format

• • Reply
  

  Anonymous

  6623 Posts

  Re: Chart csv data

  Nov 14, 2006 01:15 PM|LINK

  What are you having trouble with? The query or the chart?
  The query should be something along the lines of:

  
  SELECT TOP 10 Time, Count
  FROM log
  ORDER by Time DESC

  ADS input format

• • Reply
  

  Anonymous

  6623 Posts

  Re: Chart csv data

  Nov 14, 2006 03:27 PM|LINK

  LogParser User : sotherls

  Quote: What are you having trouble with? The query or the chart? The query should be something along the lines of: SELECT TOP 10 Time, Count FROM log ORDER by Time DESC

  
  The query isn't the issue. It is the chart output format that is causing me grief.

  ADS input format

• • Reply
  

  Anonymous

  6623 Posts

  Re: Chart csv data

  Nov 14, 2006 04:03 PM|LINK

  LogParser User : sotherls

  Quote: THis should be soooo simple but it isn't - yet. Help! I have a csv file which has data similar to this: TIME,COUNTed 2006-11-09 13:51:24,3279 2006-11-09 13:56:24,3285 2006-11-09 14:01:24,3295 2006-1...

  
  

  Ok, to expand further.....

  If I have the following dataset
  TS,Counts,Server
  2006-11-14 11:08:06,1,Server-1
  2006-11-14 11:08:07,1966,Server-2
  2006-11-14 11:10:00,3,Server-1
  2006-11-14 11:10:00,1849,Server-2
  2006-11-14 11:15:00,1,Server-1
  2006-11-14 11:15:00,1436,Server-2
  2006-11-14 11:20:00,4,Server-1
  2006-11-14 11:20:00,1065,Server-2
  2006-11-14 11:25:00,4,Server-1
  2006-11-14 11:25:00,818,Server-2
  2006-11-14 11:30:00,13,Server-1
  2006-11-14 11:30:00,652,Server-2

  I would like to see if I can output a chart that would show server-1's count next to server-2's count by TS (timestamp).

   

  ADS input format

• • Reply
  

  Anonymous

  6623 Posts

  Re: Chart csv data

  Nov 14, 2006 04:38 PM|LINK

  When I try working on it I get an error of "Error: Syntax Error: : expecting FROM keyword instead of token 'c:\logparser\test\Chart.gif'"
  
  logparser -i:CSV "SELECT TOP 10 Time, Count INTO c:\logparser\test\Chart.GIF FROM c:\logparser\test\log.csv ORDER by Time DESC" -charttype:bar3d
  
  

  ADS input format

• • Reply
  

  Anonymous

  6623 Posts

  Re: Chart csv data

  Nov 14, 2006 05:15 PM|LINK

  LogParser User : sotherls

  Quote: When I try working on it I get an error of "Error: Syntax Error: : expecting FROM keyword instead of token 'c:\logparser\test\Chart.gif'" logparser -i:CSV "SELECT TOP 10 Time, Count INTO c:\logpars...

  
  

  I had to modify your query to get you further along:

  logparser -i:CSV "SELECT TOP 10 TS, Counts INTO c:\logparser\test\Chart.GIF FROM c:\logparser\test\log.csv ORDER by TS DESC" -charttype:bar3d

  Which results in this display.

   

  ADS input format