SQL query which can pull list of all pages form the confluence which was edited/updated or created

Sandeep Anand_hijvye

Actually i want to find a SQL query which can pull list of all the pages form the my production environment in confluence which was edited/updated or created between specific time frame. I have found a sql macro related that and implemented that. But it didn't show any results. 

So is there any other way so that i can find the list of all the pages which were updated between some specific time frame. 

 

please reply asap.

 Thanks  

Davin Studer

Does this work for you?

declare
@begin datetime,
@end datetime

set @begin = '01/01/2017'
set @end = '10/16/2017'

select *
from [dbo].[CONTENT]
where PREVVER is NULL
and CONTENTTYPE = 'PAGE'
and CONTENT_STATUS = 'current'
and (
 (
 CREATIONDATE >= @begin
 and CREATIONDATE <= @end
 )
 or (
 LASTMODDATE >= @begin
 and LASTMODDATE <= @end
 )
)