Tag Archive: Script

Sharing Script with Github

Author: Roy Apalnes October 9, 2015 0 Comments

I have started using Github for several reason, but mainly for keeping track of my script/modules, version controlling my scripts/modules, get contribution from friends and fellow comrads, and one day, perhaps I will get a PowerShell Module accepted for Microsoft…
Read more

PowerShell, Social

git, github, powershell, Script, social

PS Script: AAD or AD?

Author: Roy Apalnes June 21, 2014 0 Comments

Complementing the PS Script by choosing either AAD or AD to hold Your Security Group and Memberships. [code language=”powershell”] #Azure Active Directory Import-Module MSOnline Connect-MsolService #Find ObjectId of every Security Group $Groups = Get-MsolGroup | Select ObjectId,DisplayName $ExchangeGroupObjectId = $Groups…
Read more

Azure Active Directory

AAD, Active Directory, AD, azure active directory, Members, ObjectId, powershell, Script, Security Group, UserPrincipalName

PS Script: Assign license based on AAD Security Group

Author: Roy Apalnes June 20, 2014 0 Comments

So, just to make it easy, here is the Exchange Online assigning script without using it for Unlicensed Users only. AAD Security Group Name: Exchange_Users See earlier post for pre reqs and information.

 .SYNOPSIS
    Script that assigns Office 365 licenses based on Group membership in WAAD.
 .DESCRIPTION

#The script assigns license Exchange Online Plan 1 or 2 based on Group Membership and that the user doesn't have a license.
#It can seem abit reverse as we enable EnterPrisePack, but disables everything but what we want to keep.
#This is just the way it works when workin with Plan Packages, compared to single Plans.
#NOTES
#Author: Roy Apalnes
#Blog: royapalnes.wordpress.com
#Email: roy.apalnes(a)gmail.com
#The script are provided “AS IS” with no guarantees, no warranties, and they confer no rights.
#Feel free to contact me for assistance.
#Modified
#Modifier: Roy Apalnes
#Blog: royapalnes.wordpress.com
#Modified for Customer X

$Office365Credentials = Get-Credential

#Connect to Microsoft Online
 Import-Module MSOnline
 Connect-MsolService -Credential $Office365credentials

write-host "Connecting to Office 365..."

#Disabled Plans for assigning Exchange Online only
 $disabledPlans= @()
 $disabledPlans +="OFFICESUBSCRIPTION"
 $disabledPlans +="SHAREPOINTWAC"
 $disabledPlans +="RMS_S_ENTERPRISE"
 $disabledPlans +="YAMMER_ENTERPRISE"
 $disabledPlans +="SHAREPOINTENTERPRISE"
 $disabledPlans +="MCOSTANDARD"

#Create a LicenseOption with ENTERPRISEPACK and disable all Plans but Exchange Online
 $ExchangeOnly = New-MsolLicenseOptions -AccountSkuId syndication-account:ENTERPRISEPACK -DisabledPlans $disabledPlans

#Country Location is mandatory for license assigning
 $UsageLocation = "NO"

#Find ObjectId of every Security Group
 $Groups = Get-MsolGroup | Select ObjectId,DisplayName

#Placeholder for our Exchange Online Security Group Object Id
 $ExchangeGroupObjectId = $Groups | where {$_.DisplayName -eq "Exchange_Users"} | Select ObjectId

#Placeholder for ObjectIds of every member of Security Group Exchange_Users
 $ExchangeGroup = Get-MsolGroupMember -GroupObjectId $ExchangeGroupObjectId.ObjectId

#Placeholder for ObjectIds of every member without a License.
 #$UnlicensedExchangeUsers = $ExchangeGroup | where {-not $_.islicensed} | Select ObjectId

#Set UsageLocation
 Set-MsolUser -ObjectId $ExchangeGroup.ObjectId -UsageLocation $_.UsageLocation

#Set LicensOption Exchange Online Only
 Set-MsolUserLicense -ObjectId $ExchangeGroup.ObjectId -AddLicenses syndication-account:ENTERPRISEPACK -LicenseOptions $ExchangeOnly

.SYNOPSIS

Script that assigns Office 365 licenses based on Group membership in WAAD.

.DESCRIPTION

#The script assigns license Exchange Online Plan 1 or 2 based on Group Membership and that the user doesn't have a license.

#It can seem abit reverse as we enable EnterPrisePack, but disables everything but what we want to keep.

#This is just the way it works when workin with Plan Packages, compared to single Plans.

#NOTES

#Author: Roy Apalnes

#Blog: royapalnes.wordpress.com

