A
Adrian
Guest
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
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