Skip to content

Instantly share code, notes, and snippets.

@JamesSkemp

JamesSkemp/Sitecore Find published items created and deleted.sql

Created April 11, 2014 18:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JamesSkemp/10492013 to your computer and use it in GitHub Desktop.
Save JamesSkemp/10492013 to your computer and use it in GitHub Desktop.
Download ZIP
Find items created and deleted as part of a recent Sitecore publish.
Raw
Sitecore Find published items created and deleted.sql
use XXX_Sitecore_Web
select top 100 h.Action, h.Category, h.ItemId, h.ItemVersion, h.ItemPath, h.UserName, h.Created
--select count(*)
from History h
where UserName = 'user'
and Created <= '2014-04-11 17:11:36.870'
and Created >= '2014-04-11 17:00:59.963'
-- Created and Deleted items are potentially disruptive changes. The rest could be bad, but ...
and h.Action in ('Created', 'Deleted')
order by h.Created
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment