logparser Command

CD D:\IISLogs\www\W3SVC242049591 --HS
CD D:\IISLogs\www\W3SVC971333791 --WHM
CD D:\IISLogs\www\W3SVC1074683251 --ADTOP
CD D:\IISLogs\www\W3SVC1059179751 --HBT

logparser "SELECT date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status, COUNT(*) AS Hits FROM ex*.log where date = '2007-08-30'and cs-uri-stem like '%.asp' and sc-status = 500 GROUP BY date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status ORDER BY date, time" -i:iisw3c -o:datagrid





logparser "SELECT date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status, COUNT(*) AS Hits FROM ex*.log where date > '2007-08-20'and cs-uri-stem like '%.asp' and cs-uri-query like '%zoom%' and sc-status = 500 GROUP BY date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status ORDER BY date, time" -i:iisw3c -o:datagrid


logparser "SELECT date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status, COUNT(*) AS Hits FROM ex*.log where date > '2007-08-28'and cs-uri-stem like '%.asp' and cs-uri-query like '%zoom%' GROUP BY date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status ORDER BY date, time" -i:iisw3c -o:datagrid




logparser "SELECT date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status, COUNT(*) AS Hits FROM ex*.log where sc-status >=500 GROUP BY date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status ORDER BY date, time" -i:iisw3c -o:datagrid

logparser "SELECT date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status, COUNT(*) AS Hits FROM ex*.log where c-ip='209.51.147.66' GROUP BY date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status ORDER BY date, time" -i:iisw3c -o:datagrid
logparser "SELECT * FROM ex*.log where c-ip='209.51.147.66' ORDER BY date, time" -i:iisw3c -o:datagrid

logparser "SELECT TOP 10 * FROM ex*.log where cs-uri-stem like '%default.asp%' ORDER BY date, time" -i:iisw3c -o:datagrid


logparser "SELECT date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status, COUNT(*) AS Hits FROM ex*.log where c-ip='58.64.20.2' and sc-status >=500 GROUP BY date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status ORDER BY date, time" -i:iisw3c -o:datagrid

logparser "SELECT date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status, COUNT(*) AS Hits FROM ex*.log where cs-uri-stem like '%admin2.asp' and sc-status >=500 GROUP BY date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status ORDER BY date, time" -i:iisw3c -o:datagrid




logparser "SELECT date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status, COUNT(*) AS Hits FROM ex*.log where sc-status >=500 GROUP BY date, time, cs-uri-stem, cs-uri-query, c-ip, cs-method, sc-status ORDER BY date, time" -i:iisw3c -o:datagrid