How to see a statistic: pages updated for one space category

[Christian Fopke]

Hi, we have one space per project (category "project"). Home page is a data sheet with important informations, status, involved persons ...

Do we have a possibility seeing all projects in a list like "not updated since" or "last update"..?

By using category  - maybe and status ?

Kind regards, Christian

[Guilherme Nedel [Atlassian] · Accepted solution]

Hello Christian, I believe this can be helpful and a good start:

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

[Christian Fopke]

It isn´t a macro, but brilliant. Good idea, using SQL in this case - thank you ! Best regards, Chris