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

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