Blog Archive

Office 365 E5 Plan

We should be used to Microsoft announcing new capabilities and investments in Office 365 but December 1st marked two extraordinary launches.

Firstly, a brand new Office 365 plan called E5.  This joins the current enterprise plan line up of E1, E3 and E4 and becomes Microsoft’s new ‘hero’ plan.  We’ll cover what it contains in a moment.

The second extraordinary launch is Microsoft is becoming a telecommunications provider (or simply telco in modern syntax).  Microsoft has extraordinary capacity in its global data network and is putting it to good use by offering PSTN conferencing and PSTN calling plans for Skype for Business.

Before you worry that Microsoft will start making adverts starring Maureen Lipman about ‘ologies, these PSTN capabilities are aimed squarely at organisations rather than consumers at this point.

What do I need to know from the December launch?

The key new features and capabilities are below.  There’s a post on Microsoft’s Volume Licensing site covering how to licence Office 365 E5 and the standalone features.

 

Microsoft Office 365 Plan Features

 

PSTN Conferencing

PSTN Conferencing (Public Switch Telephone Network) offers audio conferencing within Skype for Business web conferences.  If people can’t connect to a conference over the internet, it’s nice to give them a phone number so they can dial-in and listen to the audio.  Currently you need to set up an account with one of the audio conferencing providers in the Office 365 Marketplace, or have on-premises Mediation Servers and PSTN gateways.

Dial-in conferencing allows meeting attendees to dial into Skype meetings through a local phone number and in the near-future, a Freephone number (when consumption billing is released for Office 365).

Dial-out conferencing enables presenters in the web conference to add others to the meeting by dialling their phone number.  It also allows attendees to join the audio portion of the meeting by asking Skype for Business to call them on a specified phone number.

Cloud PBX

PBX stands for private branch exchange and is the internal phone system an organisation uses.  Cloud PBX can offload that requirement entirely to the cloud, or connect cloud PBX to an on-premises PBX in hybrid configurations.

It includes all the features you’d expect including calling by name & number from Softphones, IP Phones and mobile devices, Call History & Redial, Call Hold/Retrieve, Transfer, Forwarding, Call Waiting, Simultaneous Ring, Team Calling, and so on.

Like the rest of Office 365, updates are delivered over the cloud so customers can avoid the headache of upgrading their on-premises PBX.  A notable update in the pipeline will be PBX features for call centres.

Cloud PBX can be connected to the PSTN through two different capabilities.  First, a customer can purchase a PSTN calling service add-on to Office 365, available initially in the US only.  Alternatively, a customer can use Skype for Business software on-premises to provide PSTN connectivity.

PSTN Calling

Which brings us nicely onto PSTN Calling.  This is an add-on to Cloud PBX that provides national and international calling services directly from Office 365.  Instead of a customer contracting with a traditional telco and using an on-premises IP-PBX, they can purchase the Cloud PBX from Microsoft and add on PSTN Calling for a complete enterprise telephony experience for end-users.

So Microsoft is becoming a regulated carrier in each geography that this will be available.  Customers can get new phone numbers for users or have phone numbers ported to the PSTN Calling service.  Number provisioning will be done directly through the Office 365 admin portal or of course, via PowerShell.

Power BI Pro

Power BI Pro is a business analytics service that enables information workers to visualize and analyse data with greater speed, efficiency and understanding.  Users are connected to live data through dashboards, interactive reports and visualizations that bring data to life and make it meaningful to their role.  And don’t underestimate the live data here; this could come from Internet of Things (IoT) devices, wearables for example and be up to the second.  Power BI provides a Power BI Desktop tool and Power BI mobile apps for iOS, Android and Windows.  Excel also has Power BI enhancements such as being able to merge and use queries from multiple data sources, including public sources like Twitter alongside corporate data.

Delve Analytics

You may have heard or perhaps used Delve.  Delve allows an individual to see and search the documents and sites that are important to people connected to you.  It surfaces knowledge according to what and who you’re working with.

