This is a improvement of my reporting script from my Power BI blog series. Read these two blog posts to better understand this script and article: Integrating PowerShell with PowerBI (Part 1) Integrating PowerShell with PowerBI: Module, script and reporting (Part 2) The script reports on a large variety of different data. It can for … Continue reading Office 365 Groups reporting and Power BI visualisation

  Here are some one-liners to get various Office 365 Groups reporting/statistics. You can for example see last activity date on SharePoint, Inbox and Teams. Remember to log in to Exchange Online and SharePoint Online in the PowerShell session before running these one-liners.      

Short little script to get the totalt amount of mailboxdata and number of mailbox items in your Office 365 tenant. Shure, this could easily been done in the Office 365 services. But whats the fun in that? I did it PowerShell to learn a thing or two on the way. I even got to use … Continue reading Get mailbox data size and number of mailbox items for your tennant.

If you use the Microsoft Teams PowerShell module you can only get a list of teams your a member of, even if you are a global admin. With this little script you get a list of all Office 365 Groups and whether its Teams enabled or not. It checks if the group's mailbox contains a … Continue reading Check if Office 365 Groups is Teams enabled

Lately there have been some articles on that 10% of the internet I protected by lava lamp encryption. Cloudflare have a wall of lava lamps that theire encryption take photos of to compute a more random password. Even though their encryption algorithms is most likely never going to run out of randomnes, they added a … Continue reading Lava lamp encryption

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