PowerTip: Use PowerShell to Generate Tenant Site Report
Summary: Use Windows PowerShell to generate a report about Office 365 tenant sites.
How can I use Windows PowerShell to generate a report about my Office 365 tenant sites?
Install the SharePoint Online Management Shell and install the cmdlet library for SharePoint Online
(provided by MVP, Gary LaPointe). This will give you 82 cmdlets.