Creating a list of Office 365 tenants and their licenses

Connect-MsolService
$customers = Get-MsolPartnerContract

$output = @()

foreach ($customer in $customers)
{
    $companyInfo = Get-MsolCompanyInformation -TenantId $customer.TenantId
    $accountSkus = Get-MsolAccountSku -TenantId $customer.TenantId

    foreach ($sku in $accountSkus)
    {
        $obj = $null
        $obj = New-Object -TypeName PSObject -Property @{
                                                            CustomerName  = $companyInfo.DisplayName
                                                            AccountSkuId  = $sku.AccountSkuId
                                                            ActiveUnits   = $sku.ActiveUnits
                                                            WarningUnits  = $sku.WarningUnits
                                                            ConsumedUnits = $sku.ConsumedUnits
                                                        }

        $output += $obj | select CustomerName,AccountSkuId,ActiveUnits,WarningUnits,ConsumedUnits

    }
}

$output | ft
$output | Export-Csv "<<path to your desktop here>>\Partner-Skus.csv" -NoTypeInformation