Category Archives: Office 365

Sharepoint Online – Add members and owners via PowerShell

To add members and owners to a SharePoint Online TeamSite you have the below commands avaiable:

Note that if you need to make someone Owner of the Teamsite, the user first needs to be member! And then you make the user Owner.

#Get Credentials
$credObject = Get-Credential

#Connect to Exchange Online
$ExchOnlineSession = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $credObject -Authentication Basic -AllowRedirection

Import-PSSession $ExchOnlineSession

#Get Groupnames
Get-UnifiedGroup

#Check for current members
Get-UnifiedGroupLinks –Identity "groupname" –LinkType Members

#Check for current owners
Get-UnifiedGroupLinks –Identity "groupname" –LinkType Owners

#Add user as member
Add-UnifiedGroupLinks –Identity "groupname" –LinkType Members –Links info@iterrors.com

#Add user as owner (first make the user ‘member’)!!
Add-UnifiedGroupLinks –Identity "groupname" –LinkType Owner –Links info@iterrors.com

#Remove user as member
Remove-UnifiedGroupLinks –Identity "groupname" –LinkType Members –Links info@iterrors.com -Confirm:$false

#Remove user as Owner (Don’t forget to also remove the Members entry).
Remove-UnifiedGroupLinks –Identity "groupname" –LinkType Owners –Links info@iterrors.com -Confirm:$false

#Extra option, turn off the Welcome Message.
Set-UnifiedGroup "groupname" -UnifiedGroupWelcomeMessageEnabled:$false

We’ve run into a problem with your Office 365 subscription after tenant to tenant migration.

After a tenant to tenant migration multiple people got the message ‘We’ve run into a problem with your Office 365 subscription’.

I found a script wroted by someone on 365labs.net;
How to resolve “We’ve run into a problem with your Office 365 subscription” with PowerShell

So to resolve this issue you start powershell on the PC that has the problems and run the following command.
set-executionpolicy unrestricted

Then create an .ps1 file with the following code


