Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP 25
- EXTRACT_VALUE(cs-uri-query,'id') as id,
- MAX(time-taken) As Max,
- MIN(time-taken) As Min,
- Avg(time-taken) As Average,
- SUM(time-taken) As Total,
- COUNT(*) AS count
- FROM d:\logfiles\W3SVC3\*.log
- WHERE cs-uri-stem = '/MSM/RFP/Forms/RequestList.aspx'
- GROUP BY id
- ORDER By total DESC
Add Comment
Please, Sign In to add comment