MSIT SharePoint Reporting Framework V2.1.0 contains many fixes and improvements from its early 1.0 version used internally at MSIT.
It is not recommended or supported to do direct queries against production databases. These queries should not be performed against production environments or environments sensitive to query performance. In these environments you could consider running this on a copy in a non production environment.

Since the release of MOSS 2007 / WSS 3.0 to the world there has been a gap in operational level metrics and global service metrics. At MSIT we decided to fill that gap with what we call the MSIT Sharepoint Reporting Framework. Since beta 2 we have been building and tuning scripts that we use internally to gather various metrics. Information is definently power, with these numbers it gives you the ability to really keep your finger on the pulse of your SharePoint infrastructure.


Highlights
  • Created smart installation wrapper around SQL setup code
  • Multi Farm Support
  • Multi Version Support WSS 3.0 / MOSS 2007 RTM +
  • Fixed an issue with cbq4proc that was slowing down results dramatically
  • Centralized repository for data collected.
  • Standardized procs for better data aggregation

Data Points Collected
  • Site URL
  • Site Admin
  • Recycle Bin (used disk space)
  • Bandwidth Used per Site
  • Site Size
  • Site maximum Quota
  • Site Used Quota
  • SiteID GUID
  • Content Database Name
  • Content Database Server
  • Configuration Database Name
  • Configuration Database Server
  • Last Content Change Date
  • Site Version
  • Servers in Farm
  • SMTP Host Configured for Farm
  • WebID Guid
  • Web URL
  • ParentWebID Guid
  • Web Template Used
  • Language ID Site is using
  • Documents Per web broken out by Document Type
  • Space Used by Document broken out by Document Type
  • Content Database Size Used / Free


Using this data we now have the ability to join and combine data sets to pull many different types of metrics and historical audits.

Metrics that are now possible
  • Configuration Database History - This allows you to track site collections versus content databases. Next time you need to restore a site you won’t be stuck playing a guessing game to which content database the site is from.
  • Site Size Tracking - Would you like to know which site is growing more than the others? You can now easily track this.
  • Sites going stale - Running out of space? Need to clean up some unused sites ? This will show you the goods.
  • Recycle Bin Used space - Calculate how much your organization is using the integrated recycle bin feature, useful for storage capacity planning.
  • Site, Web, Document Tracking - Really feel the pulse of your environment to track how fast it grows. Watch as you put on and take off site collections. Especially useful for deployments using self site creation.
  • Site broken down by language used - Track how diverse your deployment has become. Helpful in planning regional deployments based on usage.
  • Document Totals - Does your ORG create a substantial more of 1 type of document than the next? See it here.
  • Site Template Tracking - View the most popular look and feel templates that your users enjoy and utilize.
  • and much more..!

Last edited Apr 11, 2008 at 12:09 AM by corylee, version 10