IIS Logs Parser – Get Top Hostnames by Date and Time

  • Home
  • DevOps
  • IIS Logs Parser – Get Top Hostnames by Date and Time
IIS Logs Parser

A while back I needed to parse our IIS logs to see our top hostname traffic between a specified date and time range. The simple IIS log parser snippet allows just this. Change the date and timestamp to narrow your IIS logs.

SELECT TOP 50     
    cs-host,
    COUNT(*) AS Total 
FROM '[LOGFILEPATH]'  
WHERE
     date = '2019-01-23' 
AND    
    time between timestamp('10:00:00', 'hh:mm:ss') and timestamp('11:00:00', 'hh:mm:ss') 
GROUP BY cs-host 
ORDER BY Total DESC
Tags:

    Dan Horrocks-Burgess

    Software Developer by day, Disney lover by night.