« Previous Next »

Thread: How to deal with this problem ?

Last post 11-06-2008 7:53 PM by vikinger. 2 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (3 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 11-06-2008, 9:08 AM

    • vikinger
    • Not Ranked
    • Joined on 11-06-2008, 9:02 AM
    • Posts 2

    How to deal with this problem ?

    Reply Contact

    logparser i:iisw3c -q:on "select distinct c-ip from ex081103.log where to_timestamp (time) = timestamp ('02:18:49','hh:mm:ss')"

    Error: detected extra argument "select distinct c-ip from ex081103.log where to_timestamp (time) = timestamp ('02:18:49','hh:mm:ss') " after query

    Tags:

  • 11-06-2008, 1:51 PM In reply to

    Re: How to deal with this problem ?

    Reply Contact
    correct command should be: logparser -i:iisw3c -q:on "select distinct c-ip from ex081103.log where time = timestamp ('02:18:49','hh:mm:ss')" you don't have to execute to_timestamp on the "time" column...it's already in a datetime format.

  • 11-06-2008, 7:53 PM In reply to

    • vikinger
    • Not Ranked
    • Joined on 11-06-2008, 9:02 AM
    • Posts 2

    Re: How to deal with this problem ?

    Reply Contact

    Thanks a lot !!!!
Page 1 of 1 (3 items)
Microsoft Communities