Get a list of pages for all spaces?

[Darryl St_ Pierre]

I'm working on a project to consolidate some of our spaces, and need to address duplicate page names such as "How-to articles" (each former Space will have it's own page, but duplicate pages can't exist).

I'd like to be able to pull a list of all spaces and pages under each, so that we can then rename the duplicates so they don't conflict when consolidating.

Is there a way to accomplish this?

[Jonathan Smith · Accepted solution]

Would the children display macro be sufficient?

• Target page would be your space home page.
• Change descendants to a large number.

[Darryl St_ Pierre]

Thanks for the response. This would be good except that we have about 400 spaces to review.

[Jonathan Smith]

SQL my friend:

Make a join between dbo.SPACES and dbo.CONTENT:

select DISTINCT b.SPACENAME, a.TITLE
from dbo.CONTENT a left join dbo.SPACES b on a.SPACEID=b.SPACEID
where a.CONTENTTYPE='PAGE'
and a.TITLE is not NULL
and b.SPACENAME is not NULL
order by b.SPACENAME

Export to Excel when finished. Best of luck!

[Darryl St_ Pierre]

Thanks Jonathan! I'll run this by my SQL admin. Seems pretty straightforward.