How to find unghosted pages

on September 20, 2006

Thanks to Todd Klindt about this tip.

Open the Tables of your content database. The information is in the “Docs” table. “SetupPath” and “Content” are the two fields we care about. “SetupPath” tells where the original “ghosted” content is derived from. If the “SetupPath” field is empty, the content can’t be ghosted/unghosted. If
that field is not empty (or null) then we have to look at the “Content” field. That’s where the non-ghosted material is stored, if there is any.

So I’ve used the following query to find unghosted pages:

Code:

SELECT *
FROM Docs
WHERE (SetupPath IS NOT NULL) AND (Content IS NOT NULL)

Run that in the Docs table of your content database(s). The leafname field
is the filename that has been changed.

Have fun.

ShareThis