Delve Analytics on the other hand, allows managers to discover how their team or organisation works.  It provides insights into important business problems like organization collaboration, who’s talking to whom, siloed team detection, identification of most connected employees, types of meetings taking place across the organization and work-life balance; which teams are consistently working beyond their shifts.  Individuals can gain a fresh perspective about the way they work including time management, network analysis and influence and reach indicators.

Both Delve and Delve Analytics use Office Graph and sophisticated machine learning to map the relationships between people, content and activity that occurs across Office 365.

Customer Lockbox

One of the common cloud topics is that organisations want to have full control over their content stored in cloud services.  Office 365 has evolved so nearly all service operations performed by Microsoft are fully automated and any human interaction is highly controlled and kept away from customer content.  Only in very rare cases does a Microsoft engineer have any reason to access customer content.  Microsoft employees do not have automatic access to service operations.  All access is obtained through a rigorous access control technology called Lockbox.  An extension to this is Customer Lockbox and if an organisation has Customer Lockbox, they have the keys to that engineer access.  The customer is notified when their content needs to be accessed by service administrators and the have total control to approve or deny such access.  They can set up Just-In-Time access to specific scopes of data and all access control activities are logged and audited.  So access currently goes through a secure workflow process but Lockbox makes the customer part of that process.

Customer Lockbox will be available for Exchange Online first and for SharePoint Online in Q1 of 2016.

Advanced Threat Protection

Advanced threat protection has been available for a few months now.  It combats unknown & sophisticated threats in email.  Let’s say you get an email with a short link, a Bit.ly link for example.  When you first receive the email, the link is fine and directs you to the Sugababes fan club site as expected.  However, sometime in the future that shortlink redirects you to a malware site and before you know it you’ve downloaded a One Direction virus.  Safe Links provide time-of-click protection against such malicious URLs by wrapping external links in special URLs that check the destination link for threats before opening them.  There’s also Safe Attachments which opens email attachments sandboxed virtual environments to detect malicious behaviour.  And Click Trace keeps a record of every user who has clicked on a URL for additional protection so if you do need to take remedial action, it’s easier to know exactly where.

Equivio Analytics for eDiscovery

Back in January, Microsoft acquired Equivio, a provider of machine learning technologies for eDiscovery and information governance.  If an organisation goes through a law suit, it’s extremely expensive and time consuming.  Data on a given topic needs to be found and collected and once it’s harvested, typically lawyers are paid lots of money to go through that data and determine relevance.  Equivio simplifies the eDiscovery process by using machine learning, tagging and predictive coding to identify relevant email and documents and reduce the amount of data that’s returned.
All of these new capabilities form part of Office 365 E5 and with the exception of the PSTN Calling plans are available as standalones licences.

In the next blog post, we’ll go deeper into the PSTN features and what they include.


Office 2016 Releases

Office 365 Logo

Office 2016 is released on 22nd September 2015 and hits the volume licensing pricelist on the 1st October.  What’s new?  Some will be disappointed it’s not radically different from Office 2013.  Others will breathe a sigh of relief and appreciate the consistency between the versions whilst having a good level of improvement over Office 2013 which was a fantastic suite of applications.  We’ll be running a series of hints and tips blog posts over the next month detailing the main changes.

For now, if you’re a Microsoft partner you can visit the Microsoft Drumbeat site, packed full of sales training events and resources to help you start, grow and accelerate your Office 365 practice (registration required).

If you love videos of Americans waving their hands around too much and generally being very excited with words like ‘super’ and ‘cool’ then take a look at the 400 second-long Vimeo video.

FAQ

Q – Is this going to be an automatic upgrade from 2013 to 2016 if I’m on Office 365?

A – No.  If you want to deploy Office 2016 you’ll need to do that using your usual deployment processes, e.g. via the Office 365 portal.  There will be automatic upgrades in the future but there aren’t any full details on that yet, for example how to accept or prevent the automatic upgrade to 2016.

