Number pf published pages

Rhythmyx Technical Discussion
1

Hello,

Is there a way to find out how many pages are published on a specific day? May be some query or a Percussion tool…

  • Ravi
2 
SELECT SUM(delivered_count)
FROM psx_publication_status
WHERE start_date > to_date('2010-11-17 00:00:00','YYYY-MM-DD HH24:MI:SS')
AND end_date     < to_date('2010-11-17 23:59:59','YYYY-MM-DD HH24:MI:SS')