I suggest you ...

Allow to type in multiple SQL querys into query editor

Allow you to put in multiple SQL / Log querys in a single query window.

Right now it's very limiting to only allow one SQL statement per query window.

I generally have a "scratch" pad which is just a text document that has common querys for a particular set of tasks all within one query document. THis is preferred to having 10 querys all in seperate files as the 10 querys build upon themselves for analysis, they are not mutually exclusive.

You should be able to highlight text in query window and press F5 to run the SELECTED query like the LogParser from codeplex does.

5 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminLizard Labs (not your business, Lizard Labs) responded  · 

In Log Parser Lizard version 5.0 new keywords are introduced to merge, join, group queries (these can be very useful since the merged datasets can be used in Dashboards and Reports):
GO – create tables in single dataset without relation (useful in dashboard and reports)
MERGE – merge tables in one
LPL_UNION – same as MERGE
LPL_INTERSECT – intersection of two tables
LPL_PRODUCT – product of two tables
RELATION_ON_FIRST_COLUMN – create tables in single dataset and try to create a relation on first column (must be of same data type)
RELATION_ON_SAME_COLUMNS – create tables in single dataset and try to create a relation on all columns with same name
JOIN_ON_FIRST_COLUMN – joins results of two tables in another one on the first column
JOIN_ON_SAME_COLUMNS – joins tables on the columns with the same name

4 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Steve C commented  ·   ·  Flag as inappropriate

    Thank you, this is HUGE!!!
    The following query now outputs two result grids--the second of which contains the UniqueVisitors by date.

    SELECT DISTINCT date,cs-username FROM 'C:\temp\logs\u_ex1505*.log' GROUP BY date,cs-username
    GO
    SELECT date,count(cs-username) as UniqueVisitors FROM 'C:\temp\logs\u_ex1505*.log' GROUP BY date

  • Steve C commented  ·   ·  Flag as inappropriate

    Here's an ugly work-around! : )

    <% With New Diagnostics.Process
    With .startinfo
    .FileName="cmd"
    .Arguments = "/c logparser -q:on -i:iisw3c """ & _
    "SELECT DISTINCT cs-username,date " & _
    "INTO C:\temp\tempUniqueVisitorsPerDay.csv " & _
    "FROM D:\IIS_Log_Archive\SP2010\Consolidated\all_u_ex14051*.log " & _
    "WHERE cs-username <> NULL " & _
    "GROUP BY date, cs-username"""
    .UseShellExecute=False
    .CreateNoWindow=True
    End With
    .Start()
    .WaitForExit()
    End With %>

    SELECT date, count(cs-username) AS UniqueVisitors
    FROM c:\temp\tempUniqueVisitorsPerDay.csv
    GROUP BY date

  • Steve C commented  ·   ·  Flag as inappropriate

    I would love this. A good use case would be doing the following with a single script.

    SELECT DISTINCT cs-username, date INTO tempUniqueVisitorsPerDay.csv FROM logs\iis\ex*.log WHERE cs-username <> NULL Group By Date, cs-username

    SELECT date, count(cs-username) as UniqueVisitors into test.txt FROM tempUniqueVisitorsPerDay.csv GROUP BY date

Feedback and Knowledge Base