Logparser - Analyze your IIS Log Files
|
urpose
|
Query
|
Sample Output
|
||||||||||||||||||||||||
|
Number of Hits per
Client IP, including a Reverse DNS lookup (SLOW)
|
SELECT c-ip As Machine,
REVERSEDNS(c-ip) As Name,
COUNT(*) As Hits
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
GROUP BY Machine ORDER BY Hits DESC
|
|
||||||||||||||||||||||||
|
Top 25 File Types
|
SELECT TOP 25
EXTRACT_EXTENSION(cs-uri-stem) As Extension,
COUNT(*) As Hits
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
GROUP BY Extension
ORDER BY Hits DESC
|
|
||||||||||||||||||||||||
|
Top 25 URLs
|
SELECT TOP 25
cs-uri-stem as Url,
COUNT(*) As Hits
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
GROUP BY cs-uri-stem
ORDER By Hits DESC
|
|
||||||||||||||||||||||||
|
Number of hits per
hour for the month of March
|
SELECT
QUANTIZE(TO_LOCALTIME(TO_TIMESTAMP(date, time)), 3600) AS Hour,
COUNT(*) AS Hits
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
WHERE date>'2010-03-01' and date<'2010-04-01'
Group By Hour
|
|
||||||||||||||||||||||||
|
Number of hits per
Method (GET, POST, etc)
|
SELECT
cs-method As Method,
COUNT(*) As Hits
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
GROUP BY Method
|
|
||||||||||||||||||||||||
|
Number of requests
made by user
|
SELECT TOP 25
cs-username As User,
COUNT(*) as Hits
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
WHERE User Is Not Null
GROUP BY User
|
|
||||||||||||||||||||||||
|
Extract Values from
Query String (d and t) and use them for Aggregation
|
SELECT TOP 25
EXTRACT_VALUE(cs-uri-query,'d') as Query_D,
EXTRACT_VALUE(cs-uri-query,'t') as Query_T,
COUNT(*) As Hits
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
WHERE Query_D IS NOT NULL
GROUP BY Query_D, Query_T
ORDER By Hits DESC
|
|
||||||||||||||||||||||||
|
Find the Slowest 25
URLs (in average) in the site
|
SELECT TOP 25
cs-uri-stem as URL,
MAX(time-taken) As Max,
MIN(time-taken) As Min,
Avg(time-taken) As Average
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
GROUP BY URL
ORDER By Average DESC
|
|
||||||||||||||||||||||||
|
List the count of
each Status and Substatus code
|
SELECT TOP 25
STRCAT(TO_STRING(sc-status),
STRCAT('.', TO_STRING(sc-substatus))) As Status,
COUNT(*) AS Hits
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
GROUP BY Status
ORDER BY Status ASC
|
|
||||||||||||||||||||||||
|
List all the
requests by user agent
|
SELECT
cs(User-Agent) As UserAgent,
COUNT(*) as Hits
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
GROUP BY UserAgent
ORDER BY Hits DESC
|
|
||||||||||||||||||||||||
|
List all the Win32
Error codes that have been logged
|
SELECT
sc-win32-status As Win32-Status,
WIN32_ERROR_DESCRIPTION(sc-win32-status) as Description,
COUNT(*) AS Hits
FROM c:\inetpub\logs\LogFiles\W3SVC1\*
WHERE Win32-Status<>0
GROUP BY Win32-Status
ORDER BY Win32-Status ASC
|
|
0 개의 댓글:
댓글 쓰기