SharePoint and Office 365 Architect
In this post, I want to take you with me how you can use app credentials in an Azure Automation script to connect to SharePoint Online. Many PowerShell scripts use a username and password, but these are less secure than using an app credential and can also be used to login to SharePoint Online in…
Continue ReadingA common situation in SharePoint is adding custom properties to a SharePoint profile. In an on-premises environment, it was very easy to link these properties to a property in AD. In SharePoint Online, you are not able to link these Azure AD properties. So how can we solve this? There is a very simple solution…
Continue ReadingThis week I did a presentation at DIWUG about how to use Azure Automation in combination with Office 365 I told about the possibilities of Azure Automation, what you can do with it in general and then zoomed in on specific tasks within Office 365 like setting the useslocation of your users. When you need…
Continue ReadingLast week I found out that the account name that you use in Azure automation are case-sensitive. We found this after a co-worker was adding a credential to the credentials assets. I had used some capital letters to read the account name a bit better in our local AD and my co-worker just wrote them…
Continue ReadingLast week I had the privilege to attent Microsoft Ignite in Atlanta. This week was full of news, sessions and a lot of walking. Besides the sessions, this year the expo hall was large, I have spend a lot of time at the expo talking to venders, partners and Microsoft. I have created a PDF…
Continue ReadingThis week I will attend Microsoft Ignites 2016 conference in Atlanta. To make it easier for everyone to follow me I have created a OneNote that I will use to share my notes. You can find that OneNote here: https://arjansp.nl/Ignite2016Notes
Continue ReadingI’m part of the Microsoft Heroes at Sogeti and this week we had an evening event about DevOps where I did a talk about the operations part of DevOps for Office 365. At my current customer we are preparing Office 365 for deployment to every employee in the Netherlands. So far we had moved 1000…
Continue ReadingIn my previous post I wrote about using Azure automation to start and stop an Azure VM that is deployed using Resource manager. If you did not read that one I suggest you read it first since I will use that setup and the scripts in this post. The azure automation has a great editor,…
Continue ReadingLast week I updated my Azure storage and Virtual machines to Azure Resource Manager. Before that I had the OneShare for MSDN app from Sogeti to start and stop my VM every day so I could start using it without having it to boot manually. Unfortunately the app cannot authenticate with Azure Resource Manager so…
Continue ReadingIn the trend of my recent blog post I create a new addition to my automation of Office 365 tasks. This time creating a report with the license consumption per month with PowerShell automation, Azure table storage and Power BI. In this post I will take you with me thru the steps to set this…
Continue Reading