title: Count total number of pages globally
body: <p>We are preparing for an upgrade of confluence.  We are documenting all the current information about our confluence instance before we do the upgrade.</p>
  
  <p>I need to know how many <strong>Total</strong> pages there are globally within confluence.  </p>
  
  <p>From the administrators console I can see this information </p>
  
  <pre><code>Content (All Versions)         91892
  Content (Current Versions)     18194
  </code></pre>
  
  <p>It is my understanding that this information is total content, including blog posts, attachments, comments etc... Not specifically Page Count</p>
  
  <p>I have found some macros that will tell me how many pages exist in a particular space, but that does not quite do what I need as we have over 200 spaces currently.</p>
  
  <p>The database we have this on is: Microsoft SQL Server.</p>
  
  <p>Confluence Version: 3.4.2</p>
  
  <p>Is there any way to get the total number of pages within confluence globally?</p>
  
  <p>Any help would be greatly appreciated.</p>