Skip to content

Instantly share code, notes, and snippets.

@JamesSkemp

JamesSkemp/Sitecore Items With the Highest Version Count.sql

Last active August 29, 2015 14:20
Show Gist options
  • Save JamesSkemp/d8d31ca78a2d9d61b58a to your computer and use it in GitHub Desktop.
Save JamesSkemp/d8d31ca78a2d9d61b58a to your computer and use it in GitHub Desktop.
Download ZIP
Check the Sitecore VersionedFields table for items with the largest number of versions
Raw
Sitecore Items With the Highest Version Count.sql
use xxx_Master
select top 10 ItemId, count(*)
from VersionedFields
-- Field that all items will have.
where FieldId = '5DD74568-4D4B-44C1-B513-0AF5F4CDA34F'
-- exclude any items that you'd like
and ItemId not in ('8C4CCA29-6750-4DCF-A3F9-970CC5896427')
group by ItemId
order by count(*) desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment