Recently we put a site into read only and we got locked out of the site after a possible timer had ran. The issue was a page that was still in “draft” mode, once it was published all was well. Here a query to run against the database to check for those files.
SELECT
NN.Url AS URL,
UIVersionString,NN.ElementType,[Level]
FROM AllDocs (NOLOCK) AD
JOIN NavNodes (NOLOCK) NN ON
AD.WebID = NN.WebID
AND NN.Url LIKE '%' + AD.LeafName + '%'
WHERE
[Level] = 2 /* Draft Version */
AND UIVersionString LIKE '0.%' /* Never Published */
AND NN.ElementType = 1 /* 0 = Page, 1 = Link, 2 = Dynamic Page */
No comments:
Post a Comment