DHCP Log Parser

[Guest Adrian]

Hi

 

Hope someone can help , basically what I want to do is use log parser to see

how many DHCP Renewal a server process per hour. what I have so far is just

the total renewal. Below is my code.

 

SELECT

QUANTIZE(TO_TIMESTAMP(Date, Time), 3600) As HOUR,

Count(*) AS Total

From

C:\WINNT\system32\dhcp\DHCPSrvLog-fri.log

Where

Description = 'Renew'

Group by HOUR