SQL to Find Umbraco Nodes using a Certain Umbraco Document Type

In order to get the Umbraco nodes which use a certain umbraco Document Type, you can use the following SQL script. You can then simply login to umbraco backoffice and search for the nodeId value in there and find the node that you want.

SELECT * FROM cmsContent C
INNER JOIN cmsContentType CT ON C.contentType = CT.nodeId
INNER JOIN umbracoNode N ON C.nodeId = N.id
WHERE CT.alias = 'YourDocumentTypeAlias'


Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Getting Umbraco Content - IPublishedContent vs IContent vs Node vs Document