This searches through all the latest version of all the pages:
SELECT DISTINCT 'http://confluence.example.com/confluence/pages/viewpage.action?pageId=' || contentid AS URL FROM CONTENT INNER JOIN BODYCONTENT USING(contentid) WHERE prevver IS NULL AND SPACEID IS NOT NULL AND PARENTID IS NOT NULL AND REGEXP_LIKE(BODY, 'internal-webserver\d(\.example\.com)?\\public', 'i');
No comments :
Post a Comment