{"id":364,"date":"2015-11-20T10:51:08","date_gmt":"2015-11-20T10:51:08","guid":{"rendered":"https:\/\/www.sharepoint13.org\/?p=364"},"modified":"2015-11-20T13:26:39","modified_gmt":"2015-11-20T13:26:39","slug":"office365-useradmin-with-powershell-part-3-add-securitygroups-to-sitegroups","status":"publish","type":"post","link":"https:\/\/www.sharepoint13.org\/?p=364","title":{"rendered":"Office365 Useradmin with PowerShell –Part 3: Add DistributionGroups to SiteGroups"},"content":{"rendered":"

For easier admin of SiteGroups I like to nest  Security enabled Mail DistributionGroups from Exchange Online into SP SiteGroups. Sadly we cannot add UnifiedGroups aka \u201cOffice365 Groups\u201d. <\/p>\n

First connect to Exchange Online with PowerShell<\/a> and run
PS>Get-DistributionGroup<\/em><\/strong>  Only the SecurityEnabled DGroups are avilable to add to a SP SiteGroup
\"image\"<\/a>
Here\u2019s the PS script I used to create the DonkeyKong DistributionGroup:
PS>New-Distributiongroup -name "Donkey Kongs" -alias "DonkeyKongs" -type "security" -primarysmtpaddress "donkeykongs@vaerpn.com" \u2013members admin@vaerpn.com,randy.williams@vaerpn.com,joachim.gjertsen@vaerpn.com<\/em><\/strong><\/p>\n

The trick to add this DistGroup to a SP SiteGroup is to use \u201c-primarysmtpaddress\u201d as \u2013LoginName like this:
PS>Add-SPOUser \u2013Group \u201cAdministration Visitors\u201d \u2013LoginName donkeykongs@vaerpn.com  -Site https:\/\/vaerpn.sharepoint.com\/sites\/github<\/em><\/strong>\"image\"<\/a>
(See also Part2<\/a> \u2013 Add Users to SiteGroups, I like to use seperate .csv files)<\/p>\n

Run the PS>Get-SPOSiteGroup -Site <\/strong>https:\/\/vaerpn.sharepoint.com\/sites\/github<\/strong><\/em>
<\/em><\/strong>\"image\"<\/strong><\/a>
Notice that the SecurityEnabled Distribution lists only displaying long UID. But in SharePoint it displays friendly.
\"image\"<\/strong><\/a><\/p>\n

– Offcourse you can add \u201cnormal\u201d Microsoft Online Security Groups, in Cloud or from AD Sync \u2013 but these are not possible to mail enable,
Run PS>Get-MsolGroup<\/em>
<\/strong>\"image\"<\/a><\/p>\n

References:<\/p>\n

Using PS with Exchange Online<\/a><\/p>\n

Exchange Online cmdlets<\/a><\/p>\n

Manage Azure AD Using PowerShell<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

For easier admin of SiteGroups I like to nest  Security enabled Mail DistributionGroups from Exchange Online into SP SiteGroups. Sadly we cannot add UnifiedGroups aka \u201cOffice365 Groups\u201d. First connect to Exchange Online with PowerShell and<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[17,11],"class_list":["post-364","post","type-post","status-publish","format-standard","hentry","category-office365","tag-office-365","tag-powershell"],"_links":{"self":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts\/364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=364"}],"version-history":[{"count":6,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts\/364\/revisions"}],"predecessor-version":[{"id":380,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts\/364\/revisions\/380"}],"wp:attachment":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}