#Email: roy.apalnes(a)gmail.com

#The script are provided “AS IS” with no guarantees, no warranties, and they confer no rights.

#Feel free to contact me for assistance.

#Modified

#Modifier: Roy Apalnes

#Blog: royapalnes.wordpress.com

#Modified for Customer X

$Office365Credentials = Get-Credential

#Connect to Microsoft Online

Import-Module MSOnline

Connect-MsolService -Credential $Office365credentials

write-host "Connecting to Office 365..."

#Disabled Plans for assigning Exchange Online only

$disabledPlans= @()

$disabledPlans +="OFFICESUBSCRIPTION"

$disabledPlans +="SHAREPOINTWAC"

$disabledPlans +="RMS_S_ENTERPRISE"

$disabledPlans +="YAMMER_ENTERPRISE"

$disabledPlans +="SHAREPOINTENTERPRISE"

$disabledPlans +="MCOSTANDARD"

#Create a LicenseOption with ENTERPRISEPACK and disable all Plans but Exchange Online

$ExchangeOnly = New-MsolLicenseOptions -AccountSkuId syndication-account:ENTERPRISEPACK -DisabledPlans $disabledPlans

#Country Location is mandatory for license assigning

$UsageLocation = "NO"

#Find ObjectId of every Security Group

$Groups = Get-MsolGroup | Select ObjectId,DisplayName

#Placeholder for our Exchange Online Security Group Object Id

$ExchangeGroupObjectId = $Groups | where {$_.DisplayName -eq "Exchange_Users"} | Select ObjectId

#Placeholder for ObjectIds of every member of Security Group Exchange_Users

$ExchangeGroup = Get-MsolGroupMember -GroupObjectId $ExchangeGroupObjectId.ObjectId

#Placeholder for ObjectIds of every member without a License.

#$UnlicensedExchangeUsers = $ExchangeGroup | where {-not $_.islicensed} | Select ObjectId

#Set UsageLocation

Set-MsolUser -ObjectId $ExchangeGroup.ObjectId -UsageLocation $_.UsageLocation

#Set LicensOption Exchange Online Only

Set-MsolUserLicense -ObjectId $ExchangeGroup.ObjectId -AddLicenses syndication-account:ENTERPRISEPACK -LicenseOptions $ExchangeOnly

Azure Active Directory, Office 365

Assign, azure active directory, Enterprise, Exchange Online, Exchange Online Security Group Object, License, Microsoft Online, Office 365, Only, Package, powershell, Script, Security Group, Security Group Object

PS Script: Assign Exchange Online licenses based on AAD Security Group

Author: Roy Apalnes June 20, 2014 0 Comments

Same script edited to assign Exchange Online instead of Lync Online. AAD Security Group Name: Exchange_Users Same pre reqs and more information in my earlier post. [code language=”powershell”] <# .SYNOPSIS Script that assigns Office 365 licenses based on Group membership…
Read more

Azure Active Directory, Exchange Online

Assign, azure active directory, Enterprise, Exchange Online, License, Lync Online, Lync Online Security Group Object, Microsoft Online, Office 365, Only, Package, powershell, Script, Security Group, Security Group Object

PS Script: Assign license based on WAAD Security Group

Author: Roy Apalnes June 20, 2014 0 Comments

A lot of customers buy Package of Plans within Office 365, like Enterprise or MidSize. These Package of License Plans are just build up With the single Plans, but they don’t work the same way when assigning the Licenses With…
Read more

Azure Active Directory, Office 365

Assign, Enterprise, License, Lync Online, Lync Online Security Group Object, Microsoft Online, Office 365, Only, Package, powershell, Script, Security Group

PS: Script license assigning for Office 365

Author: Roy Apalnes June 19, 2014 0 Comments

Wanted to share a script for assigning Licenses to Office 365 Users based on Security Groups in Your local Active Directory.

#Command One - Find users in local Security Group

$LyncGroup=Get-ADGroupMember -Identity 'LyncOnline' -Recursive | %{get-aduser $_.samaccountname} | Select UserPrincipalName

#$LyncGroup is just a placeholder for every users UserPrinciplaName found in the Security Group 'LyncOnline'
 #'LyncOnline' is the local Active Directory Security Group we collect members that should have Lync Online Plan assigned.

#Command Two - Find Users in Office 365.

$users = @(Get-MsolUser -All | ? { $_.userprincipalname -like "*@apalnes.nu"  })

#$users is the placeholder for all Office 365 users in my Azure Active Directory With the UPN-suffix @apalnes.nu

#Command Three - Find User and Assign License

