How to find the number of active webpages or searchable published content on site.

This article shows you how to find the number of active pages and searchable published content on you website. This does not include archived content.

In SQL, run the following query to obtain the number of active pages:

select count(*) from content where (content_status='A' and searchable=1) and (content_type=1 or content_type=2)