<# .SYNOPSIS This script locates OSPP.vbs and removes all product keys to trigger O365 reactivation. It will remove ALL product keys. .NOTES File Name: Author : Johan Dahlbom, johan[at]dahlbom.eu Blog : 365lab.net The script is provided “AS IS” with no guarantees, no warranties, and they confer no rights. #>
#Check that the script runs with privileged rights
if (-not([Security.Principal.WindowsPrincipal] [Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole([Security.Principal.WindowsBuiltInRole] "Administrator")) {
Write-Warning "You need to have Administrator rights to run this script!`nPlease re-run this script as an Administrator in an elevated powershell prompt!"
break
}
#Find OSPP.vbs path and run the command with the dstatus option (Last 1...)
$OSPP = Resolve-Path -Path "C:\Program Files*\Microsoft Offic*\Office*\ospp.vbs" | Select-Object -ExpandProperty Path -Last 1
Write-Output -InputObject "OSPP Location is: $OSPP"
$Command = "cscript.exe '$OSPP' /dstatus"
$DStatus = Invoke-Expression -Command $Command

#Get product keys from OSPP.vbs output.
$ProductKeys = $DStatus | Select-String -SimpleMatch "Last 5" | ForEach-Object -Process { $_.tostring().split(" ")[-1]}

if ($ProductKeys) {
Write-Output -InputObject "Found $(($ProductKeys | Measure-Object).Count) productkeys, proceeding with deactivation..."
#Run OSPP.vbs per key with /unpkey option.
foreach ($ProductKey in $ProductKeys) {
Write-Output -InputObject "Processing productkey $ProductKey"
$Command = "cscript.exe '$OSPP' /unpkey:$ProductKey"
Invoke-Expression -Command $Command
}
} else {
Write-Output -InputObject "Found no keys to remove... "
}

Then you can launch the script via powershell and all should be fine.

Allow synchronisation of files with special characters (like # and %).

Allow synchronisation of files that include special characters in the filenames, like # and %.

Step 1; Download and install the ‘SharePoint Online Management Shell’
link: https://www.microsoft.com/en-us/download/details.aspx?id=35588

Step 2; Open the SharePoint Online Management Shell by searching for ‘sharepoint’ in your startmenu.

Step 3; Run the following command: (replace the values according to the tenant you are connecting to)

$adminUPN="info@iterrors.com"
$orgName="iterrors"
$userCredential = Get-Credential -UserName $adminUPN -Message "Type the password."
Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $userCredential

Enter the password, click OK and press ENTER.

Step 4; Run the following command:

Set-SPOTenant -SpecialCharactersStateInFileFolderNames Allowed

All done, it can take hours or even a couple of days to get the files to sync after the change.

Office365 – Create a roomlist

If you have multiple rooms in your Exchange Online environment you want to use roomlist(s).

To create a roomlist first connect to powershell:

Connect to Office 365 using Windows Powershell

To create a roomlist enter the below command:
New-DistributionGroup -Name “New RoomList” -Roomlist

You will now have a roomlist, but the list is empty. To add room’s to the list enter the following command:

Add-DistributionGroupMember -Identity “New RoomList” -Member “Room 1”

You will need to enter the above command for each room you want to add to the list.

How to turn Clutter feature on / off for all users via PowerShell

First, connect to Office365 / Exchange via PowerShell.

http://iterrors.com/connect-to-office-365-using-windows-powershell/

To turn Clutter on:
Get-Mailbox | Set-Clutter -Enable $true

To turn Clutter off:
Get-Mailbox | Set-Clutter -Enable $false

To see if it worked, you can get the Clutter status by typing:
Get-Clutter -Identity info@iterrors.com

Office 365 – How to see the creation date of a mailbox via Powershell

Open powershell as administrator and connect to office 365.

See here how to do it:
http://iterrors.com/connect-to-office-365-using-windows-powershell/

Then when connected typ in this command:
get-mailbox -id userID | select whenCreated

Office 365 – Force DirSync synchronisation / update

DirSync will automaticly update passwords every 2 minutes and other users / settings every 3 hours but sometimes you want to force it.

To do that open Windows Powershell and go to:
PS> cd “C:\Program Files\Windows Azure Active Directory Sync\Sync”
PS> .\ImportModules.ps1
PS> Start-OnlineCoexistenceSync

Thats it!

Outlook 2010 – Anonymous security option missing

When you are trying to configure Office 365 in Outlook 2010 there is a change the ‘anonymous’ security setting is missing. This will result in a setup faillure when trying to log in to office 365 account. So you can’t setup office365 via either autodiscover or manual.

To resvolve this issue i did the following:
1. Install SP1 for Outlook 2010.
2. Reboot
3. Install this patch:
http://www.microsoft.com/en-ie/download/details.aspx?id=36841
4. Install this patch:
http://www.microsoft.com/en-gb/download/details.aspx?id=29361
5. Reboot

When you try to configure office 365 in Outlook 2010 it will work!

Office365 – Incompatible Office products are installed on your machine” when opening Office.

When you try to open office documents you get ‘Incompatible Office products are installed on your machine’ error.

The solution to this error is to delete the stand-alone Microsoft OneDrive for Business 2013 sync client from add / remove a program.

Once this program is removed you can succesfully open office programs again without the error message!

Note that you may have to reinstall office365 again.

Office365 – Automatically add lync users to your lync contacts

When you have an Office 365 subscription you get access to Lync software.

If you install Lync and you want to add people to your contacts you have to manually add each user.

Currently there is no official solution to achieve an automation for this.

There is however, a workaround:

Log in to the Exchange Admin Center.
Go to ‘groups’ and create a new Distribution group.
Add every user to this group and click save.

In the Lync software you can search for the dist group you just created.
Right click the group and choose ‘Add to contact list’

You now have every user in that group as a contact!