Home → How Do I... →

Get count of pages, files

• Edit

whitenjg

Aug 10, 2010 @ 08:07 PM

Is there any way to get a count of the number of Pages contained in the database?

Similarly, is there any way to get a count of the number of files?

Thanks!
Jon

1. Support Staff 1 Posted by Tim on Aug 11, 2010 @ 03:45 PM

   

   Hi Jon,

   There is no way to do this from the interface, but you should be able to do this with a query like:
   

   select count(*) from cxml_foldercontent
   where assetType = 'PAG' 
   and isCurrentVersion = 1 
   and isRecycled = 0;

   This will give you the count of all pages (not including past versions and not including recycled pages).

   You can execute the same query but change assetType to 'FIL' to get the count for files.

   Hope this helps!

   • Edit

2. Tim closed this discussion on Aug 11, 2010 @ 03:45 PM.