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

[Veracode]

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?

[FelipeA · Accepted solution]

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

[Veracode]

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!

[Veracode]

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?