Старые ящики Exchange

$gms=Get-MailboxStatistics -server grmdb | Select-Object DisplayName, LastLogonTime | Where-Object {$_.Lastlogontime -lt (get-date).AddDays(-90) -and $_.Lastlogontime -gt (Get-Date).AddYears(-5)} 
 
$gms | ForEach-Object {Get-Mailbox $_.displayname} | Select-Object DistinguishedName, WhenCreated

Get-Mailbox -server grmdb | Get-MailboxStatistics

Get-MailboxDatabase | Get-MailboxStatistics | ? { $_.DisconnectReason}  | ft DisplayName,DisconnectReason

Get-MailboxStatistics -server grmdb | ?{$_.DisplayName -match 'Михайлова Елена Алексеевна'} | fl DisplayName,DisconnectReason

Get-Mailbox -server grmdb | Get-MailboxStatistics | ? {$_.Lastlogontime -lt (get-date).AddDays(-90) -and $_.Lastlogontime -gt (Get-Date).AddYears(-5)} | Get-Mailbox | select DistinguishedName, WhenCreated

Get-MailboxStatistics -server grmdb | ? { $_.DisconnectReason}  | ft DisplayName,DisconnectReason

Get-MailboxStatistics -Server $server | ? {!$_.DisconnectReason -and $_.DisplayName -notmatch 'HealthMailbox'} | ? {$_.Lastlogontime -lt (get-date).AddDays(-90) -and $_.Lastlogontime -gt (Get-Date).AddYears(-5)} | Get-Mailbox | ft DistinguishedName,WhenCreated

Get-MailboxDatabase (Get-MailboxStatistics -server grmdb | ?{$_.DisplayName -match 'Михайлова Елена Алексеевна'}).Database | fl Name,MailboxRetention

$gms=Get-MailboxStatistics -server grmdb | Select-Object DisplayName, LastLogonTime | Where-Object {$_.Lastlogontime -lt (get-date).AddDays(-90) -and $_.Lastlogontime -gt (Get-Date).AddYears(-5)}

$server = 'grmdb'
foreach ($item in Get-MailboxStatistics -Server $server | ? {!$_.DisconnectReason} | ? {$_.Lastlogontime -lt (get-date).AddDays(-90) -and $_.Lastlogontime -gt (Get-Date).AddYears(-5)})
{
  try{$item | Get-Mailbox -ErrorAction Stop | Out-Null}
  catch {$item | fl DisplayName,Database; Get-Mailbox $item -Monitoring}
}

Get-MailboxStatistics -Server grmdb | ? {!$_.DisconnectReason -and $_.DisplayName -notmatch 'HealthMailbox'} | ? {$_.Lastlogontime -lt (get-date).AddDays(-90) -and $_.Lastlogontime -gt (Get-Date).AddYears(-5)} | Get-Mailbox | ft DistinguishedName,WhenCreated

$server = 'grmdb'
foreach ($item in Get-MailboxStatistics -Server $server | ? {!$_.DisconnectReason} | ? {$_.Lastlogontime -lt (get-date).AddDays(-90) -and $_.Lastlogontime -gt (Get-Date).AddYears(-5)})
{
  try{$item | Get-Mailbox -ErrorAction Stop | Out-Null}
  catch {$item | fl *}
}

Get-MailboxStatistics -server grmdb | ?{$_.DisplayName -match 'Михайлова Елена Алексеевна'} | fl *

Get-MailboxDatabase (Get-MailboxStatistics -server grmdb | ?{$_.DisplayName -match 'Михайлова Елена Алексеевна'}).Database

((Get-MailboxStatistics -server 'grmdb' | ?{$_.DisplayName -match 'Михайлова Елена Алексеевна'}).DisconnectDate).AddDays((Get-MailboxDatabase (Get-MailboxStatistics -server 'grmdb' | ?{$_.DisplayName -match 'Михайлова Елена Алексеевна'}).Database).MailboxRetention.Days)

$server = 'grmdb'
foreach ($item in Get-MailboxStatistics -Server $server | ? {!$_.DisconnectReason} | ? {$_.Lastlogontime -lt (get-date).AddDays(-90) -and $_.Lastlogontime -gt (Get-Date).AddYears(-5)})
{
  try{$item | Get-Mailbox -ErrorAction Stop | Out-Null}
  catch {$item | fl Identity,DisplayName,Database}
}

$server = 'grmdb'
$user = 'Михайлова Елена Алексеевна'
cls
foreach ($stat in Get-MailboxStatistics -server $server | ?{$_.DisplayName -match $user})
{
    $stat | fl DisplayName,Identity,DisconnectReason,DisconnectDate,Database
    if ($stat.DisconnectDate)
    {
        Write-Host 'Дата окончательного удаления:' $stat.DisconnectDate.AddDays((Get-MailboxDatabase $stat.Database).MailboxRetention.Days)
    }
}

Get-MailboxStatistics -server 'grmdb' | ?{$_.DisplayName -match 'Серверный архив - Федоренко Дмитрий Борисович'} | fl DisplayName,Identity,DisconnectReason,DisconnectDate,Database

Disable-Mailbox -Identity $MailboxGuid
Start-Sleep -Seconds 15
Clean-MailboxDatabase -Identity $MDB
Start-Sleep -Seconds 15
Remove-Mailbox -Database $MDB -StoreMailboxIdentity $MailboxGuid

(Get-MailboxDatabase 'MailBox GRMdb_Msk').MailboxRetention.Days

$server = 'grmdb'
cls
foreach ($stat in Get-MailboxStatistics -server $server | ?{$_.DisconnectReason})
{
    
    $stat | fl DisplayName,Identity,DisconnectReason,DisconnectDate,Database
 
    switch ($stat.DisconnectReason)
    {
        'Disabled'    {Remove-StoreMailbox -Database $stat.Database -Identity $stat.MailboxGuid -MailboxState Disabled -Confirm:$false -WhatIf}
        'SoftDeleted' {Remove-StoreMailbox -Database $stat.Database -Identity $stat.MailboxGuid -MailboxState SoftDeleted -Confirm:$false -WhatIf}
    }
        
}
 
Start-Sleep -Seconds 30
 
"Проверка:"
Get-MailboxStatistics -server $server | ?{$_.DisconnectReason} | fl DisplayName,Identity,DisconnectReason,DisconnectDate,Database

Clean-MailboxDatabase -Identity 'MailBox GRMdb_Msk'
Start-Sleep -Seconds 30
Get-MailboxStatistics -server 'grmdb' | ?{$_.DisplayName -match 'Серверный архив - Федоренко Дмитрий Борисович'} | fl DisplayName,Identity,DisconnectReason,DisconnectDate,Database