Q – Will Office 2016 still be available as a perpetual, on-premises product?

A – Yes, Office 2016 is available on-premises and through Office 365 subscriptions.  Unless you have Software Assurance on Office 2013 on-premises, you’ll need to buy the licence to Office 2016 as it’s a completely new version.  Office 365 includes new version rights so if you’re on an Office 365 which includes the Office apps (e.g. E3, E4, Business, Business Premium, ProPlus) you have the rights to 2016 immediately.

Q – I’m on Office 365; how long can I stay on the 2013 release?

A – For 12 months after the release of Office 2016.

Q – InfoPath is no longer included in the 2016 release, where can I get this?

A – InfoPath 2013 is the last version and can be downloaded from Microsoft’s download centre.  Your Office 365 ProPlus licence allows use of InfoPath 2013 and it will still be supported


Rolling Back with Office 365

talk_show_interview_1600_clr_8350A question from our Twitter feed: “@imageframeuk Can you download the old version of #MSOffice when you purchase #office365? The new #MSOffice2016 for Mac is very buggy…”

Great question.  Forgive us because we’re going to answer for the Windows platform here, I don’t have my demo Mac handy but when I get it back we’ll include Mac-specific information.

Office 365 is an evergreen, versionless service.  This means there isn’t strictly what Microsoft would call a major version although in this case going from Office 2011 applications to Office 2016 applications is a major upgrade.

There are no downgrade rights with Office 365 so it’s impossible to subscribe to Office 365 and install Office 2010 applications or Office 2011 Mac applications.  Depending on the subscription plan you have:

     1- you can control how and when future updates are installed

     2- you can disable automatic updates

     3- you can rollback to a previous update

There are limitations to this though.  Option 1 is discussed in this TechNet blog article Managing Updates for Office 365 ProPlus.

Option 2 can be achieved through company-wide policy or in the individual program.  In any Office 365 ProPlus for Windows application, select File, Account and you’ll see the update options on the right-hand side.

 

Option to Disable Office 365 updates

Select Disable Updates and none of your Office applications will be updated; you won’t need to do this in each application.  Somewhere in the world a puppy will start crying however, because you are defying Microsoft.

 

Option to Disable Office 365 updates

This action shouldn’t be taken lightly though; you will also not receive security patches so your products may become vulnerable.  And at some point, your installation of Office will become unsupported.

Option 3 is performed by running OfficeC2RClient.exe from an administrative command-prompt and using the updatetoversion switch with the specific version you want to deploy which can be newer or older than the current version (or you may not have one installed at all).  If you don’t specify a version, it defaults to the latest one.  The versions only go back so far but theoretically you could deploy an older release going back a couple of years.

How will rollbacks work when Office 2016 applications are brought into mainstream Office 365?

We’ll post an update to this blog when we try it.

The last point may seem obvious and irrelevant but we have to mention it for completeness.  You can of course still use Office 2011 for Mac on the device whilst connecting to the Office 365 cloud services.  But this is not going to help if you’ve subscribed to an Office 365 plan which includes Office applications; who wants to pay twice for the same thing?


Excel – Paste into Visible Cells Only

Microsoft Excel

 

