Guest User

Untitled

a guest
Apr 20th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT TOP 25
  2. EXTRACT_VALUE(cs-uri-query,'id') as id,
  3. MAX(time-taken) As Max,
  4. MIN(time-taken) As Min,
  5. Avg(time-taken) As Average,
  6. SUM(time-taken) As Total,
  7. COUNT(*) AS count
  8. FROM d:\logfiles\W3SVC3\*.log
  9. WHERE cs-uri-stem = '/MSM/RFP/Forms/RequestList.aspx'
  10. GROUP BY id
  11. ORDER By total DESC
Add Comment
Please, Sign In to add comment