Advertisement
Guest User

Untitled

a guest
Aug 20th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. /* Number of requests with Network issu per hour */
  2. SELECT
  3. QUANTIZE(ADD( TO_TIMESTAMP( date, time ), TO_TIMESTAMP( '10', 'hh' ) ), 3600) AS At,
  4. COUNT(*) AS Hits
  5. FROM '[LOGFILEPATH]'
  6. WHERE sc-win32-status=64
  7. GROUP BY QUANTIZE(ADD( TO_TIMESTAMP( date, time ), TO_TIMESTAMP( '10', 'hh' ) ), 3600)
  8. ORDER BY QUANTIZE(ADD( TO_TIMESTAMP( date, time ), TO_TIMESTAMP( '10', 'hh' ) ), 3600)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement