BPOS BES Reporting – Import/Create BlackBerry Business Cloud Service Users

The following instructions will create a spreadsheet listing the users on BES, which can easily be imported into the BlackBerry Cloud Service (BBCS) interface.

Before beginning, create a new .csv file, to be used laster to import/create users within your RIM BBCS Portal, using the following columns and save using the .csv file extension:

Note: The Group Names column does not require an entry

“Email Address”,”Group Names”

1. Download and install the latest Microsoft Transition Tool
   1. X64 – http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7013
   2. X86 – http://www.microsoft.com/download/en/details.aspx?id=5015
2. Run the Migration Command Shell
3. Copy the following script into notepad and save it as a .ps1 file:
   $cred = Get-Credential

   $besid = (Get-MSOnlineSubscription -Credential $cred | where {$_.SubscriptionServiceTypes -eq “BlackBerry”}).SubscriptionId

   $besusers =@()

   $mosusers = Get-MSOnlineUser -Enabled -credential $cred

   foreach ($mosuser in $mosusers) {

       if ($user.SubscriptionIds.contains($bbsid)) {$besusers += $mosuser}}

   $besusers | select Identity | Export-Csv “BPOSBESUsers.csv” -NoTypeInformation

   NOTE: You may need to run PowerShell -> Set-ExecutionPolicy Unrestricted [Y] to allow this remote script to run!

4. Browse to where you saved the *.ps1 file and run the script
   1. When prompted use a BPOS Admin account
   2. Once run, look to the directory where the .ps1 file was run and you will have the list named BPOSBESUsers.csv
   3. Copy the results of the output and add them to the previously created .csv file, under the Email Address column (NOTE: The “Group Names” column does not require an entry!)

   Example Final .csv File
   

   “Email Address”,”Group Names”

   “UserA@contoso.com“

   “UserB@contoso.com“

   “UserC@contoso.com “

5. Once completed, you now have a .csv file that can be used to import/create BBCS enabled users