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 roomname@yourdomain.com -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 roomname@yourdomain.com:\Calendar -User fishbowluser@yourdomain.com -AccessRights Editor}
Catch{Set-MailboxFolderPermission -Identity roomname@yourdomain.com:\Calendar -User fishbowluser@yourdomain.com -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 Office 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.