Description

The following steps and attached files will determine which licensed O365 accounts and Veritas Alta Archiving accounts will be eligible for sync.  The attached PowerShell script will connect to O365 and query the license info for all users. The output file will display whether each user should be enabled or disabled in Veritas Alta Archiving using O365 sync logic.

1. Ensure the following modules are installed. 

* Microsoft Online Services Sign-In Assistant

* Windows Azure AD Module for PowerShell

Install-Module AzureAD

* Exchange Online Management

Install-ExchangeOnlineManagement

2. Download the attached files and copy both *.ps1 files to the same folder.

3. Run the following PS command: .\GetUserLicenses.ps1 $UserPrincipalName | export-csv GetUserLicenses_$(get-date -f yyyyMMdd_hhmmss).csv

4. Enter the O365 admin account credentials if prompted.

5. The GetUserLicenses_yyyymmdd_hhmmss.csv file will be generated with the following columns.

Note: This does not take into account provisioning via Domain or Group, it will report on all of O365.

6. Run the following commands:

 Connect-ExchangeOnline -UserPrincipalName Admin@test.onmicrosoft.com 

Note: This should be the admin account and modified for your environment. 

get-exomailbox -resultsize unlimited  | select displayname, primarysmtpaddress, userprincipalname,guid,PersistedCapabilities,MailboxPlan,HiddenFromAddressListsEnabled| Export-CSV C:\Mailboxlist.csv

7. Compare the two outputs to find any missing accounts that are not eligible to sync. The key will be license type it could well be a new license type is being employed.

NOTE: Shared Mailboxes will show up on this report as Disabled.  If you are syncing Shared Mailboxes, this report will be inaccurate to your Veritas Alta Archiving user count.