LASTMODDATE is null

[Eva Dezsi]

Hi all,

Do you know why in Confluence database, in the CONTENT table, for the  LASTMODDATE row I am seeing NULL value for a lot of pages?

Thank you.

[Nic Brough -Adaptavist-]

Because the pages have not been amended since creation?

Although, it's well known that Atlassian databases are a terrible thing to look at in terms of reporting, and you probably should be looking at some other way of doing what you're doing.  What is the reason you are looking?

[Eva Dezsi]

Hi,

Thank you for the answer. I am looking to find a way to identify for a space the oldest pages, which were not updated in ages, and are probably outdated content wise. I managed to achieve this with the following query: 

SELECT s.SPACENAME, c.TITLE, c.LASTMODDATE, c.LASTMODIFIER, u.[username]
from [confluence].[dbo].[CONTENT] as c, [confluence].[dbo].[SPACES] s, [confluence].[dbo].[user_mapping] u
where c.CONTENTTYPE = 'PAGE'
and c.TITLE is not null
and s.SPACENAME= 'HR'
and s.SPACEID = c.SPACEID
and u.[user_key] = c.LASTMODIFIER
order by c.LASTMODDATE ASC;

If this is the case, then I also need to add to the query the creation date of the page.