Overview of importing PST files and SharePoint data to Office 365

 

You can use the Office 365 Import service to bulk-import PST files to Exchange Online mailboxes in your Office 365 organization. You can also use the Import service to bulk-import documents and other data from your on-premises organization to SharePoint Online and OneDrive for Business sites.

How to import data to Office 365

There are two ways that admins can import PST files and SharePoint data to Office 365.

Cloud uploadNetwork upload Upload the data files over the network to a temporary storage location in the Microsoft cloud. Then you use the Office 365 Import service to import the data to mailboxes or sites in your Office 365 organization.
Hard diskDrive shipping Copy the data files to a BitLocker-encrypted hard drive and then physically ship the drive to Microsoft. When Microsoft receives the hard drive, data center personnel upload the data to a temporary storage location in the Microsoft cloud. Then you use the Office 365 Import service to import the data to mailboxes or sites in your Office 365 organization. Drive shipping is a good way to import data to OneDrive for Business sites.

See one of the following topics for the step-by-step instructions for importing PST files or SharePoint data to Office 365.
Continue reading

Office 365 Ports

Below are the ports required for Office 365

Purpose

Credentials Used

Source

Source Port

Destination

Destination Port

Office 365 Portal and help content

Logged on user

Client computer

Ephemeral Ports

Portal.office.com

Home.office.com

*.office365.com

*.office.com

*.office.net

TCP 80 & 443

Authentication and support services

Logged on user

Client computer

Ephemeral Ports

*.microsoftonline.com

*.microsoft.com

*.live.com

*.windows/net

TCP 80 & 443

CDNs used for portal authentication

Logged on user

Client computer

Ephemeral Ports

*.microsoftonline-p.com

*.microsoftonline-p.net

*.microsoftolineimages.com

*.msecnd.net

TCP 80 & 443

CDNs used for portal authentication

Logged on user

Client computer

Ephemeral Ports

*.msocdn.com

TCP 80 & 443

Default tenant namespace (mail routing)

Logged on user

Client computer

TCP 80,25 & 443

*.onmicrosoft.com

TCP 80,25 & 443

Global DNS LBS

Logged on user

Client computer

TCP 80 & 443

*.glbdns.microsoft.com

TCP 80 & 443

Azure AD (MFA)

Logged on user

Client computer

Ephemeral Ports

*.phonefactor.net

TCP 80 & 443

Certificate Revocation list

Logged on user

Client computer

TCP 80 & 443

TCP 80 & 443

Azure Rights Management

Logged on user

Client computer

Ephemeral Ports

*.aadrm.com

*.azurerms.com

*.cloudapp.net

TCP 80 & 443

DirSync

Machine^ &Service Account

DirSync Server

TCP 80 & 443

*.microsoftonline.com

*.windows.net

+Certificate Revocation List

TCP 80 & 443

Azure AD Connect

Service Account

Azure AD Connect Server

TCP 80 & 443

*.microsoftonline.com

*.windows.net

+Certificate Revocation List

TCP 80 & 443

STS ADFS Proxy Server

None

Client Computer

TCP 443 w/clientTLS

ADFS Proxy

TCP 443 w/clientTLS

ADFS Proxy

None

ADFS Proxy (WAP)

TCP 443

ADFS Proxy

TCP 443

Working with Azure Storage Tables from PowerShell

Azure Storage Tables is one of the four Microsoft Azure Storage abstractions available (Blobs, Queues and Azure Files are the other ones) at the time that this blog was written. It is basically a way to store data in a structured way on a non relational database system (meaning, not an RDBMS system).

Since up to today there are no official cmdlets to support entity/row management inside the tables from Azure PowerShell module, I decided to create this simple module to help IT Pros to leverage this service without having knowledge of .NET framework through some simple cmdlets as follows:

 

Cmdlet Description
Add-StorageTableRow Adds a row/entity to a specified table
Get-AzureStorageTableTable Gets an Azure Storage or Azure Cosmos DB table
Get-AzureStorageTableRowAll Returns all rows/entities from a storage table – no filtering
Get-AzureStorageTableRowByPartitionKey Returns one or more rows/entities based on Partition Key
Get-AzureStorageTableRowByColumnName Returns one or more rows/entities based on a specified column and its value (equal comparison operation)
Get-AzureStorageTableRowByCustomFilter Returns rows/entities from a table based on customer filtering
Update-AzureStorageTableRow Updates a specified table row/entity
Remove-AzureStorageTableRow Removes a specified table row

Continue reading

An Overview of Windows as a Service

With Windows 10, Microsoft made the shift to delivering Windows as a service which introduces a new way for how it’s built, deployed and serviced. In the next five minutes, Michael Niehaus will demystify the core components of the Windows as a service model. The build release process and update cadence as well as review the upcoming enhancements that further streamline the model.

SOF Quality User Experience Release Launch Blog – Jan 16th 2017

The SOF team are pleased to announce the availability of the SOF Quality User Experience release.

The SOF Quality User Experience release provides guidance on how to measure key metrics that inform customers and partners of the quality and reliability their users are receiving. The assets provide guidance on how to set the Operational team up for success leveraging these key metrics to get to and maintain a quality end user experience.
Continue reading