Sometimes Microsoft Excel is just too helpful.  Like American shop assistants to an English shopper (I’m not being xenophobic, I’m just not used to lots of people asking if I want help finding things (try shopping in Reading on a Saturday afternoon).

Anyone who has tried to paste data in a filtered Excel spreadsheet knows this.  Excel will also paste the data into the hidden (filtered out) cells.  It obviously thinks it’s being helpful but it’s really not.

There have been many suggested workarounds but it comes down to using Paste into Excel Visible Fields or a Paste into Excel Visible fields only with code.

There are two solutions that we use.  If you’re running Excel 2013 or above, you can utilise Flashfill.  For earlier versions, you might be able to use the Fill function..

Let’s look at Fill first.  Here is our example sheet:

Excel Paste into Visible cells only

 

A nice simple table with numbers in column B, whether they are odd or even in column A and the square of the number in column C.  What I would like to do is filter on odd numbers (because I am a little odd), copy the square and paste those into the new column D.

Let’s try to do that in the most obvious way and see what happens.

Filter the table to show only odd numbers.  Select all the squares in column C and copy.

Excel Paste into Visible cells only

 

Click in cell D2, right-click and select Paste Values.  But wait!  Only half of the values are shown.  That’s because Excel is being over-helpful and pasting into the hidden, filtered-out rows as well as the visible rows.  It would be lovely if there was a ‘Paste Values into Visible Cells’ option but you’ve already spent an hour searching the internet to discover there just isn’t.

 

Excel Paste into Visible cells only

 

If we clear the filter, we can see exactly that behaviour.  Our five selected cells have been pasted into the interim rows.

Excel Paste into Visible cells only

 

 

 

 

 

 

Using Fill to Successfully Paste into Visible Cells Only

Let’s go back to our filtered table.  However this time select the cells and the column next to it.

Excel Paste into Visible cells only

Now go up to the ribbon (Home tab) and click Fill and Fill Right.  Obviously if your destination column is to the left then feel free to hit Fill Left instead.

Excel Paste into Visible cells only

 

And voila, unlike the previous attempt, we are seeing all five desired values.

 

Excel Paste into Visible cells only

 

And just to be sure, let’s clear the filter condition to make sure nothing has been copied into the hidden rows.

 

Excel Paste into Visible cells only

 

Bingo.  We have our desired outcome.  Obviously this only works in the same sheet and if your columns are adjacent left or right to the cells you wish to copy.  If there are columns in between, you can hide those columns and this method will still work; Excel doesn’t paste into hidden columns in the same way it pastes into hidden rows.  In the screenshot below, I moved column A between the source column and the destination.  I filtered on Odd numbers in the same way, then hid column C.  Select Columns B and D and use the Fill Right method and as the screenshot works, once I unhide column C and clear the filter, everything still works out ok.

 

Excel Paste into Visible cells only

 

Flashfill Will Only Update Visible Cells

In Excel 2013, we have the lovely Flashfill feature which we blogged about previously.  Flashfill will also help but it’s not relevant for Excel versions earlier than 2013 (or Office 365 ProPlus if you ‘re in the cloud).

You can filter on odd numbers, type 1 in the first cell of the destination column, type 9 in the next cell down, hit Enter and then CTRL + E to force Flashfill to take over.  All the desired cells will be copied and if you clear the filter condition, you’ll see that the hidden rows haven’t been touched.  This is why we love Flashfill!

If you’d like more hints and tips, subscribe to our newsletter or better still, sign-up for one of our courses.

 


Modern Attachments in OWA

I’ve just been sent an email with a PowerPoint template attached.  All would be fine except this is the fourth version of the template file.  I’m lucky that I don’t need to worry about storage limits in my inbox but I still don’t like multiple versions flying about and duplicated search results.

We all know we should put the file in a shared location and send a link to so we don’t need to worry about different people having different versions.  But it’s never been easy.

Modern Attachments with Outlook Web App

If the file is on OneDrive for Business (we’re assuming you don’t put business files in OneDrive), I can easily attach them to an email and the sharing is done for me.  I don’t need to go into the ODfB folder and share.

Below I have a document stored on my ODfB but shared with no-one.

OneDrive Modern attachments

 

 

In Outlook Web App (OWA), I compose my email in the normal way and insert attachment.

 

OneDrive Modern attachments

 

OneDrive for Business shows me recent files.  This is a fairly new enhancement along with the ‘shared with me’ view.  I select the file I want to attach.

 

OneDrive Modern attachments

 

The all-important question; do I want to attach this file and endure the pain of resending it every time something changes.  Or do I want the simplicity of sharing the file via OneDrive?

 

OneDrive Modern attachments

 

Within the email, I can use the dropdown on each attachment to change the permissions from the default of edit.

 

OneDrive Modern attachments

 

And once I send the email, I can see that the share and permissions have been set for me automatically back in ODfB.  Nice.

 

 

OneDrive Modern attachments

 

An upcoming feature of ODfB is expirations on shared links.  That means I could share a file or folder for a week and the permissions will automatically revoke after that time.  How this will surface in the attachment process, I don’t know.

Currently, this feature is only available via OWA but it will be included in the rich Outlook client sometime in 2015 (no timeline) and in the mobile Outlook apps for iOS and Android before July 2015.

 

 

 


OneDrive for Business Roadmap

OneDrive for Business logoI thought we’d have the Swedish logo for this post.  We like a bit of international flavour.  Did you know that Excel FlashFill in Danish is Hurtigudfyld?

Back in the real world, we get a lot of questions around OneDrive for Business (ODfB), the perceived reliability of the synchronisation engine and feature requests such as being able to select individual folders for synchronisation as you can do with plain old OneDrive (and just to clarify, this is not something that ODfB can do at the moment).

Back in the Mists of Time (well, 8 years)

A little bit of background often helps people to understand the situation we’re in at the moment.  SharePoint 2001 and 2003 were the early versions of the collaborations and portal tools we know in Office 365 and on-premises today.  They were good at document management and collaboration but had limitations for people that frequently worked offline.  To fill that gap, Microsoft bought a product called Groove in 2005 which allowed sites to be used both offline and between internal and external users.  When I used to demo Groove I asked people what they’d do if they needed to transfer a 50Mb file to a customer in another country; too big to email so it would be a case of posting it or setting up an FTP site.  We all think Dropbox or OneDrive now but they simply didn’t exist back then.

Groove was renamed to SharePoint Workspace before being discontinued and replaced with ODfB.  ODfB doesn’t have all the functionality of SharePoint Workspace 2010 but it does allow for offline synchronisation and sharing with external users.  Don’t get me started on Windows Live Mesh; I loved that but it was in turn replaced by OneDrive.

The reason I’m reaching back into the dim mists of time is that ODfB continues to use the Groove synchronisation engine (Groove.exe) to keep your online and offline files up to date and this is all about to change.

Cloud ODfB vs On-premises ODfB

Before I go into the OneDrive roadmap, let’s also consider for one paragraph, the difference between ODfB in Office 365 and the on-premises SharePoint ODfB.  Although these are called the same the gap in functionality will widen as Microsoft have stated in their “cloud-first engineering model”.  The cloud version of ODfB is already more advanced with features such as shared-with-me, responsive pages, integration with Delve, quick command bars, context menus and drag/drop support.  While many of these changes should be included in the next on-premises release, many will not.  Specifically those related to unique cloud technologies such as Delve.  Also, because Microsoft are running the cloud ODfB, they are able to keep up with market demands for features such as unlimited storage, easy mobile access without puncturing your firewalls, external guest sharing, etc..  These are unique values to a cloud offering and on-premises deployments will never be able to compare.

Big Changes in the New ODfB

The first big change is already available in the mobile clients.  At present on the pc there are two sync applications; OneDrive and OneDrive for Business.  Confusing and it leads to terrible jokes like OneDrive is really TwoDrive.  Ha ha, ahem.  The mobile sync application is a unified app which lets users connect to both OneDrive and ODfB.  This will be coming for rich clients too.  The back-end services will not be merged however: OneDrive will remain consumer and ODfB will remain enterprise-led with service level agreements and so on.  Think Hotmail vs Exchange online; one is consumer and the other is an enterprise service but I can connect to both using a unified client.

The next generation sync client will be in preview sometime after July 2015 for the pc and Mac and should go on to general release in October-December.  There will also be a unified web client.  We’ve already blogged that the storage limit of 1TB is being increased to unlimited storage over this year and the 20,000 file limit is also removed for general release of the next generation sync app along with support for files larger than the current 2GB restriction although this is likely to remain limited at 10GB per file.

Additional features are being rolled out now and existing Office 365 tenants will start to see these soon.  Too many to mention in a single blog post but you can keep up to date via the Office 365 roadmap.  There are some great compliance features being surfaced in an Office 365 admin centre area called the compliance center (sic) so keep an eye out for that in your tenant.  These include:

Auditing and reporting – the ability to view what users are doing in ODfB within a certain date range
Data Loss Prevention (DLP) and eDiscovery – notification and control if certain data is uploaded, e.g. files with credit card numbers.
Mobile Device Management (MDM) – tighter integration with Intune
Information Rights Management (IRM) – protection for ODfB files and libraries
Sync controls – being able to block certain pcs from being able to sync files offline
Data retention policies – for example, auto delete or archive files that haven’t been modified for 6 months
Encryption at rest – data store in ODfB will be encrypted
Compliance – ISO, EU Model and other compliances; a key differentiator between OneDrive and ODfB

The compliance center screen is shown below.

Office365 Compliance Centre

 

Microsoft wants customers to be confident about the importance of ODfB and the effort they’re putting into getting it right.  We all swear (a lot) at ODfB synchronisation right now and sometimes it’s embarrassing to discuss this with customers but the roadmap is exciting and the future looks bright.

If you’d like to learn about SharePoint and ODfB in more technical depth, have a look at our courses.  We use the best trainers so not only do you learn the course material but we can provide the most up-to-date information about the technologies.

 


When 1TB Just Isn’t Enough

Unlimited storage with OneDrive for BusinessSpare a thought for all those workers out there who still have storage limits.  A 200MB inbox for example.  For a while now, Office 365 customers have been able to enjoy unlimited Exchange Online Archiving and 1TB of OneDrive for Business storage.  But Microsoft likes to set limits that customer’s aren’t going to hit.  Starting in 2015, all Office 365 customers will enjoy unlimited OneDrive storage at no additional cost.  No specific timescales but every customer will be notified of their service changes.

The Office blog highlighted the change in October last year but we’re starting to see Office 365 consumer and commercial customers receive this upgrade.

One step at a time however, as the current limit on items within a OneDrive for Business library is 20,000, including files and folders.

[Update for May 2015 – the current limits of 20,000 files and 2GB per file will be removed in Q4 of 2015 when the next generation OneDrive synchronisation client is released.  However a single file limit of 10GB looks likely]


New Office 365 Datacentres

New Office 365 locationsThe issue of data sovereignty arises a lot with cloud computing so it’s good to stay up-to-date with plans for local datacentres.  Offering Office 365 services from local datacenters helps customers feel more confident about complying with regulations that require data to be kept in their own region.  Microsoft has a regionalised data centre strategy with Office 365 and the billing address of the customer, which the customer’s administrator inputs during the initial setup of the services, typically dictates the Office 365 region and the primary storage location for that customer’s data.  You can view these regions on the Microsoft Office 365 Data Maps page.  For example, customer’s in Asia Pacific will have their Office 365 hosted in datacentres in Hong Kong and Singapore, however some data may reside elsewhere such as Active Directory and Global Address Book data.

Microsoft announced they’ll be launching Office 365 services from datacenters in Japan (December 2014), Australia (March 2015) and India (late 2015) and these regions will replicate data across datacenters in a single country only.

Customers should be able to create new tenants inside these additional regions as soon as they’re online (for example Japan is available now).  Existing customers in the affected regions will have their data moved to the new Office 365 datacenters from September 2015 and will be given six weeks advance notice of their move date.

You can read more about these plans on TechNet and also about the Japan datacentre on the Office 365 blog.

No news about a UK datacentre as yet.


Easiest way to MCSA?

Perhaps you’re looking for a new job and you want to refresh your certification.  Perhaps you’re hiring new staff and want to skill them up quickly or meet targets to earn a Microsoft Partner Competency.  What’s the easiest way to earn a Microsoft Certified Solutions Associate (MCSA) accreditation?

Easy is the wrong word here.  None of these exams are easy; they exist to test and prove your experience and knowledge in a topic.  MCSA is also the prerequisite to earn the Microsoft Certified Solutions Expert accreditations which really are the pinnacle of Microsoft certifications.

However the fastest route to earn an MCSA, assuming you’re not upgrading an earlier qualification,  is to work towards either Windows 7 or Windows 8.1 MCSA or towards the Office 365 MCSA.  Each of these routes only require you to take two exams from scratch.

Microsoft Certified Solutions Associate Map

 

Your choice should clearly depend on your IT career path and the skills you’re going to need.  If you are open to all areas though, of those three MCSA options, we’d advise the Office 365 MCSA.  Firstly there is only one 5-day course whereas Windows MCSA involves two 5-day courses and thus more time out of the office and more cost.  Attending a course is not required to take an exam but it’s a great way to maximise your chances.  Secondly, the Office 365 MCSA can be used as the foundation to gain the MCSE qualification in Desktop Infrastructure, Server Infrastructure, Private Cloud, Messaging, Communications or SharePoint.  The Windows MCSA does not have an MCSE route.

Of course, we’d love to help you gain nay Microsoft qualification so please get in touch and see how we can help.

 


Dude, where’s my data?

Office 365 Logo

A play on the film title from “Dude, where’s my car?” in which, well actually, we can’t remember the plot but we do remember the title and something about a scene with tattoos.

Putting movies to one side, customers often want to know where their mailboxes reside in Office 365 and Exchange Online.  If my billing address is in Europe I can assume my data centres are located in Dublin and Amsterdam but can I verify that?  Also, the mailboxes for individual users and resources might be in either of those locations.  Here’s where a little PowerShell comes in handy.

There’s a useful getting started with Powershell resource on the Microsoft website.  You can also search the web for myriad explanations but be aware many of these will be out of date especially if you’re using Windows 8.1.

Windows 8.1 includes PowerShell by default so on the Start screen, type PowerShell, right-click Windows PowerShell in the search results and select Run as Administrator.  I’ll explain why you need to run it as admin in a moment.

How to run Windows powerShell

 

So many memories of the old DOS window.  PowerShell doesn’t speak Office 365 by default so we have to teach it by installing the Windows PowerShell cmdlets for Office 365 management and deployment.  Your keyboard should now be bristling with all the power you have at your fingertips.

1 – Set the PowerShell execution policy.  The default setting for execution policy is restricted which would not allow PowerShell to run scripts at all; secure but not very useful.  RemoteSigned tells PowerShell it can run scripts on the local machine but any scripts downloaded from the Internet must be signed by a trusted publisher.  This is also why you need to run PowerShell as administrator; in order to change this setting.

Set-ExecutionPolicy RemoteSigned

2 – Set your Office 365 admin credentials.  A popup window will appear where you type in your Office 365 admin user and password.  This will also tell the PowerShell cmdlets which Office 365 tenant you want to connect to.

$cred = Get-Credential

3 – In order to perform administrative tasks on Office 365 you can connect to the online service using the credentials you supplied.

Connect-MsolService -cred $cred

4 – You can list all the Office 365 admin commands.  Note that Exchange, SharePoint and the other cloud services have their own set of commands.

Get-Command –Module msonline

5 – To connect to Exchange Online, type the following commands.  You don’t need to change anything here; again, the tenant to connect to is specified by the login ID in the credentials.

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell -Credential $cred -Authentication Basic -AllowRedirection

Import-PSSession $Session

6 – Return your mailbox information to see where they’re located.  If the server name begins with db you’re in Dublin and if it’s am you’re in Amsterdam.  Happy travels!

Get-Mailbox