Frontend IIS Log Analysis
- EBERHARD, Sebastian (messageconcept)
Owned by EBERHARD, Sebastian (messageconcept), created
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, timeWhich 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-statusRelated articles
© 2010-2024 messageconcept GmbH / messageconcept software GmbH
Legal Notice / Imprint