I've been meaning to blog about this for some time, but just getting around to do so. Recently, we released a report pack for SPS that leverages SQL Reporting Services. You can download this at http://www.microsoft.com/downloads/details.aspx?FamilyID=49159368-544B-4B09-8EED-4844B4E33D3D&displaylang=en. One of the best features is that it's free!
For the lazy who didn't click on the link, the reports included are:
Shows a listing of the virtual servers and the number of collections, sites, areas, lists, files and size. Also shows a size distribution and storage usage chart, and a top 20 sites based on size.
Storage Trend Report
Shows four charts illustrating the virtual server storage trend, site collection growth trend, area growth trend and list growth trend.
Site Trend Report
Shows hit counts for virtual servers, collections, areas and lists. Also shows the top 20 sites based on hits.
Comprehensive Site Collections Report
Shows the list of site collections, who owns the collection, configurable characteristics about the owner and the date the collection was last accessed.
Detailed Site Collection Report
Shows top 20 pages accessed (based on hit count) for this site collection.
Detailed Page Report
Shows users who have access to the page, when they last accessed it, any referrer URL and number of hits. Also shows two charts illustrating user distribution and referrer distribution.
Best Bet Keyword
Shows top 20, top 10, bottom 10, or bottom 20 keywords used for searching. Also shows which keywords have best bets.
Shows top 20, top 10, bottom 10, or bottom 20 search terms used for searching. Also shows which search terms match a defined keyword.