How to: Create a room list in Exchange

With our new add-on it’s now possible to book Exchange rooms and equipment directly from a SharePoint calendar. To use this add-on you may need to create room lists in Exchange. This article describes how to do this.

Exchange 2010/2013

Use the Exchange management shell to create the room list.

New-DistributionGroup -Name "Rooms Vienna" –RoomList
New-DistributionGroup -Name "Rooms Vienna" –RoomList

You can use the –Members parameter to add rooms directly.

# get all room mailboxes
$Members=Get-Mailbox -Filter {(RecipientTypeDetails -eq "RoomMailbox")}
# create room list
New-DistributionGroup -Name "Rooms Vienna" –RoomList -Members $Members
# get all room mailboxes
$Members=Get-Mailbox -Filter {(RecipientTypeDetails -eq "RoomMailbox")}
# create room list
New-DistributionGroup -Name "Rooms Vienna" –RoomList -Members $Members

If you want to add individual rooms, you can use the following script:

# add "Conference Room A" to room list "Rooms Vienna"
Add-DistributionGroupMember -Identity "Rooms Vienna" -Member conferenceroom-a@yourcompany.com 
# add "Conference Room A" to room list "Rooms Vienna"
Add-DistributionGroupMember -Identity "Rooms Vienna" -Member conferenceroom-a@yourcompany.com 

You can also add rooms manually using the Exchange Management Console. The room list is available in the distribution group section. Just open the properties and add the rooms to the members tab.

Exchange Online

If you want to create a room list in Exchange Online, you have to use the remote shell. To use the remote shell, you first have to install the Exchange management tools.
Guide: installing Exchange management tools.

To connect to your O365 Exchange run the following commands:

$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session
$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session

Create the room list:

New-DistributionGroup -Name "Rooms Vienna" –RoomList
New-DistributionGroup -Name "Rooms Vienna" –RoomList

Add rooms to room list:

Add-DistributionGroupMember -Identity "Rooms Vienna" -Member conferenceroom-a@yourcompany.com
Add-DistributionGroupMember -Identity "Rooms Vienna" -Member conferenceroom-a@yourcompany.com

Be sure to disconnect the remote PowerShell session when you’re finished.

Remove-PSSession $Session
Remove-PSSession $Session

I hope you found this guide useful. If you have any problems or any other questions, please send an e-mail to support@sapiens.at or post a comment.