My story on how I got into automation and why you should do the same in 2018.

A couple of years ago I felt that i was stuck professionally.  It didn`t  matter how hard I worked, how I proved myself. I still didn`t get any chance to climb the ladder inside the IT department I was part of. Even though I got a couple more large responsibilities I was still stuck with the … Continue reading My story on how I got into automation and why you should do the same in 2018.

Automatic update Holidays in AutoAttendant.

First of all, this can be you if you automate holiday updates in AutoAttendant with my script: A couple of days ago Microsoft realeased new features in preview for AutoAttendant. AutoAttendant in Skype for Business Online finaly have the ability to create holiday schedules! After fixing a bug that outputted wronge date values, i made … Continue reading Automatic update Holidays in AutoAttendant.

Integrating PowerShell with PowerBI: Automating in Azure (Part 3)

In this blogpost we will take a look at how to automate the process of updating the data in the Power BI report we created in part 2, without any need of a computer/server. We will manage to do this by scheduling a Runbook in Azure Automation. I asume that you allready have signed up … Continue reading Integrating PowerShell with PowerBI: Automating in Azure (Part 3)

Integrating PowerShell with PowerBI: Module, script and reporting (Part 2)

So now if you read part one, you are set to go starting using this newly created integration. (If not read part one here.) What we will take a look at in this post: - What you can do with the module. - Writing a reporting script that send data to Power BI. - Create … Continue reading Integrating PowerShell with PowerBI: Module, script and reporting (Part 2)

SharePoint LastItemUserModifiedDate

Wrote a short script that list all SharePoint sites in your Office 365 tennant with the LastItemUserModifiedDate. Could be handy to see if some sites are not used anymore. First i used Get-SPOSite and LastContentModified, but after some research it turned out that it was not so reliable: https://social.msdn.microsoft.com/Forums/office/en-US/6e264b4e-e4b4-4b46-a7b0-9686c0f6128e/lastcontentmodifieddate-is-not-giving-me-the-right-values-for-site-collections-sharepoint-online?forum=sharepointdevelopment My script is a modified version … Continue reading SharePoint LastItemUserModifiedDate