thekid.me.uk

Thanks a lot for this, it was a great help. It always amazes me when the issue I'm having turns up in one my blogs on the same day!

Nice moves Vince, I which I'd known about the sys.fn_varbintohexstr function sooner. Best, Tyler

That's a great post and one of the few good examples of quering against the DB directly for this kind of trouble shooting. There are two other approaches that should have worked as well. CQWP can be configured to show data of a particular content type and that might have found it. Also, a keyword search like: Content-type:"theContentType" should have returned the data as well. --Paul Galvin

Hi Vince, That's indeed a very annoying situation :). I developed a very small tool that's available on CodePlex and that lets you know where a content type is used accross a site collection http://www.codeplex.com/spcontenttypeexplore It's very similar to the standard content types page but allows you to quickly see where your content type is used so that you can delete it afterwards :). However, interesting post as usual :) and of course your solution covers the entire webapp not mine.

I appreciate the effort you did in publishing this documentation. http://www.xavor.com/whatwedo/solutions/Sharepoint2010.aspx

Here's a slightly improved version -- adds web url & description, and list title: SELECT ctu.[SiteId], w.[FullUrl], w.[Description], ctu.[WebId], sys.fn_varbintohexstr(ctu.[ContentTypeId]) AS ContentTypeId, ctu.[ListId], l.[tp_Title], ctu.[IsFieldId], ctu.[Class] FROM [ContentTypeUsage] ctu LEFT JOIN [Sites] s ON ctu.[SiteId] = s.[Id] LEFT JOIN [Webs] w ON s.[RootWebid] = w.[Id] LEFT JOIN [Lists] l ON ctu.[IsFieldId] = 0 AND ctu.[ListId] = l.[tp_ID] WHERE (sys.fn_varbintohexstr(ctu.[ContentTypeId]) LIKE '0x01004d5a79bafa4a4576b79c56ff3d0d662d%')

Very easy and useful.Thanks for sharing. Keep it up!