Is there a way to check which pages are using the "Knowledge Base Survey Plugin"?

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?

2 answers

1 accepted

Hi there,

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\"%');

Best Regards,

Felipe Alencastro

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!

Thanks again!

perhaps something like this search function?

https://ffeathers.wordpress.com/2011/11/04/how-to-search-confluence-for-usage-of-a-macro/

Any macros that are specific to the Knowledge Base Survey Plugin?

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Friday in Confluence

We want to hear how your non-technical teams are using Confluence!

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

309 views 11 10
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you