« Previous Next »

Thread: Trying to run an sql query with a sub-query, however log parser won't run it.

Last post 03-23-2007 3:35 PM by LogParser User : DEinspanjer. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 03-23-2007, 12:07 PM

    Trying to run an sql query with a sub-query, however log parser won't run it.

    Reply Contact
    Hello,

    I'm trying to extract the unique users using Windows Mobile devices. However the below sql statement isn't working in the logparser GUI. Does anyone know what is wrong with this query?

    Select Count(*)
    From (Select cs(User-Agent), cs-username FROM 'c:\ex070322.log' where cs(User-Agent) like 'MSFT%' group by cs(User-Agent), cs-username)
    Tags:

  • 03-23-2007, 3:35 PM In reply to

    RE: Trying to run an sql query with a sub-query, however log parser won't run it.

    Mark as Not Answer
    Reply Contact
    Yes, LP doesn't support that type of sub-query.
    You'll have to do it in two passes.
    Tags:
Page 1 of 1 (2 items)
Microsoft Communities