Total Number of CMS Pages

rreynolds's Avatar

rreynolds

02 Aug, 2016 06:59 PM

Is there a query or report that will quantify how many pages are in the CMS both global and sites models?

  1. Support Staff 1 Posted by Tim on 02 Aug, 2016 07:10 PM

    Tim's Avatar

    Hey there,

    I believe this query will do the trick for you:

    select count(id) from cxml_foldercontent 
    where assetType = 'PAG' and isCurrentVersion = 1 
    and isRecycled = 0 and isWorkingCopy = 0
    
    Let me know if you need anything else.

    Thanks

  2. 2 Posted by rreynolds on 02 Aug, 2016 07:35 PM

    rreynolds's Avatar

    Worked like a charm. Thanks again Tim!

  3. rreynolds closed this discussion on 02 Aug, 2016 07:36 PM.

Discussions are closed to public comments.
If you need help with Cascade CMS please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

 

26 Aug, 2016 01:19 PM
25 Aug, 2016 03:02 PM
25 Aug, 2016 12:50 PM
24 Aug, 2016 08:43 PM
24 Aug, 2016 07:20 PM
21 Aug, 2016 01:20 PM