Prevent User Subscriptions to Office365 Services

Microsoft are releasing more and more application services as part of the Office365 platform. Its getting harder and harder to keep pace with the development and release cycle and new products seem to be launching month on month. Just recently we have seen the release of Microsoft Stream, Microsoft Forms, Staff Hub and Microsoft Flow […]

Blocking Office Store–Harder Than You May Think

Recently at a customer they were rolling out Office 2016 ProPlus to their early adopters. This was a significant change for the business and somewhat an experimental process. Their Information Security team had a problem with the Add-ins function within the Office applications and requested that we find a way to block Office from accessing […]

Office 2013 Click to Run Hot Desk Licencing

With the increasing popularity of Office 365 and Office 2013 Pro Plus available with E3 licencing it has rewritten the rule book on application licence activation. In the past Microsoft gave us two options of activation, KMS and MAK. KMS was a favourite amongst system administrators because of its ease of deployment and reliance on […]

Get List of Users and Associated Office 365 Licences

Just a quick memory dump for myself really. To export a report of all users from Office 365 and their associated licences run the following command in Azure Powershell Module Get-MsolUser -All | Select UserPrincipalName, Licenses | fl | Out-File c:\office365users.txt To only export licenced users Get-MsolUser -All | Where {$_.IsLicensed -eq “True”} | Select UserPrincipalName, […]

Multi Factor Authentication (MFA) Using ADFS 3.0 and Certificates

I had to implement MFA using ADFS 3.0 and internally signed certificates in order to authenticate external users against Office 365 services. There were a few niggles along the way but on the whole it was a relatively easy process to complete. The design brief stated that only domain joined devices from outside the corporate […]

Resetting Office 365 Password using Powershell

To reset an office 365 user’s password you need the Windows Azure Active Directory Module installed http://msdn.microsoft.com/en-us/library/azure/jj151815.aspx Open the console and enter Connect-MsolService Press Enter, enter your admin Office 365 account username and password in the logon box Then issue this command Set-MsolUserPassword -UserPrincipalName cphillip@domain.com -NewPassword London1234 -ForceChangePassword $false