log Parser Studio

log Parser Studio.sql

SELECT 
     TO_TIMESTAMP(TO_DATE(date), TO_TIME(time)) AS Timestamp, 
     sc-status as Status, sc-substatus as Sub-Status, cs-method as Method, 
     cs-uri-stem as URL, cs-uri-query as Query, time-taken as Time-Taken-ms
FROM '[LOGFILEPATH]' 
WHERE
     time-taken > 1000
     AND TO_DATE(date) = '2015-12-18' 
     AND to_time(time) 
         BETWEEN timestamp('11:00:00','hh:mm:ss') AND timestamp('11:15:00','hh:mm:ss') 
     AND cs-uri-stem NOT LIKE '/app%'
     AND cs-uri-stem NOT LIKE '/akamai/%'
GROUP BY Timestamp, sc-status, sc-substatus, cs-method, cs-uri-stem,cs-uri-query , time-taken 
ORDER BY Timestamp, sc-status, sc-substatus, cs-uri-stem, time-taken asc