The PeopleSync Frontend IIS logs can be 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.

Are Clients using the Address List Service account?

Clients should not use the address list’s service account, as they would have write access to the address list.
In the following query, replace ‘peoplesync@example.com’ with the your address list service account.

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.

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.

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

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

The content by label feature displays related articles automatically, based on labels you choose. To edit options for this feature, select the placeholder below and tap the pencil icon.

Related issues