Migration, SharePoint

The Microsoft SharePoint Migration Tool v2 is now Generally Available

Last month we announced open beta for the next generation of the SharePoint Migration Tool with new capabilities to include support for SharePoint Lists, programmatic destination site creation and more.  Today we’re pleased to announce this version (v2) of the SharePoint Migration Tool is now generally available.

The SharePoint Migration Tool is designed to simplify your journey to the cloud through a free, simple, and fast solution to migrate content from on-premises SharePoint sites and file shares to SharePoint or OneDrive in Office 365.  The SharePoint Migration Tool allows you to accelerate your journey to Office 365 overcoming obstacles typically associated with migration projects.  With the SharePoint Migration Tool you can evaluate and address the information that matters the most to your organization, the Libraries, and now Lists that form the foundation of the SharePoint experience.  Using the SharePoint Migration Tool you can start your migration today and take advantage of the full suite of features and security capabilities that Office 365 offers.

Keep reading to learn more about what’s new in v2 or download now at https://aka.ms/SPMT.

Getting Started

You can download the SharePoint Migration Tool at http://aka.ms/SPMT.  Through v2 of the SharePoint Migration Tool you’ll have available to you the innovation we’re delivering to help you bring your information to the cloud and take advantage of the latest collaboration, intelligence, and security solutions with Office 365.

What’s new in V2

List Support

New List support allows you to migrate SharePoint Server 2013 Lists to include the following List Templates:

  • GenericList
  • DocumentLibrary
  • Survey
  • Links
  • Announcements
  • Contacts
  • Events
  • Tasks
  • DiscussionBoard
  • PictureLibrary
  • XMLForm
  • GanttTasks
  • Posts
  • Comments
  • Categories
  • MySiteDocumentLibrary
  • IssueTracking

New On-Premises AuthN Support

Improvements in the AuthN support now allow you to connect to more on-premises sources with support for AD FS and more, to include:

  • NTLM
  • Kerberos
  • Forms
  • ADFS
    • MFA
    • SAML Claims
  • Client certificates

Site Structure Creation

Now when migrating your on-premises Lists and documents the SharePoint Migration Tool will create the source site collection or the list for you if it doesn’t already exist, so you don’t have to manually create a destination site. Simply either enter a URL that exist or a valid new URL for the site and the tool will do the rest.

JSON Support

In the current version of the SharePoint Migration Tool you were limited to CSV as a repository for bulk migrations, now on top of supporting a CSV format for automated migration we will also support JSON which will allow you even more fine grain level of control.

What’s next…

Through continued innovation across migration scenarios we’ll be adding more capabilities over time to the SharePoint Migration Tool, including support for more SharePoint versions, site structure migrations, and more.  Subscribe here to stay up to date on future announcements for SharePoint and Office 365.

Wrapping Up…

Whether you’re looking to migrate from file shares on-premises to SharePoint or OneDrive or from on-premises versions of SharePoint, the SharePoint Migration Tool is designed to support the smallest of migrations to large scale migrations with support for bulk scenarios.

Learn more about the SharePoint Migration Tool at https://support.office.com/en-us/article/Introducing-the-SharePoint-Migration-Tool-9c38f5df-300b-4adc-8fac-648d0215b5f7.

Prepare your environment for migration using the SharePoint Migration Assessment Tool by learning more at https://www.microsoft.com/en-us/download/details.aspx?id=53598.

The SharePoint Migration assessment tool is a simple command line executable that scans the contents of your SharePoint farm to help identify the impact of migrating your server to SharePoint Online with Office 365.

Events, Hybrid, Migration, SharePoint, SharePoint Conference

Hybrid SharePoint & Office 365 Learning Opportunities at SharePoint Conference North America

Attending SPCNA? Come learn about hybrid scenarios with SharePoint and Office 365 in a post-conference workshop.

As an attendee of the workshop you’ll receive a $500.00 Azure Pass, a complete SharePoint Server 2016 environment and an Office 365 Tenant that you can use to build your skills and complete hands on labs, both while at the workshop and even after the event. If you’ve already registered for the conference you can add the workshop to your registration by creating a new workshop-only registration at http://sharepointna.com/.  If you register for this workshop before May 21st, you’ll receive an additional $200.00 off of the workshop registration when using the Discount Code HYBRID. If you haven’t registered for the conference, there’s still time left. Visit http://sharepointna.com/ for details and use the Discount Code HYBRID to save $200.00 off of the conference pass.

Space is limited to 100 so add or register today.

Workshop Details:

Ramping up with Microsoft SharePoint Server & Office 365 hybrid scenarios


  • Neil Hodgkinson
  • Jason Himmelstein
  • Bill Baer
  • Aimme Triplett

This workshop will have hands-on labs. Bring your own fully charged laptop.

Cloud computing has become a popular way to reduce capital and operational expenditures, renew IT innovation, and gain the advantage of more rapid software delivery to meet the needs of business. However, compliance, data sovereignty, sensitivity concerns, or a significant investment in customization may limit your organization’s ability to take advantage of this. Today you can maximize your on-premises investment by upgrading to SharePoint Server 2016 and using hybrid scenarios in Office 365 to seamlessly leverage the cloud. This workshop is designed to give you the deep technical knowledge to deploy SharePoint Server 2016 as well as design and implement the latest hybrid scenarios including search, auditing, taxonomy and more.

Attendees will receive instructor led training on best practices for implementing a variety of hybrid scenarios and workloads, training materials, to include documentation and presentations and a dedicated lab environment including a SharePoint Server 2016 farm and an Office 365 Tenant that can be used to complete hands on labs during and after the event.

Administration, OneDrive for Business, Security and Compliance, SharePoint

Unmanaged Device Access Policies are Generally Available

In March 2017 we introduced device-based policies for SharePoint and OneDrive, that enable administrators to configure Tenant-level policies.

Device-based access policies for SharePoint and OneDrive help administrators ensure corporate data is not leaked onto unmanaged devices such as non-domain joined or non-compliant devices by limiting access to the content to the browser, preventing files from being taken offline, printed, or synchronized with OneDrive.

On September 1st, 2017 we continued to evolve our conditional access investments to address the ever-changing security landscape and business needs by introducing new levels of granularity with conditional access that allow administrators to scope device-based policies at the site collection level.  In addition, this granular policy can be configured to allow users on unmanaged devices to edit Office Online documents in the browser.

Today we’re pleased to say that these policies are now available worldwide, in addition to new site-scoped policies that are available with this update.  This is our major milestone in the conditional access policy journey in SharePoint and OneDrive.

In a world that’s mobile, social, and about getting things done you’re expected to manage a growing number of devices, both managed and unmanaged that can access corporate content.  The corporate boundary as a result, has shifted from the firewall to the employee.  The need for protecting access from the unmanaged devices is ever increasing. This unmanaged device access policy is the right solution for your need.

What’s new in this update?

In this update to device-based policies at the site collection level you can:

  • Blocks users from accessing sites or the tenant from unmanaged devices
  • Allows users to preview only Office file types in the browser
  • Allows office file types to be editable or read-only in the previewer
  • Based on the sensitivity of a site’s contents, admins can now set access control from unmanaged devices on different sites to be full access, limited access, or block access

In the demonstration above, the Tenant is configured with a permissive device access policy, allowing full access from unmanaged devices to include desktop apps, mobile apps, and browsers.  The Marketing site inherits the policy configured at the Tenant; however, the Legal site has a policy configured less permissive than that configured at the Tenant level.  In addition, members of the Marketing site, while limited to browser only access on unmanaged devices, can continue to edit content they have access to provide a seamless collaborative experience.

Configuring Device Access Policies Overview

For complete instructions on enabling device-access policies refer to the support documentation at https://support.office.com/en-us/article/Control-access-from-unmanaged-devices-5ae550c4-bd20-4257-847b-5c20fb053622?ui=en-US&rs=en-US&ad=US.

Unmanaged device access policies can be configured with SharePoint Online Management Shell.

Before you get started using PowerShell to manage SharePoint Online, make sure that the SharePoint Online Management Shell is installed and you have connected to SharePoint Online.


The Tenant-level device-based policy must be configured to Full Access prior to configuring site-scoped policies.

  1. Connect-SPOService -Url https://<URL to your SPO admin center>
  2. $t2 = Get-SPOSite -Identity https://<Url to your SharePoint online>/sites/<name of site collection>
  3. Set-SPOSite -Identity $t2.Url -ConditionalAccessPolicy AllowLimitedAccess

The following parameters can be used with -ConditionalAccessPolicy AllowLimitedAccess for both the organization-wide setting and the site-level setting:

-AllowEditing $false Prevents users from editing files in the browser and copying and pasting file contents out of the browser window.

-LimitedAccessFileType -OfficeOnlineFilesOnly Allows users to preview only Office files in the browser. This option increases security but may be a barrier to user productivity.

-LimitedAccessFileType -WebPreviewableFiles (default) Allows users to preview Office files and other file types (such as PDF files and images) in the browser. Note that the contents of file types other than Office files are handled in the browser. This option optimizes for user productivity but offers less security for files that aren’t Office files.

-LimitedAccessFileType -OtherFiles Allows users to download files that can’t be previewed, such as .zip and .exe. This option offers less security.

External users, because they most likely use unmanaged devices, access will also be controlled when you use conditional access policies to block or limit access from unmanaged devices. If users have shared items with specific external people (who must enter a verification code sent to their email address) and you want those external users to access shared items from their devices, then you can exempt them from this policy by running the following cmdlet.

Set-SPOTenant -ApplyAppEnforcedRestrictionsToAdHocRecipients $false


    1. This feature has a dependency on Azure Active Directory Conditional Access Policy.
    2. To learn more about Azure Conditional Access policies work, refer to https://docs.microsoft.com/en-us/azure/active-directory/active-directory-conditional-access-azure-portal.


As workforces become more globally distributed and the productivity barrier extended beyond the firewall, device-access policies allow you to provide a seamless collaborative experience across an array of devices, both managed and unmanaged, while keeping your most sensitive content that way.  To learn more about security and compliance with SharePoint & OneDrive visit https://aka.ms/SharePoint-Security.

Migration, OneDrive for Business, Security and Compliance, SharePoint

A new customer resource for SharePoint and OneDrive security and compliance news, training, and more

Security is at the heart of what we do…

Microsoft has been building enterprise software for decades and running some of the largest online services in the world. We draw from this experience to keep making SharePoint and OneDrive more secure for users, implementing and continuously improving security-aware software development, operational management, and threat-mitigation practices that are essential to the strong protection of your services and data.

Today we’re pleased to announce a new resource center where you can get the latest news on our security and compliance investments for SharePoint and OneDrive in addition to presentations, free training, eBooks and more.

Check out our new resource center at https://aka.ms/sharepoint-security to learn how we provide security you can trust and control you can count on. As always, we want your feedback on what you’d like to see and how we can improve these resources. Let us know what you think at secfeedback@microsoft.com.

Administration, Security and Compliance, SharePoint

Coming soon to the new SharePoint Admin Center

In May 2017 we unveiled our plans [https://techcommunity.microsoft.com/t5/SharePoint-Blog/Introducing-the-new-SharePoint-Admin-Center/ba-p/70294] to simplify SharePoint administration through delivering an administrative experience that’s intuitive, intelligent, and simple.  Since then we’ve made available the new admin experience as Preview for customers who have enabled Targeted Release at the Tenant level.  In the next several weeks in our preview we’ll be introducing new updates on our journey to deliver an administrative console designed to help IT achieve more, so their users can achieve more.

Improvements to Site Management


New export capabilities allow you to export the displayed information in Site Management to CSV on both PC and Mac.  Using this output you can now use popular tools such as Microsoft Excel and PowerBI to simplify data prep, drive ad hoc analysis, and create dynamic charts and graphs.

Custom Views

In the upcoming updates you’ll now be able to customize views based on your individual preferences in addition to updating and customizing the default view of sites and related information.

NOTE Views you create are shared across all admins on the new SharePoint admin center.

Search Improvements

If you have hundreds or even thousands of sites, they can be difficult to discover through a single view.  New search improvements will allow you to search across Site Management to find the right information when you need it whether searching by site name, Url, or the primary admin.

Site-Level Sharing for Standalone Sites

SharePoint was born on the concept of sharing and now we’re bringing that core principle to SharePoint admin center by enabling management of site level sharing settings for non-group-connected sites. We will follow this shortly with support for group-connected sites, and also support for advanced sharing settings. In case you’re wondering, yes, we are working on a new tenant-level sharing page.

Improved Email Layout

We’re also updating the email layout when contacting site administrators through the SharePoint admin center to make it cleaner and easier to read.

These updates will begin rolling out to Targeted Release in 4-8 weeks.

We’re looking forward to the ongoing feedback. Use the feedback button at the bottom right of the new UI.  Also, if you see a survey that pops up and asks you how you feel about the new site, don’t be shy, let us know.


Manage sites in the new SharePoint admin center [https://support.office.com/en-us/article/manage-sites-in-the-new-sharepoint-admin-center-d8c63491-0410-405c-880a-8cef7fa4480a?ui=en-US&rs=en-US&ad=US]

Events, SharePoint, SharePoint Conference

SharePoint Conference North America has it all, and MORE!

SharePoint Conference North America has it all, and MORE!

Get more by registering NOW! http://tiny.cc/SPCNA_REG


There are 4 main reasons why people attend technical conferences and the SharePoint Conference North America (SPCNA) has all of them, and MORE!

  1. With the constantly changing world of technology, people need to know what’s new before the competition does. SPCNA has the sessions and workshops to keep you ahead of the curve.
  2. Learning with the best of the best from Microsoft and top industry thought leaders from engineering and marketing. Attendees want to hear the practical solutions from the people who actually designed, built and integrated today’s current technologies. SPCNA has the best speakers.
  3. Network and connect with peers and business technology gurus with an opportunity to share, collaborate and understanding the creation of real world solutions.
  4. Location! The host hotel is the world renowned MGM Grand. When you aren’t engaged with sessions, receptions and parties, there is an endless line-up of shows, restaurants and activities for every taste.

BONUS, When you register for one of our workshop packages, take home an Xbox One X, an Xbox One S or an Invoke by Harman Kardon, FREE.

It’s pretty simple, SPCNA has it all. WE want you to BE THERE!

OneDrive for Business, Security and Compliance, SharePoint

DLP Policy Tips are now available across new endpoints in Office 365

This summer we introduced a consistent, coherent sharing experience across the Web and desktop – these improvements allow you to share Office 365 files directly from File Explorer on PC and Finder on Mac, in addition to the latest versions of Office on the desktop and Office 365 web experiences. The updates we made provide a simplified sharing experience, so you can share files and folders easily with partners both internal and external, while retaining the right level of security – so whether you share on the web, in Explorer on Windows 10 and Windows 7, or Finder or the Mac, the sharing experience is secure, consistent and simple.

While we’ve made the sharing experience consistent across these endpoints we also understand that data loss and leakage are non-negotiable and to comply with business standards and industry regulations, organizations need to protect sensitive information and prevent its inadvertent disclosure.

To ensure your sensitive data remains that way we’re excited to announce that we’ve extended sharing to include DLP policy tips across OneDrive, SharePoint, Word, Excel and PowerPoint on PC, Mac and Web, so whether you’re working on the web or the desktop, you can remain informed with a consistent policy tip experience as you share files.

SharePoint Online

Microsoft Word


By bringing DLP policy tips into the sharing experience you can both block the sharing action as well as use the sharing dialog as a platform to help understand why an is action is blocked regardless of where you’re working.

Learn more about DLP in Office 365 at https://support.office.com/en-us/article/Overview-of-data-loss-prevention-policies-1966b2a7-d1e2-4d92-ab61-42efbb137f5e.

For more information on sending policy notifications and policy tips see https://support.office.com/en-us/article/Send-email-notifications-and-show-policy-tips-for-DLP-policies-87496bc5-9601-4473-8021-cb05c71369c1.