Confluence - how to obtain a list of spaces created

Julio Valdez

Hi,

I have a request for a report/list of spaces created w/in Confluence that includes:

name of space

created date

Space owner

URL

Is there a way to do this w/in Confluence?

Thanks in advance.

Stephen Deutsch

I wrote this script to pull the data, you can copy and paste it into the browser javascript console after you have logged into Confluence and it will print out the data you are looking for.

jQuery.ajax({
  contentType: 'application/json',
  type: 'POST',
  url: contextPath + '/rpc/json-rpc/confluenceservice-v2/getSpaces',
  success: function( spaceSummaries ) {
    jQuery(spaceSummaries).each(function() {
      if (this.type === 'global') {
        var spaceKey = this.key;
        jQuery.ajax({
          url: contextPath + "/rest/prototype/1/space/" + spaceKey,
          dataType: "json",
          success: function(spaceData) {
            console.log("Space - " + spaceData.name);
            console.log("Key - " + spaceData.key);
            console.log("Created - " + spaceData.createdDate.friendly);
            console.log("Last Modified - " + spaceData.lastModifiedDate.friendly);
            if (spaceData.hasOwnProperty("home")) {
              console.log("Creator - " + spaceData.home.creator.name);
              console.log("Last Modifier - " + spaceData.home.lastModifier.name);
            }
            console.log("URL - " + spaceData.link[1].href);
            console.log("----");
          }
        });
      }
    });
  }
});

EDIT: Here is a version that waits for the previous connection to finish before requesting a new one (it doesn't put so much pressure on your Confluence instance).

var parseSpaces = function(spaceSummaries) {
  var spaceSummary = spaceSummaries.shift();
  if (spaceSummary.type === 'global') {
    var spaceKey = spaceSummary.key;
    jQuery.ajax({
      url: contextPath + "/rest/prototype/1/space/" + spaceKey,
      dataType: "json",
      success: function(spaceData) {
        console.log("Space - " + spaceData.name);
        console.log("Key - " + spaceData.key);
        console.log("Created - " + spaceData.createdDate.friendly);
        console.log("Last Modified - " + spaceData.lastModifiedDate.friendly);
        if (spaceData.hasOwnProperty("home")) {
          console.log("Creator - " + spaceData.home.creator.name);
          console.log("Last Modifier - " + spaceData.home.lastModifier.name);
        }
        console.log("URL - " + spaceData.link[1].href);
        console.log("----");
        if ( spaceSummaries.length > 0 ) {
          parseSpaces(spaceSummaries);
        }
      }
    });
  }
  if ( spaceSummaries.length > 0 ) {
    parseSpaces(spaceSummaries);
  }
}
jQuery.ajax({
  contentType: 'application/json',
  type: 'POST',
  url: contextPath + '/rpc/json-rpc/confluenceservice-v2/getSpaces',
  success: function( spaceSummaries ) {
    console.log("Starting...");
    parseSpaces(spaceSummaries);
  }
});