foreach($user in $users){

if ($LyncGroup -contains $user.userprincipalname)
 {
 write-host "Lync" $user.userprincipalname
 Set-MSolUser -UserPrincipalName $user.userprincipalname -UsageLocation NO
 Set-MSolUserLicense -userprincipalname $user.userprincipalname -Addlicenses "Apalnes365:MCOSTANDARD"
 }
 }

#For each user found in the placeholder $users Place them in placeholder $user and if that User also contains in placeholder $LyncGroup we will run the Set UsageLocation to NO (Norway) as it is mandatory for assigning a License in Office 365. And then we add the License, here represented With my tenant name and the attribute for Lync Online.

 


#Exchange Online

$ExchangeGroup=Get-ADGroupMember -Identity 'ExchangeUsers' -Recursive | %{get-aduser $_.samaccountname} | Select UserPrincipalName

$users = @(Get-MsolUser | ? { $_.userprincipalname -like "*@apalnes.nu" })
 foreach($user in $users){

if ($ExchangeGroup -contains $user.userprincipalname)
 {
 write-host "Exchange" $user.userprincipalname
 Set-MSolUser -UserPrincipalName $user.userprincipalname -UsageLocation NO
 Set-MSoluserLicense -UserPrincipalName $user.userprincipalname -AddLicenses "Apalnes365:EXCHANGESTANDARD"
 }
 }

#Command One - Find users in local Security Group

$LyncGroup=Get-ADGroupMember -Identity 'LyncOnline' -Recursive | %{get-aduser $_.samaccountname} | Select UserPrincipalName

#$LyncGroup is just a placeholder for every users UserPrinciplaName found in the Security Group 'LyncOnline'

#'LyncOnline' is the local Active Directory Security Group we collect members that should have Lync Online Plan assigned.

#Command Two - Find Users in Office 365.

$users = @(Get-MsolUser -All | ? { $_.userprincipalname -like "*@apalnes.nu" })

#$users is the placeholder for all Office 365 users in my Azure Active Directory With the UPN-suffix @apalnes.nu

#Command Three - Find User and Assign License

foreach($user in $users){

if ($LyncGroup -contains $user.userprincipalname)

{

write-host "Lync" $user.userprincipalname

Set-MSolUser -UserPrincipalName $user.userprincipalname -UsageLocation NO

Set-MSolUserLicense -userprincipalname $user.userprincipalname -Addlicenses "Apalnes365:MCOSTANDARD"

}

#For each user found in the placeholder $users Place them in placeholder $user and if that User also contains in placeholder $LyncGroup we will run the Set UsageLocation to NO (Norway) as it is mandatory for assigning a License in Office 365. And then we add the License, here represented With my tenant name and the attribute for Lync Online.

#Exchange Online

$ExchangeGroup=Get-ADGroupMember -Identity 'ExchangeUsers' -Recursive | %{get-aduser $_.samaccountname} | Select UserPrincipalName

$users = @(Get-MsolUser | ? { $_.userprincipalname -like "*@apalnes.nu" })

foreach($user in $users){

if ($ExchangeGroup -contains $user.userprincipalname)

{

write-host "Exchange" $user.userprincipalname

Set-MSolUser -UserPrincipalName $user.userprincipalname -UsageLocation NO

Set-MSoluserLicense -UserPrincipalName $user.userprincipalname -AddLicenses "Apalnes365:EXCHANGESTANDARD"

}

———————————————————————- You will find all the Licenses With this PS Command: Get-MsolAccountSku | Where-Object {$_.SkuPartNumber -eq…
Read more

Office 365

Active Directory, Active Directory Security Group, Assign, azure rms, Business, Exchange, license.office365, Lync, Office 365, OneDrive, Online, placeholder, power bi, powershell, Script, Security Group, SharePoint, Yammer

Changes coming to default address lists in Exchange Online

Author: Roy Apalnes June 5, 2014 0 Comments

From my test tenant I received this message in my Message Center. Just an FYI! On May 31, Microsoft will be implementing a change to default address lists in Exchange Online, to prepare your organization for new Groups capabilities coming…
Read more

Exchange Online

All Groups, change, default address list, Display Name Field, Exchange Online, FYI, GAL, Message Center, Microsoft, Script

PS Script is not digitaly signed

Author: Roy Apalnes January 8, 2014 0 Comments

Office 365 leverage PowerShell in a great way and if your an administrator for Office 365, this is the way to do Office 365 Administration A lot of scripts can help us use PowerShell easier, but scripts are not neccessary…
Read more

Office 365, Windows

office365, powershell, Script