Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,783
Community Members
 
Community Events
168
Community Groups

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

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;

1 answer

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

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events