« Previous Next »

Thread: Chart csv data

Last post 11-14-2006 1:15 PM by LogParser User : sotherls. 5 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (6 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 11-13-2006, 8:34 PM

    Chart csv data

    Reply Contact

    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?

     
    Tags:

  • 11-14-2006, 9:15 AM In reply to

    RE: Chart csv data

    Mark as Answer
    Reply Contact
    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
    Tags:

  • 11-14-2006, 11:27 AM In reply to

    RE: Chart csv data

    Mark as Answer
    Reply Contact
    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.
    Tags:

  • 11-14-2006, 12:03 PM In reply to

    RE: Chart csv data

    Mark as Answer
    Reply Contact
    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).

     
    Tags:

  • 11-14-2006, 12:38 PM In reply to

    RE: Chart csv data

    Mark as Answer
    Reply Contact
    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
    Tags:

  • 11-14-2006, 1:15 PM In reply to

    RE: Chart csv data

    Mark as Answer
    Reply Contact
    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.

     
    Tags:
Page 1 of 1 (6 items)
Microsoft Communities