Page Comparison

SELECT cs(User-Agent), sc-status, 
	COUNT(*) AS Total , cs-method
FROM '[LOGFILEPATH]' 
where 
cs-method = 'REPORT'
and (sc-status = 207 or sc-status = 500)
GROUP BY cs(User-Agent), sc-status , cs-method
ORDER BY cs(User-Agent), Total DESC

SELECT [date], sc-status , cs-method, [cs(User-Agent)], extract_prefix(extract_suffix(cs-uri-stem,2,'/'), 0, '/'), count(*) FROM '[LOGFILEPATH]'
where (cs-method = 'REPORT' or cs-method = 'PUT' or cs-method = 'DELETE')
and [cs(User-Agent)] <> 'CardDav+.NET/0.1'

group by [date], sc-status, cs-method, [cs(User-Agent)], extract_prefix(extract_suffix(cs-uri-stem,2,'/'), 0, '/') 
order by  [date], extract_prefix(extract_suffix(cs-uri-stem,2,'/'), 0, '/'), sc-status