Forum Discussion

Robert Bollinger's avatar
Robert Bollinger
Iron Contributor
Aug 02, 2019

PowerShell script. List of 500 users and conference room ownership (managerment)

Hey Guys,    I have a list of 500 or so users who i want to find out which conference rooms they own, or are listed as manager of. There are about 17K conference room mailboxes.    I have tried m...
admin
exchange
office 365
VasilMichev's avatar
VasilMichev
MVP
Aug 03, 2019

Whit that number of objects, you're better off exporting the complete list of room mailboxes along with the corresponding properties to a CSV, then using Excel to do a lookup for matching users from your other CSV file.

 

Or, you can use server-side filtering based on the Manager attribute, but for that you need to prepare a list of DNs:

 

Get-Recipient -RecipientTypeDetails RoomMailbox -Filter {Manager -eq "CN=manager,OU=tenant.onmicrosoft.com,OU=Microsoft Exchange Hosted Organizations,DC=EURPR03A001,DC=prod,DC=outlook,DC=com"}

  • Robert Bollinger's avatar
    Robert Bollinger
    Iron Contributor
    Aug 03, 2019

    VasilMichev 

     

    Thanks for the response. As i always i appreciate it. But what i dont understand is why my powershell script/commands arent working. Can you help me to fix the command itself? 

     

    Thanks, 

     

    Robert 

    • VasilMichev's avatar
      VasilMichev
      MVP
      Aug 04, 2019

      Without seeing the full solution including the CSV file I cannot be sure. I'd suggest reviewing the actual values stored within the different variables, make sure there are no empty values and that they can be compared against each other and so on.

Resources