Exchange Server

Fishbowl uses the EWS API to communicate with your Exchange Server. You need to create bookable resources and assign delegated Editor permissions to a user to access these resources. The following PowerShell commands are for reference purposes only, and are only compatible with the latest Exchange Server (2019).

1. Open a remote PowerShell session

1. Download and install the following PowerShell modules
   1. Microsoft Online Services Sign-in Assistant
   2. Azure Active Directory (AD) Module
   For additional information, refer to the relevant PowerShell support page
2. Open PowerShell, and enter

   $credential = get-credential

3. Enter credentials of an administrator and click OK
4. Enter the following one line at a time:

   Import-Module MSOnline
   Connect-MsolService -Credential $credential
   $ExchangeSession = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri "https://outlook.office365.com/powershell-liveid/" -Credential $credential -Authentication "Basic" -AllowRedirection
   Import-PSSession $ExchangeSession
   

   For additional information, refer to the relevant PowerShell support page
5. If you get an error indicating that Files cannot be loaded because running scripts is disabled on this system, then you need to first run PowerShell as an administrator and enter

   Set-ExecutionPolicy RemoteSigned

   You only need to run this command once.

2. Create resources

While in PowerShell, create a resource for each of your rooms with a mailbox and a password.

New-Mailbox -MicrosoftOnlineServicesID [email protected] -Name "Room Name" -EnableRoomMailboxAccount $true -Room -RoomMailboxPassword (ConvertTo-SecureString -String 'example_password' -AsPlainText -Force) -ResetPasswordOnNextLogon $false

3. Grant delegated Editor permissions OPTIONAL

Instead of creating a user for each resource, if you prefer to create a single user with delegated Editor permissions to all your resources, then you can assign this using:

Try{Add-MailboxFolderPermission -Identity [email protected]:\Calendar -User [email protected] -AccessRights Editor}
Catch{Set-MailboxFolderPermission -Identity [email protected]:\Calendar -User [email protected] -AccessRights Editor}

Note: Assigning delegated permissions may take a few minutes to propagate.

4. Disconnect PowerShell session

Disconnect the remote PowerShell session by executing

Remove-PSSession $Session

5. Configure Fishbowl

When configuring Fishbowl, on the Select server type page, select Microsoft.

On the Connect to your server page, uncheck the I am using Microsoft 365 option.

Enter your Exchange Server URL. This is where your EWS endpoint is located. Fishbowl appends "/EWS/Exchange.asmx" to this URL.

Enter the email address and password of the resource mailbox that you created in Step 2 OR the credentials of the user that you assigned delegated permissions to in Step 3, then tap on Next.

On the Set up your room mailbox page, enter the email address of the resource mailbox that you created in Step 2, then tap on Next.

(Android only) Scan your Fishbowl license QR code, or enter your license code manually, and tap on Next.

Configure your logo and colour settings and tap on Next.