Skip to content

Instantly share code, notes, and snippets.

@JamesSkemp

JamesSkemp/Sitecore Missing Templates Check.sql

Created June 7, 2016 20:51
Show Gist options
  • Save JamesSkemp/79035ef741befd75e00b5097ef11432d to your computer and use it in GitHub Desktop.
Save JamesSkemp/79035ef741befd75e00b5097ef11432d to your computer and use it in GitHub Desktop.
Download ZIP
Sitecore check for missing templates
Raw
Sitecore Missing Templates Check.sql
USE XXX_Master
-- Find items that don't have a template set.
SELECT TOP 10 *
FROM Items mi
LEFT JOIN Items ti ON mi.TemplateID = ti.ID
WHERE ti.ID IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment