Find all content changed on your Umbraco website - audit log
Posted by: Simon Steed
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
Need an Umbraco Master?
Here at Simon Antony, we have an in house certified Umbraco Grand Master available for hire. Got a problem with your site, need architecture advice, give us a call to speak to Simon directly and see how we can helpContact Simon Today!