본문 바로가기

카테고리 없음

Visual LogParser

time 조건으로 필터링 하기



select  logfilename,time-taken,time,cs-uri-stem,cs-uri-query,sc-status

--select count(*)

 from  C:\스터디exam로그\스터디209_u_ex140311.log

where to_time(time) >= timestamp('01:10:00','hh:mm:ss')

and cs-uri-stem = '/Course/ExamModule/Frame/FrameExaminationPage.aspx'

and time-taken is not null

and time-taken < 1000