KNOWLEDGE BASE

The following script will run on Umbraco 7 & 8 and will show you all the content changed and by whom - very useful if you want to compare staging and live versions so you can update them.

SELECT ul.[id]
      ,ul.[userId]
      ,ul.[NodeId]
      ,ul.[Datestamp]
      ,ul.[logHeader]
      ,ul.[logComment]
	  ,un.[text] as NodeName
	  ,un.[path] as NodePath
	  ,uu.userName
	  ,uu.userEmail
	  ,uu.avatar as userAvatar
	  
  FROM umbracoLog as ul
	INNER JOIN umbracoNode as un ON un.id = ul.NodeId
	INNER JOIN umbracoUser as uu ON uu.id = ul.userId

  WHERE 
	ul.userId is not NULL 
	AND ul.nodeId is not NULL
	AND ul.nodeId > 0 -- Only include actual nodes

  ORDER by ul.Datestamp DESC