The PeopleSync Frontend IIS logs can be analyzes analyzed with “log parser”, a Microsoft tool. It can be downloaded here.
The following queries can be used to answer specific questions regarding CardDAV operations.
...
| Code Block |
|---|
|
SELECT c-ip, 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 extract_prefix(extract_suffix(cs-uri-stem,2,'/'), 0, '/') = 'peoplesync@example.com'
and [cs(User-Agent)] <> 'CardDav+.NET/0.1'
group by c-ip, cs-method, [cs(User-Agent)], extract_prefix(extract_suffix(cs-uri-stem,2,'/'), 0, '/')
order by c-ip, cs-method, [cs(User-Agent)], extract_prefix(extract_suffix(cs-uri-stem,2,'/'), 0, '/')
|
Are contacts deleted by clients and recreated by agent?
Look for rows where cs-method alternates between DELETE and PUT.
| Code Block |
|---|
|
SELECT top 1000 date, time, c-ip, cs-method,cs-uri-stem,sc-status, [cs(User-Agent)] FROM '[LOGFILEPATH]'
where cs-uri-stem like '%'
and ((cs-method = 'PUT' and [cs(User-Agent)]='CardDav+.NET/0.1') or (cs-method = 'DELETE' and sc-status=204))
order by date, cs-uri-stem, time |
Which client versions are successfully synching?
Status code 207 mean successful sync request, status code 500 means server error.
| 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) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | com.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@259e9a |
|---|
| sort | modified |
|---|
| showSpace | false |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label = "kb-how-to-article" and type = "page" and space = "PSKB" |
|---|
| labels | kb-how-to-article |
|---|
|
