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?
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Community! me again 🙂 If you’re a marketing team using Confluence, we want to hear your story! How did you start using Confluence? What are your use cases? What have been some of the benefits?...
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