Hello. We must upgrade Confluence to 5.5.2 due to the security advisory. I asked if/when the "Knowledge Base Survey Plugin" will be available for that version of Confluence. The answer was "working on it...".
Is there any way to check which pages in our Confluence installation are using that plugin, so that I can warn users that their functionality will be affected before I do the upgrade?
I believe the above query might return what you're looking for:
SELECT CONTENT.CONTENTID, TITLE, SPACEID, (SELECT SPACENAME FROM SPACES WHERE SPACEID=CONTENT.SpaceID) AS SPACENAME, (SELECT username FROM user_mapping WHERE user_key=CONTENT.CREATOR) AS CREATOR, (SELECT username FROM user_mapping WHERE user_key=CONTENT.LASTMODIFIER) AS LASTMODIFIER, CREATIONDATE, LASTMODDATE FROM CONTENT, BODYCONTENT WHERE PREVVER IS NULL AND (CONTENTTYPE = 'PAGE') AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID AND CONTENT_STATUS = 'current' AND (BODY LIKE '%ac:name=\"kbsurvey\"%');
Thanks! That's excellent. Just to be thorough, I changed the last line of the where clause to be
AND (BODY LIKE '%ac:name=\"kbsurvey\"%'
OR BODY LIKE '%ac:name=\"kbsearch\"%'
OR BODY LIKE '%ac:name=\"kbtoparticles\"%'
It found my test pages, but found nothing in our production environment. Looks like we can disable the plugin and do the upgrade!
perhaps something like this search function?
Any macros that are specific to the Knowledge Base Survey Plugin?
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs