How to split CSV file into multiple files using PowerShell

In various situations you may find that you need to evenly divide a large CSV file into multiple smaller files.

This may be the case, for instance, when you are preparing a staged migration and need to divide a list of mailboxes into batches, but not only then.

Split CSV file into multiple files using PowerShell

Luckily, splitting CSV files is exteremely easy to achieve using PowerShell.

Continue reading ‘How to split CSV file into multiple files using PowerShell’

Secure Exchange migration – keep your data safe

Exchange server migration is a complex process. It requires much preparation and planning. One of the main issues of concern during the transition is security. Administrators are well aware of how important it is to ensure confidential information is safe at all times, so that there is no data loss or leaks. Microsoft provides its clients with native tools used for migrations, but administrators often choose third party products in order to manage migration process. It is good to know why such a choice is made.

secure on-premise exchange migration

Continue reading ‘Secure Exchange migration – keep your data safe’

How to export users from Active Directory

You might need to export users from Active Directory in more than one situation. Good examples include Exchange migration and creating a test Exchange environment. You can imagine how painful it would be to do those tasks manually, especially in a large organization. Luckily, users can be exported easily from Active Directory and saved into a CSV (comma separated value) file. In this article I am going to show you how to do it.

Before we start, a quick word on the CSV files which are used to save users’ data. Lists created in this file format have headers in the first row. Those headers correspond to the names of AD users’ attributes. Below the headers, a list of users begins, each row for one user. Users’ attributes are sequenced exactly as in the headers. It is important to know that not all attributes have to be filled. However, if you want to leave certain fields blank, you should stick to the order from the first row. You can edit CSV files using e.g. notepad or Excel. Keep in mind that Excel is much better in this case, as it allows filling many fields at once with the same value. Besides, tables are much better at organizing data, which will come in handy.

Below, you have three different methods you can use to export users from Active Directory. Every single method results in creating the same CSV file. If you can use PowerShell, we highly recommend the last method, as it is the quickest one.

Continue reading ‘How to export users from Active Directory’

Exchange/Office 365 Hybrid Configuration Wizard – step by step guide

Deploying a hybrid environment is one of the most complicated tasks a system administrator faces during migration to Office 365. It might take weeks of collecting data about the infrastructure, reading publications, planning migration stages and testing. What is more, even with all this effort, there is no guarantee that everything will turn out just fine. This article gives a step by step guide to getting through the Exchange/Office 365 Hybrid Configuration Wizard (HCW). After that, I give an insight into what actions the HCW performs in the background. Finally, the last section is a guide on how to analyze logs and solve problems connected with deploying a hybrid environment.

To go straight to an activity performed by Hybrid Configuration Wizard, click on one of the links below:

  1. Validating On-premises and Online Exchange Connection
  2. Collecting data about Exchange configuration from the on-premises Active Directory
  3. Collecting information on the Exchange online (Office 365) configuration
  4. Creating new Federation Trust and the required certificate in the local Exchange
  5. Creating new Hybrid Configuration Object in the local Active Directory
  6. Changing settings of on-premises Exchange server
  7. Configuring Organization Relationship between the local server and the cloud
  8. Setting connectors on both Exchange servers
  9. Enabling MRS Proxy
  10. Configuring Oauth

Continue reading ‘Exchange/Office 365 Hybrid Configuration Wizard – step by step guide’

How to change language in Office 365 portal in hybrid environment?

Although this may sound as no big thing, changing the language in hybrid environments can actually be far from obvious. Let’s assume that your company integrated on-premises Exchange infrastructure with Exchange Online to accomplish a certain business purpose. In practice, it means that user accounts from local Active Directory are synchronized to Office 365, e.g. to ensure better user experience and improve productivity. Once the accounts are synchronized, users can work with various applications available in the Cloud from actually any place in the world.

When you log in to Office 365 portal for the first time, you may want to change some settings to personalize the user experience. If the portal displays text in the non-native language, this perhaps will be the first thing you would like to adjust – changing the language.

Continue reading ‘How to change language in Office 365 portal in hybrid environment?’

How to sync on-premises Active Directory to Azure Active Directory with Azure AD Connect?

Synchronizing users’ identities between local and cloud directories is a great way to let users access different resources on both on-premises and cloud environments with just a single set of credentials. To achieve that, you need to use Azure AD Connect to integrate your on-premises Active Directory with Azure AD.

In this article, you will find some guidance on how to use Azure AD Connect to sync on-premises Active Directory with Azure Active Directory.

Azure AD Connect

Azure AD Connect is a tool that connects functionalities of its two predecessors – Windows Azure Active Directory Sync, commonly referred to as DirSync, and Azure AD Sync (AAD Sync). Azure AD Connect will be now the only directory synchronization tool supported by Microsoft as DirSync and AAD Sync are deprecated and supported only until April 13, 2017.

Continue reading ‘How to sync on-premises Active Directory to Azure Active Directory with Azure AD Connect?’

How to block sending out-of-office messages on Exchange Server for external recipients?

Sometimes you may need to prevent auto-reply messages from being sent to people outside of your organization. No matter what the reason is for such a setting, you can quickly block out-of-office messages (OOF) directly on the Exchange Server. This way you can ensure that all users in your organization have the out-of-office messages blocked for external recipients.

This article explains how to set up a mail flow rules to stop auto-replies from being sent outside Exchange 2016 and 2013, 2010 and 2007 organizations.

Continue reading ‘How to block sending out-of-office messages on Exchange Server for external recipients?’

How to grant full access permissions to all users’ mailboxes using PowerShell

There are many situations in which permissions to another user’s mailbox should be granted on Exchange Server. Sometimes it is for monitoring purposes, sometimes in order to send emails on behalf of someone else. Full access permissions give the highest level of access to a mailbox, and are necessary, for example, during a migration process. If you want to learn how to set full access permissions on Exchange 2007, Exchange 2010, or Exchange 2013, you have come to the right place.

how to access all users' mailboxes using PowerShell

If you  want to learn more about how to perform an Exchange server to Office 365 migration using native means, check this article.

Continue reading ‘How to grant full access permissions to all users’ mailboxes using PowerShell’

Available scenarios of Exchange to Office 365 Migration

With the popularity of Office 365 constantly growing, there are few administrators who did not at least consider moving from their on-premises Exchange server to Microsoft’s Cloud. Especially now, when the extended support for Exchange 2007 is inevitably going to end in 2017, Exchange to Office 365 migration is likely to be a common topic. As moving mailboxes is never an easy task, there are quite a few consequences which have to be taken into consideration before jumping into the new environment.

First of all, you have to remember that Office 365 has some storage limits which have to be taken into consideration. All mailboxes types, including public folders and shared mailboxes, can store up to 50 GB of data. If in your organizations there are public folders or mailboxes which exceed this size, you might want to archive some content.

Secondly, moving to Office 365 requires the source and target environment to be thoroughly prepared before the migration proper can be started.

There is a number of native options available for those who wish to move from their on-premises Exchange to the Online version:

  • Cutover Migration
  • Staged Migration
  • Hybrid Deployment*
  • Office 365 Import Service

*Does not apply to Exchange 2007 and older versions

Continue reading ‘Available scenarios of Exchange to Office 365 Migration’