Hey All - Recently ran into an issue where a customer had AvePoint installed in the farm (Which requires the DocAve account to have db_owner) and after every CU it'd...
On 11/8/16 Microsoft made true of announcements from August 2016 and announced that Office 365 Groups with connected SharePoint Online team were now available. Link – https://blogs.office.com/2016/11/08/create-connected-sharepoint-online-team-sites-in-seconds/
The SharePoint admin inside me began to think about managing all of these new site collections/cluttering up my SharePoint Admin Center! The good news (Spoiler Alert)…It doesn’t! One of my friends (Brian Kinsella – https://www.linkedin.com/in/briankinsella) had the same question, so I decided to dig in to figure out how to get at all of these new site collections.
Most of you with an active Office 365/SharePoint Online deployment are probably familiar with the SharePoint Admin center:
I went ahead and created a new Office 365 Group called “TestO365Groups”
To do this I did the following:
- Go into the Mail App > (Under Groups) Clicked the + button
- Fill out the appropriate information (Name, Description, Privacy, etc.)
- This provisioned a site collection at following URL (I checked this by clicking the Files tab within the group) – https://mod604710.sharepoint.com/sites/testo365groups/
Now onto the concerns above!
I was not able to see this site collection in the SharePoint Admin page and I was not able access Office 365 Groups via SharePoint Online PowerShell cmdlets (Get-SPOSite)
Exchange PowerShell to the rescue! Here’s what you can do to find all those Office 365 group URL’s:
- Fire up Exchange Online PowerShell – https://technet.microsoft.com/en-us/library/jj984289(v=exchg.160).aspx
- Open PowerShell as Admin and connect to the O365 tenant using the following PowerShell:
$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Get-UnifiedGroup | select Alias, SharePointSiteUrl