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.
Here is a short office Advent calendar drawing script. It demonstrates some basic concepts in PowerShell scripting: - Creating a arraylist. - Subtracting from a arraylist. - Creating a function. - Simple If/Else statement. - Counting number of objects in a variable. - Get-Random. Im not going to go into dept about the concepts, but … Continue reading PowerShell Advent calendar
As i have started to advance my PowerShell skills, il share what common error i came upon in the beginning. Not knowing some of these can create some confusion and frustration. Please comment below any other tips you have for other beginners. Variable scope. If you write a script that contains a function, and you … Continue reading PowerShell: Beginner pittfalls
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.
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)
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)
Power BI is a extremely powerful data and visualization tool. It have opened a new world for me. But the first thing i always think about when taking a look at Microsoft products, there have to be a way to control this with PowerShell. I did not find any good information about any PowerShell module … Continue reading Integrating PowerShell with PowerBI (Part 1)
I see on Tech Community there have been some requests regarding the call que timeout in Skype Online. The minimum time you can set is 60 seconds, before the call is passed on to somewhere else. I have seen some requests that people need/want to set the timeout to less than 60 seconds. In the … Continue reading Call que timeout, less than a minute?
Short script that gets all the users in your Office 365 tenant, and finds the password age. Creates a list with UPN and password age, then sort by oldest password. Also finds the average password age for your tenant.
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