Update

I’ve optimized the script to now only query each mailbox once and have increased the speed in this customer’s environment for On-premise from 1 minute 49 seconds to 26 seconds. The Office 365 code was optimized similarly and went down from 22 minutes 14 seconds to 7 minutes 21 seconds.

The output of the optimized script is identical to the original one.

Intro

As the title suggest, I had a customer asking for a list of all email addresses within the company and the accompanying mailbox sizes.

Hi all,

As I had mentioned in my previous post, I gave a presentation last week at the Dutch PowerShell UserGroup [DuPSUG] about PowerShell Remoting.

It was my first time presenting in front of a crowd [approximately 55] which weren’t my colleagues [and even there at max like 10-15 people] or a handful of customers, so to say the least I was quite anxious.

Thanks to some great tips by Jeff Wouters and Ben Gelens I made it through and when clicking to the second slide I went into automatic pilot mode 🙂

I’m happy to be able to say to that tomorrow I’ll be giving my first presentation on the Dutch PowerShell User Group!

Along with  Mark van de Waarsenburg,  Erik Heeres, Erik van der Plas and Danny den Braver we’ll be trying to spread the gospel of PowerShell amongst the interested people 🙂

My seminar will be focused on PowerShell Remoting - Practice & Theory and will feature a few labs along the way. I expect to post a few of the components, along with slide deck and scripts used on the site

Ever had the need to remove all but the last X amount of copies of a back-up?

And I’m not talking about the copies from the last 2 days, because this can cause issues if the files aren’t created daily [in case of a weekend], in case a back-up has failed in the meantime or if multiple back-up copies have been made in one day.

While at first I was always playing around with the simple solution by checking file age, I ran into a more elegant solution I’d like to share with you.

In one of my previous blog posts, I had a CSV worth of content in which I wanted to change a specific field of data.

I was racking my brain on how I could best approach this and while working on this, I kept getting a better and cleaner result, but every step approached the issue a bit different, even though the output was as required.

Requirements

I have a CSV file which contains the following headers

As mentioned previously in my first part of this Get-Date series, I had run into some issues that were seemingly easy to resolve, yet proved to be a bit more hassle than expected.

Funny enough, the second issue where I ran into date issues was just a day or so apart from the first, so I thought I’d resolve my issues with the knowledge I had obtained previously.

The Problem

I had received an Excel sheet which contained various information, one column being Warranty dates. Now the issue was that the Excel sheet was generated on a system which had NL-NL Culture configuration, while my machine is running on EN-US configuration.