I have written an extender to the Microsoft Assessment and Planning Toolkit here:

http://dbspider.codeplex.com/

The project is a Microsoft Assessment and Planning Toolkit Extender that leverages:

• The Microsoft Assessment and Planning Toolkit (MAP)
• SQL Server 2008 R2
• The .NET 2.0 Framework
• C# Sql Server Management Objects
• Optionally PowerPivot
• Telerik WPF Controls

The goals of the MAP Extender is to:
-Determine all SQL Server 2000, 2005 and 2008 Instances, Databases, Tables, Indexes and Users over time

• -Help with Capacity Planning and Growth
• -Help with Consolidation Efforts
• -Help understand the potential cost and infrastructure savings of SQL Server 2008 Compression

Here is a quick overview:

http://channel9.msdn.com/posts/mwilmot/Microsoft-Assessment-and-Planning-Toolkit-Extender-Setup 

Related Links:

MAP & MAP Extender
http://channel9.msdn.com/posts/mwilmot/Microsoft-Assessment-and-Planning-Toolkit-Extender/

Promoting Software Ideas
http://channel9.msdn.com/posts/mwilmot/Promoting-Software-Ideas/

The tool will not work correctly with SQL 2008 SP1 (it breaks SMO) unless you install this update:
http://support.microsoft.com/kb/972207

Special thanks to Jim Siebengartner and Russell Christopher
-Mike Wilmot (mikewilm@microsoft.com)