# Export complet avec statistiques
$mailboxes = Get-Mailbox -ResultSize Unlimited
$results = foreach($mailbox in $mailboxes) {
    $stats = Get-MailboxStatistics -Identity $mailbox.UserPrincipalName
    [PSCustomObject]@{
        DisplayName = $mailbox.DisplayName
        UserPrincipalName = $mailbox.UserPrincipalName
        MailboxType = $mailbox.RecipientTypeDetails
        TotalSize = $stats.TotalItemSize
        ItemCount = $stats.ItemCount
        LastLogon = $stats.LastLogonTime
        ProhibitSendQuota = $mailbox.ProhibitSendQuota
    }
}
$results | Export-Csv -Path "C:\temp\ExchangeMailboxes.csv" -NoTypeInformation -Encoding UTF8

# Export détaillé des groupes DL
$groups = Get-DistributionGroup -ResultSize Unlimited
$results = foreach($group in $groups) {
    $members = Get-DistributionGroupMember -Identity $group.Identity
    foreach($member in $members) {
        [PSCustomObject]@{
            GroupName = $group.DisplayName
            GroupEmail = $group.PrimarySmtpAddress
            MemberName = $member.DisplayName
            MemberEmail = $member.PrimarySmtpAddress
            MemberType = $member.RecipientTypeDetails
        }
    }
}
$results | Export-Csv -Path "C:\temp\DistributionGroups.csv" -NoTypeInformation -Encoding UTF8

# Format CSV : DisplayName,UserPrincipalName,FirstName,LastName,Department
$users = Import-Csv -Path "C:\temp\NewMailboxes.csv" -Delimiter ";"
 
foreach($user in $users) {
    try {
        New-Mailbox -Name $user.DisplayName `
                   -UserPrincipalName $user.UserPrincipalName `
                   -FirstName $user.FirstName `
                   -LastName $user.LastName `
                   -Department $user.Department
        Write-Host "✓ Boîte créée : $($user.DisplayName)" -ForegroundColor Green
    } catch {
        Write-Host "✗ Erreur création $($user.DisplayName) : $($_.Exception.Message)" -ForegroundColor Red
    }
}

# Format CSV : GroupName,MemberEmail
$members = Import-Csv -Path "C:\temp\GroupMembers.csv" -Delimiter ";"
 
foreach($member in $members) {
    try {
        Add-DistributionGroupMember -Identity $member.GroupName -Member $member.MemberEmail
        Write-Host "✓ Ajouté $($member.MemberEmail) à $($member.GroupName)" -ForegroundColor Green
    } catch {
        Write-Host "✗ Erreur ajout $($member.MemberEmail) : $($_.Exception.Message)" -ForegroundColor Red
    }
}