exchange search and export calendar items and it's scheduled time

GoodResource 376 Reputation points
2022-11-21T11:46:51.75+00:00

Hi We have a requirement to search and export calendar items to an excel along with the meeting's scheduled time not the time when it was sent or received. So basically we want to know what all meetings were scheduled during 2016-2019 and those meeting's actual scheduled time not when this was sent. Is it possible?

Microsoft Exchange Online Management
Microsoft Exchange Online Management
Microsoft Exchange Online: A Microsoft email and calendaring hosted service.Management: The act or process of organizing, handling, directing or controlling something.
4,208 questions
Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
7,369 questions
Microsoft Exchange Hybrid Management
Microsoft Exchange Hybrid Management
Microsoft Exchange: Microsoft messaging and collaboration software.Hybrid Management: Organizing, handling, directing or controlling hybrid deployments.
1,901 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jame Xu-MSFT 4,166 Reputation points
    2022-11-22T04:01:27.213+00:00

    Hi @GoodResource ,
    You could try to export the calendar using the following cmdlet: 

    Export-Mailbox-Identity –StartDate ‘01/01/2016’ –EndDate ‘31/12/2019’ –IncludeFolders ‘\Calendar’ –FilePath \\PSTFile\FolderName\FileName.pst

    Refer to:
    https://www.nucleustechnologies.com/blog/export-import-calendar-items-from-office-365-using-powershell/
    Microsoft provides third-party contact information to help you find additional information about this topic. This contact information may change without notice. Microsoft does not guarantee the accuracy of third-party contact information.

    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Jame Xu-MSFT 4,166 Reputation points
    2022-11-25T09:32:34.617+00:00

    Hi @GoodResource ,
    You can export the calendars one by one:
    Please assign your self full access of the room mailbox and then make sure the Room calendar is visible in your calendar folder in Outlook client.
    Once you see under Calendar -> then you can make use of Export feature in Outlook and get the required data is CSV using below steps:
    Make sure room Calendar is checked
    Click on File -> Import/Export -> Next
    Export to a File -> Next
    Comma Separated Values -> Next
    Select the Room Calendar -> Next
    Select the location to save the file
    At last, it will ask you the Date Range -> Next

    There is no direct Powershell in Exchange to export all room meeting calendar in CSV, If your requirement is a batch export, this is not possible.

    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.