Thanks Alex.

I've written a SQL script myself. The God Mode package lists a few more as unused but the SQL gets most of them.

SELECT N.Text AS 'DataTypeName', DT.propertyEditorAlias AS 'EditorType', CT.Alias AS 'ContentTypeAlias', PT.Alias AS 'FieldName'
FROM [UmbracoDev].[dbo].[umbracoNode] N
LEFT JOIN [UmbracoDev].[dbo].[cmsPropertyType] PT ON PT.datatypeid = N.id
LEFT JOIN [UmbracoDev].[dbo].[cmsContentType] CT ON CT.nodeid = PT.ContentTypeId
INNER JOIN [UmbracoDev].[dbo].[cmsDataType] DT ON DT.nodeId = N.id
WHERE CT.Alias IS NULL
ORDER BY N.Text

But the package gives so much more and is built into the back-end so I will use that!

Tim

Umbraco v8 version:

SELECT N.Text AS 'DataTypeName', DT.propertyEditorAlias AS 'EditorType', CT.Alias AS 'ContentTypeAlias', PT.Alias AS 'FieldName'
FROM [umbracoNode] N
LEFT JOIN [cmsPropertyType] PT ON PT.datatypeid = N.id
LEFT JOIN [cmsContentType] CT ON CT.nodeid = PT.ContentTypeId
INNER JOIN [umbracoDataType] DT ON DT.nodeId = N.id
WHERE CT.Alias IS NULL
ORDER BY N.Text