New GUI tool for MS Log Parser, Log Parser Lizard
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