How to find the number of active webpages or searchable published content on site. Updated September 08, 2017 20:48 DescriptionThis article shows you how to find the number of active pages and searchable published content on you website. This does not include archived content. ResolutionIn 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)