Hi @Mani,
Welcome to the Microsoft Q&A platform!
Based on your problem description, here are some steps you can follow to retrieve and export calendar items from 4 years ago:
- Make sure the calendar folder is not set to auto-archive. Sometimes, if auto-archive is enabled, older items may be moved to the archive folder.
- Since you have already checked the Recoverable Items folder, make sure you have checked all subfolders within the Recoverable Items folder. Sometimes, items may be stored in subfolders.
- You can use the eDiscovery tool in the Exchange Admin Center to search for old calendar items. This tool allows you to search across mailboxes and recover items that may not be visible in the user's mailbox.
- After retrieving the calendar items, you can export them. If you are using Outlook, you can export the calendar to a CSV file:
- Go to File > Open & Export > Import/Export.
- Select Export to File > Comma Separated Values.
- Select the calendar folder and specify the date range.
- Save the file to the desired location.
- If you are familiar with PowerShell, you can use it to export the calendar items. Here is a basic script to export calendar items to a CSV file:
$Mailbox = "user@example.com"
$StartDate = (Get-Date).AddYears(-4)
$EndDate = (Get-Date)
$CalendarItems = Get-MailboxFolderStatistics -Identity $Mailbox -FolderScope Calendar | Get-MailboxFolder -Recurse | Get-CalendarDiagnosticLog -StartDate $StartDate -EndDate $EndDate
$CalendarItems | Export-Csv -Path "C:\CalendarItems.csv" -NoTypeInformation
Adjust the $Mailbox, $StartDate, and $EndDate variables as needed.
Please feel free to contact me for any updates. And if this helps, don't forget to mark it as an answer.
Best,
Jake Zhang