Powershell : How to identify (and delete) specific email messages from Office 365 1

I was looking for a way to identify messages in my Outlook Mailbox and easily delete them.

First connect to Office 365 with you (admin) credentials using the LiveCred command.

Set the Execution Policy and import the commandlets.

Using the next command creates an export of all emails from the specified user in the emailbox username and puts that export in the mailbox of user target mailbox and creates an folder called Searchlogs.


In that folder you find the logging of the files specified :



Open the zip file containing the CSV export.


When you are ready to delete those files use the following command :

Now all the files from the specified user are deleted. You can also use the -subject:’subjectname” switch.


How to publish a remoteapp (Azure)

In this article I describe how to publish a remoteapp using Microsoft Azure. First login to the Azure Portal using your (admin) creds and create a RemoteApp :


After you select the +NEW button use the following steps to create a RemoteApp:


Give a name, the region you wish the data to be stored and the plan details. Notice that by default there are 3 images to choose from. In this example who use the default available. In a later post I shall describe how to use your own images. After you click Create RemoteApp Collection, your RemoteApp Collection will be created. This can take a couple of minutes. When this task is finished you see something like this :


The name, status, address and other information is displayed. Double-click this bar.

You notice this screen:


You have several options : Dashboard (this page), User Access (control which users have access), Publishing (choose which applications to publish), Sessions (see the current sessions), Scale (scale your RemoteApp)

Click publish remoteapp programs!


Now you can choose from a list of programs installed in the image you choose before. Select any of them. You see the selected program being published. You can go to the publishing menu and you see al the Apps which are published as a RemoteApp.


It’s also an option to manually enter programs when you now the exact path or any one which is listed in the start menu. Ok! We are ready to go. Let’s download the Azure RemoteApp client here. After you have installed the client, let’s start the client! Login as the user you gave access to earlier. (users) and you see something like this :


Let’s start Visio for example :


The first time to application is set up (profile etc) and so it takes a bit langer to start the application.

Et voila Visio is started! You don’t see the difference between Visio installed locally or as a RemoteApp :


Office 365, how to re-generate a new APP password

When using 2 way authentication with Office 365 you must generate app passwords when – for example – using Skype for Business. Use the following steps to generate a (new) password :

