Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* Number of requests with Network issu per hour */
- SELECT
- QUANTIZE(ADD( TO_TIMESTAMP( date, time ), TO_TIMESTAMP( '10', 'hh' ) ), 3600) AS At,
- COUNT(*) AS Hits
- FROM '[LOGFILEPATH]'
- WHERE sc-win32-status=64
- GROUP BY QUANTIZE(ADD( TO_TIMESTAMP( date, time ), TO_TIMESTAMP( '10', 'hh' ) ), 3600)
- ORDER BY QUANTIZE(ADD( TO_TIMESTAMP( date, time ), TO_TIMESTAMP( '10', 'hh' ) ), 3600)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement