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:
|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.