Go to the Microsoft Office 365 portal and sign in (

Go to settings (Landing page, upper right)


and choose voor Instellingen voor Office 365 (Dutch)


Choose Aanvullende beveiligingsverificatie (Dutch)


Click the link to change your settings :


Go to appwachtwoorden (Dutch)


Create an App password. You can give your password a specific name (for example Skype). The password will be random generated. Use that password in Skype.

How to check how much Office 365 Sharepoint / Onedrive for Business data is in use

October 2014 Microsoft announced unlimited storage for all Office 365 customers. In the next couple of months all accounts will be upgraded from 1 TB to unlimited storage. When you want to check how much storage your Office 365 has in use, you can check this following these steps :

First login to the Office 365 portal :


Go to the Onedrive menu :


Go to Site-instellingen (Site-settings) :


Go to site collection services :


(Dutch menu)


(English menu)

And there you see the consumed storage :


Solution for Onedrive for Business consuming a lot of Space on your local hard drive

I use OneDrive for Business to sync my files to Office 365. In my laptop I have 2 SSD drives and I want to sync these files to the 2nd SSD. So I thought that it was enough to sync my files to a folder on this drive. But I found out that when uploading many files the caching folder on the older drive (C:) is consuming many GB’s. The other problem is that Office runs slower that before because it always syncs with the cloud. The reason behind this is that Office Cache files needs to store your state of work.

I found a solution for this problem.

Step 1 – Configure Office Cache Control


Step 2 – Move your Cache Files



The above picture shows the configuration I use. (When running in capacity problems you can change the number of days to keep files in the cache)

It’s recommend that you use a SSD drive to store your Office Cache files. Therefore open regedit and navigate to : HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Internet


Create a string key value namely OfficeCacheLocation


The value is the location of your caching folder.

Restart your pc.

After rebooting navigate to C:\Users\<username>\AppData\Local\Microsoft\Office\15.0\OfficeFileCache.

Delete the files in the OfficeFileCache folder.

Onedrive for Business for Mac workaround

More and more people are using Office 365 and more and more people are using Mac computers. Unfortunately Onedrive for Business is still not available. It’s scheduled for Q3 later this year… :



But for people who are eager to upload and edit documents and files stored on Office365 there is a solution… (When you are using Microsoft Office for Mac..)

Open Microsoft Document Connection


And choose for Connect to a Sharepoint Site


And enter you Sharepoint url. Your sharepoint can be copy/pasted when going to and select onedrive. Now go to the folder you wish to sync and copy the complete url. Now paste the complete url here :


At this point you have to enter your Office 365 Credentials :


And now you are ready to go. You can upload/download your documents using Microsoft Document Connection. There are some limitations, for example you can only upload files and not complete file structures (folders with files within)

Sometimes when creating the connection you receive the following error. Just try again.


Review MigrationWiz

Because I’m doing more and more Office 365 migrations I was looking for a solution to automate this proces. I was looking for a tool that could automatically migrate mailboxen, contacts, public folders etc. Ofcourse using PST-files is one way to do it, but when you are migrating lots of data (Gb and/or users) this could take some time. I’ve heard the name BitTitan several times their product MigrationWiz seems to good to be true. I decided to ask them for a trial license to test the product.

MigrationWiz doesn’t require any special software, this because it’s all webbased. Just go to the website and login. After logging in you see the following :


First you have to create a connector. A connector is the link between your old en your new environment. Setting up a connector is an easy thing to do :


In the above picture you can any source configuration you are using, you can choose the same options in the target. So you can use MigrationWiz for the fallback scenario also.

You can also specify what to migrate :


Ofcourse you can migrate emails, but also calenders, contacts but also the rules(!) I particularly like that option because I created many rules to move incoming mails to their folders and their is no other easy way to export/import those.

After creating your first connector you can find it in the manage connector section :


In this view you can easily edit the connector, view statistics and see the mailboxes you are about to migrate.

After creating the connector you can add the mailboxes you wish to create. Their are several ways to do that. First you can manually add them :


You don’t have to have each user’s password. You can select one migration account which has access to all the exchange accounts.

Another way is to do a bulk import :


As you can see in the above screen, everything is fairly easily and their is little room for mistakes. It would be nice although if you could select the mailboxes from a list that MigrationWiz provides but that option isn’t (yet?) available.

After adding the mailbox(es) you can start the migration with the option buttons :


The first button is to start the migration, the second gives you the details, you can change the settings of delete the mailbox from MigrationWiz (not Exchange!)

After starting the migration you can see the progress in detail :







At this point you just have to wait for the mailboxes to complete. 🙂

Other thing I think are worth mentioning :

Migration Skydrive / Google Drive data :


Migration Public Folders :


It’s also possible to export all your exchange data to PST for back-up or legal reasons :



I’m very enthousiastic about MigrationWiz and I think I will testdrive their other products also. Migration maildata is easy and works as it supposed to. Some minor improvements would be nice like the option to select the mailboxes instead of importing them with one of the bulk options. I also noticed that the impact on the source exchange system is noticeable, but you can tweak the options. So look out for importing all your exchange data during daytime without looking into the tweak options.

Do you have any questions? Leave a comment!

 Functionality  [s3r star=4/5]
 Stability  [s3r star=4.5/5]
 Support  [s3r star=3.5/5]

Do you like this review? Please vote!


How to use EMC to migrate mailboxes from Exchange on premises to Office365 and vice versa

In my previous post you can read how easily it is to use the EMC to administer your Office365 account. Now you can imagine how easily it could be to migrate Exchange mailboxes from your on premises Exchange Server to Office365 or the other way around! This is how you can do that :

First open the console and select New Remote Move Request


Choose the user you wish to migrate :


Now specify the target domain and the remote database  and hit next.


Hit next and watch your mailbox fly to the cloud!

Technorati Tags: ,