Hi Sebastian,

How about a bit of SQL:

/* content nodes using doctypeId */

DECLARE @docTypeId AS int
SET @docTypeId = 123 // Doctype Id to check

SELECT *
FROM cmsContent A
INNER JOIN umbracoNode B ON A.nodeId = B.id
WHERE contentType = @docTypeId

/* content nodes using a templateId */

DECLARE @templateId AS int
SET @templateId = 123 // Template Id to check

SELECT  C.path AS 'Path', 
    C.level AS 'Level',
   C.id AS 'Node Id', 
   C.text AS 'Text',       
  A.alias AS 'docType Alias'
FROM cmsContentType A
LEFT OUTER JOIN cmsContent B ON A.nodeId = B.contentType
INNER JOIN umbracoNode C ON B.nodeId = C.id
WHERE A.nodeId IN (
 SELECT contentTypeNodeId
  FROM cmsDocumentType A
    INNER JOIN cmsContentType B ON A.contentTypeNodeId = B.nodeId
 WHERE templateNodeid = @templateId
)
ORDER BY text ASC

HTH,

Hendy

is working on a reply...