I need confluence Page IDs for all pages containing a specific string.

Peter DeWitt
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 1, 2017

OK,here is the scenario.  We have a Confluence instance that is a number of years old.  Over the years users have created many pages (2000+) that contain passwords in plain text.  Our security team has a list of these passwords and they need to remove them from the pages they appear on and remove the history of those pages.  They would like us to generate a list of page URLs for them.  If we have the page IDs we can concatenate the URLs in excel. 

1. Does anyone have any ideas on how to do this either through the API or direct to DB?

2. Has anyone come across a utility that would allow the scrubbing of specific strings within all of Confluence; find and replace like?

6 answers

4 accepted

1 vote
Answer accepted
Stephen Deutsch
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 7, 2017

Here's another option:

Search and Replace User Macro

You could use this to search for the search terms, and it will create a table in Confluence with links that you could copy and paste into Excel, and then you wouldn't even have to look up the IDs. Either that or I could modify it so it would display the IDs as well.

It has replace functionality too, so you could use it to make the necessary changes. It has a preview option so you can see what changes it is making to the code of the page.

Davin Studer
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 7, 2017

Pretty slick user macro! I might be using this myself for some manual replacements I have been doing.

1 vote
Answer accepted
AnnWorley
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 1, 2017

I am not sure how to generate a list of URLs with the particular strings (passwords) but as far as a search and replace strategy, you could try a procedure similar to: How Do I replace all 'hard' links to my old Base URL The first two options will replace content in historical page versions.

0 votes
Answer accepted
Davin Studer
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 1, 2017

Keysight Admin Tools for Confluence has a utility for find and replace throughout the whole wiki. Use with caution and test first on a non-prod version. :)

0 votes
Answer accepted
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 1, 2017
1 vote
Davin Studer
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 7, 2017

If you want a SQL query to find the pages this should get you what you want.

select S.SPACENAME, C.*
from CONTENT C
inner join BODYCONTENT B on C.CONTENTID = B.CONTENTID
inner join SPACES S on C.SPACEID = S.SPACEID
where
C.PREVVER is null
and C.CONTENT_STATUS = 'current'
and (C.CONTENTTYPE = 'PAGE' or C.CONTENTTYPE = 'BLOGPOST')
and B.BODY like '%YourStringHere%'
order by S.SPACENAME, C.TITLE
0 votes
Peter DeWitt
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 7, 2017

Guys, tanks for the answers.  This is exactly what I was looking for.  Options. :)

Davin Studer
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 8, 2017

If we get to choose our tanks I'm gonna have to go with the good old Sherman.

TankshermanM4.jpg

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events