Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
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
languagesql
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

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@259e9a
sortmodified
showSpacefalse
reversetrue
typepage
cqllabel = "kb-how-to-article" and type = "page" and space = "PSKB"
labelskb-how-to-article
Page Properties
hiddentrue

Related issues