...
| Code Block | ||
|---|---|---|
| ||
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 |
Clients Syncing per Day
| Code Block | ||
|---|---|---|
| ||
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 |
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...