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;

[Dan Tombs]

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);
          }
        });
      }
    });
  }
});