How can I easily find out the last modification date of spaces.

Dan Tombs

Hi Community,

 

When on server you could run a DB query to obtain stuff like when a space was last modified or who the owner was etc.

Basically what is the best way of running something like this command on cloud.

SELECT spaces.spacename, MAX(content.lastmoddate)
FROM content, spaces
WHERE content.spaceid = spaces.spaceid
GROUP BY spaces.spacename;

unknown

The closest I have come is the answer on this article - https://community.atlassian.com/t5/Confluence-questions/How-to-check-Cloud-Confluence-space-last-modified/qaq-p/673391

 

jQuery.ajax({dataType: 'json',
  contentType: 'application/json',
  type: 'POST',
  url: contextPath + '/rpc/json-rpc/confluenceservice-v2/getSpaces',
  success: function(spaces) {
    jQuery(spaces).each(function() {
      var space = this;
      if (space.type === "global") {
        jQuery.ajax({
          url: contextPath + '/rest/api/content/search?cql=space%3D' + space.key + '%20and%20type%3Dpage%20order%20by%20lastmodified%20desc&expand=version&limit=1',
          success: function(data) {
            console.log(space.name + "(" + space.key + ") - " + data.results[0].version.when);
          }
        });
      }
    });
  }
});