SHARE
TWEET

Untitled

a guest Aug 20th, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top