FileTypeFilter=IVW;SearchSubFolders=True

FileDateFilter=2013/04/12 7:00PM-2013/04/12
11:59PM;FileTypeFilter=IVW;SearchSubFolders=True

SELECT
Min(DateTime), Max(DateTime), LogFile.Left(68)
FROM VDATA
GROUP BY LogFile.Left(68)

SELECT Mid(LogFile, 54, 14), DateTime, Milliseconds, LogScope, LogLevel, Project, RespondentId, InterviewId, LogEntry
FROM VDATA
WHERE LogLevel * {error, fatal}

SELECT COUNT(*) AS Number, MIN(DateTime) AS FirstTime, MAX(DateTime) AS LastTime, LogEntry
FROM VDATA
WHERE LogLevel * {error, fatal}
GROUP BY LogEntry
ORDER BY COUNT(*)

SELECT
Mid(LogFile, 54, 14), DateTime, Milliseconds, LogScope, LogLevel, Project, RespondentId, InterviewId, Mid(LogEntry, 35, 23)
FROM VDATA
WHERE LogLevel * {warning, error, fatal}

SELECT Project, MIN(DateTime) AS FirstTime, MAX(DateTime) AS LastTime, COUNT(*) AS Number, LogLevel, LogEntry
FROM VDATA
WHERE AppGroup = 'IVW' AND (LogLevel * {warning, error, fatal})
GROUP BY Project, LogEntry, LogLevel
ORDER BY Project, COUNT(*) DESC

SELECT
Mid(LogFile, 54, 14), DateTime, Milliseconds, LogScope, LogEntry
FROM VDATA
WHERE LogEntry.Find('Session Engine s') >= 0

SELECT
Mid(LogFile, 54, 14),
DatePart(DateTime, 'h'),
DatePart(DateTime, 'n'),
SUM(LogEntry.Find('Interviewer Session Engine shutdown') = 0) As EngineShutdowns,
SUM(LogEntry.Find('Interviewer Session Engine start') = 0) As EngineStarts
FROM VDATA
WHERE Logentry.Find('Interviewer Session Engine s') >= 0
GROUP BY
Mid(LogFile, 54, 14),
DatePart(DateTime, 'h'),
DatePart(DateTime, 'n')

SELECT
DateTime.DateOnly() As Day,
CText(DateTime.DatePart('h'))+':'+CText(DateTime.DatePart('n')/15 * 15) As QuarterHour,
SUM(LogEntry.Find('Interviewer Session Engine shutdown') = 0) As EngineShutdowns,
SUM(LogEntry.Find('Interviewer Session Engine start') = 0) As EngineStarts
FROM VDATA
WHERE Logentry.Find('Interviewer Session Engine s') = 0
GROUP BY
DateTime.DateOnly(),
DateTime.DatePart('h'),
DateTime.DatePart('n')/15
ORDER BY
DateTime.DateOnly(),
DateTime.DatePart('h'),
DateTime.DatePart('n')/15

SELECT
DateTime.DateOnly() As Day,
CText(DateTime.DatePart('h'))+':'+CText(DateTime.DatePart('n')/15 * 15) As QuarterHour,
SUM(LogEntry.Find('Interview start') = 0) As InterviewStarts,
SUM(LogEntry.Find('Interview restart') = 0) As InterviewRestarts
FROM VDATA
WHERE LogLevel = {metric} AND (LogEntry.Find('Interview start') = 0 OR LogEntry.Find('Interview restart') = 0)
GROUP BY
DateTime.DateOnly(),
DateTime.DatePart('h'),
DateTime.DatePart('n')/15
ORDER BY
DateTime.DateOnly(),
DateTime.DatePart('h'),
DateTime.DatePart('n')/15

SELECT
DateTime.DateOnly() As Day,
CText(DateTime.DatePart('h'))+':'+CText(DateTime.DatePart('n')/15 * 15) As QuarterHour,
SUM(LogEntry.Find('Interview start') = 0) As InterviewStarts,
SUM(LogEntry.Find('Interview restart') = 0) As InterviewRestarts,
SUM(LogEntry.Find('Interview terminated') = 0) As InterviewTerminates,
SUM(LogEntry.Find('Interview complete') = 0) As InterviewCompletes,
SUM(LogEntry = 'Interview timeout') As InterviewTimeouts,
SUM(LogEntry.Find('Abandoning') >= 0) As InterviewTimeoutAbandons,
SUM(LogEntry.Find('Interview stopped') = 0) As InterviewStops,
SUM(LogEntry.Find('Interview shutdown') = 0) As InterviewShutdowns,
SUM(LogEntry.Find('Interview rejected') = 0) As InterviewRejects
FROM VDATA
WHERE LogLevel = {metric}
GROUP BY
DateTime.DateOnly(),
DateTime.DatePart('h'),
DateTime.DatePart('n')/15
ORDER BY
DateTime.DateOnly(),
DateTime.DatePart('h'),
DateTime.DatePart('n')/15

SELECT
DateTime.DateOnly() As Day,
CText(DateTime.DatePart('h'))+':'+CText(DateTime.DatePart('n')/15 * 15) As QuarterHour,
SUM(LogEntry.Find('has been cached') >= 0 And LogEntry.Find('Version') = 0) As CachedProjects
FROM VDATA
WHERE (Logentry.Find('has been cached') >= 0 And LogEntry.Find('Version') = 0)
GROUP BY
DateTime.DateOnly(),
DateTime.DatePart('h'),
DateTime.DatePart('n')/15
ORDER BY
DateTime.DateOnly(),
DateTime.DatePart('h'),
DateTime.DatePart('n')/15

SELECT InterviewId, COUNT (*)FROM VDATA WHERE LogLevel={metric} GROUP BY
InterviewId HAVING COUNT(InterviewId)<>2

