We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

View Complete Thread
  • Re: New GUI tool for MS Log Parser, Log Parser Lizard

    Nov 17, 2008 09:57 PM|Photo_Joe|LINK

    I could use some help with a query.

    I can list all the log records that have cs-method = post and order they by cs-uri-stem then by cs-status with this query.

    SELECT date, time, c-ip, cs-uri-stem, cs-method, sc-status FROM c:\logs\08-08\0808.log
    WHERE (cs-method = 'POST') ORDER BY cs-uri-stem, sc-status

    But now I want to get just a count of all the records that have cs-method = post and that have a cs-status = 200 and order by cs-uri-stem