SELECT
DatePart(DateTime, 'h') As Hour, DatePart(DateTime, 'n') As Minute,
SUM(LogEntry.Find('Failover situation found') >= 0) As FailoverSituationFound,
SUM(LogEntry.Find('Rejected, sample in ACTIVE') >= 0) As RejectedFromACTIVE#
FROM VDATA
WHERE (LogEntry.Find('Failover situation found') >= 0 OR LogEntry.Find('Rejected, sample in ACTIVE') >= 0)
GROUP BY
DateTime.DatePart('h'),
DateTime.DatePart('n')

SELECT Mid (LogFile, 54), DateTime, Milliseconds, LogScope, Project, RespondentId,
InterviewId, LogEntry FROM VDATA WHERE RespondentId='1066724411' ORDER BY DateTime

SELECT Project, MIN(DateTime) AS FirstTime, MAX(DateTime) AS LastTime, COUNT(*) AS Number, LogEntry
FROM VDATA
WHERE (LogLevel * {error, fatal}) AND LEFT(LogEntry,4) <> 'HTTP' AND LEFT(LogEntry,26) <> 'The requested sample field'
GROUP BY Project, LogEntry
ORDER BY Project, COUNT(*) DESC

SELECT Project, MIN(DateTime) AS FirstTime, MAX(DateTime) AS LastTime, COUNT(*) AS Number, LogLevel, LogEntry
FROM VDATA
WHERE (LogLevel * {warning, error, fatal}) AND (LogEntry LIKE 'The requested sample field%')
GROUP BY Project, LogEntry, LogLevel
ORDER BY Project, COUNT(*) DESC

SELECT
DatePart(DateTime, 'h') As Hour, DatePart(DateTime, 'n') As Minute, COUNT(*) As IsActiveTimeouts
FROM VDATA
WHERE Logentry.Find('IsActive') >= 0 AND LogLevel = {warning}
GROUP BY DatePart(DateTime, 'h'), DatePart(DateTime, 'n')

SELECT
Mid(LogFile, 54, 14), DateTime, Milliseconds, LogScope, Project, RespondentId, InterviewId, Mid(LogEntry, 35, 23)
FROM VDATA
WHERE LogEntry.Find('IsActive') >= 0 AND LogLevel = {warning}

SELECT
DateTime.DateOnly() As Day,
CText(DateTime.DatePart('h'))+':'+CText(DateTime.DatePart('n')/15 * 15) As QuarterHour,
COUNT(*) As IsActiveErrors
FROM VDATA
WHERE LogEntry.Find('IsActive') >= 0 AND LogLevel = {warning}
GROUP BY
DateTime.DateOnly(),
DateTime.DatePart('h'),
DateTime.DatePart('n')/15
ORDER BY
DateTime.DateOnly(),
DateTime.DatePart('h'),
DateTime.DatePart('n')/15

SELECT
LogEntry.Mid(LogEntry.Find('I.Project') + 10, 8) As Project,
LogEntry.Mid(LogEntry.Find('HTTP Client')+ 12, 20) As Error,
IIf(LogEntry.Find('CreateInterview') = -1, IIf(LogEntry.Find('I.SavePoint') >= 0,
LogEntry.Mid(LogEntry.Find('I.SavePoint') + 12, LogEntry.Find('&', LogEntry.Find('I.SavePoint')) -
LogEntry.Find('I.SavePoint')-12), '[Post]'), '[CreateInterview]') As SavePoint,
COUNT(*)
FROM VDATA WHERE LogEntry.Find('http') = 0 And LogLevel = {error}
GROUP BY
LogEntry.Mid(LogEntry.Find('I.Project') + 10, 8),
LogEntry.Mid(LogEntry.Find('HTTP Client')+ 12),
IIf(LogEntry.find('CreateInterview') = -1, IIf(LogEntry.Find('I.SavePoint') >= 0,
LogEntry.Mid(LogEntry.Find('I.SavePoint') + 12, LogEntry.Find('&',LogEntry.find('I.SavePoint')) -
LogEntry.Find('I.SavePoint')-12), '[Post]'), '[CreateInterview]')

SELECT Project, MIN(DateTime) AS FirstTime, MAX(DateTime) AS LastTime, COUNT(*) AS Number, LogEntry FROM VDATA
WHERE (LogLevel * {warning, error, fatal}) AND LogEntry.Find('Template') >= 0
GROUP BY Project, LogEntry
ORDER BY Project, COUNT(*) DESC

Level Date and Time Source EventID Task Category
Error 2013/4/16 1:42:50 Application Error 1000 Application Crashing Events
Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7afa2
Faulting module name: Qsamp.dll, version: 1.1.1.8352, time stamp: 0x4fc3943e
Exception code: 0xc0000005
Fault offset: 0x0000000000019cfc
Faulting process id: 0x19c8
Faulting application start time: 0x01ce397e563dbf67
Faulting application path: c:\windows\system32\inetsrv\w3wp.exe
Faulting module path: C:\Program Files\Common Files\IBM\SPSS\DataCollection\6\IOM\Qsamp.dll

SELECT SUM(LogEntry LIKE 'Interviewer session%created%' ) –
SUM(LogEntry LIKE '%Interviewer session%closed')
FROM VDATA
WHERE LogScope LIKE '%0x19c8'

SELECT Project, MIN(DateTime) AS FirstTime, MAX(DateTime) AS LastTime, COUNT(*)
AS Number, LogLevel, AppGroup, LogEntry FROM VDATA
WHERE (AppGroup = 'ACT') AND (LogLevel * {warning, error, fatal})
GROUP BY Project, LogEntry, LogLevel, AppGroup
ORDER BY Project, COUNT(*) DESC