Office 365 feature comparison chart all plans


Office365logo

Office 365 feature comparison chart all plans
(All in one Place)

 

threegoodthings365reversedx

This is an updated version of a popular blogpost that I posted in January 2013. It turned out to be one of the most visited posts and it still is (This one). This time I have updated the feature comparison list to show what is included in the different Office 365 plans and subscription levels that are available. It is not easy to find the information when you are looking to buy just the right plan for your organization.
My primary goal with this post is to again make it just a little bit easier to find what feature is included in what plan, what functionality is avaiable in which plan and most importantly, where is SharePoint Online included? 😉 


The complete Office 365 subscription plan comparison list

(Remember that the content in every license plan can be subject to change at any time)

Menu
Office 365 Services SharePoint Online, Exchange…
Office Applications Word, Excel…
Enterprise Value Funtionality for the Enterprise
SharePoint Online
Developer features
Developer features that are supported
IT Professional features Advanced features,
Content features Document management, content in general
Insights features (BI)  Business Intelligence features
Search features To-Be-Added
Sites features To-Be-Added
Social features To-Be-Added
Credit and reference links  


Office 365 Services

Office 365 Service Office Professional Plus 2013 Office 365 ProPlus Office 365 Business Essentials Office 365 Business Premium Office 365 Enterprise E1
Office 365 Education E1
Office 365 Government E1
Office 365 Enterprise E3
Office 365 Education E3
Office 365 Government E3
Office 365 Enterprise E4
Office 365 Education E4
Office 365 Government E4
Office 365 Enterprise K1
Office 365 Government K1
Office 365 Platform No No Yes Yes Yes Yes Yes Yes
Exchange Online No No Yes Yes Yes Yes Yes Yes
SharePoint Online No No Yes Yes Yes Yes Yes Yes
OneDrive for Business No Yes Yes Yes Yes Yes Yes No
Skype for Business Online No No Yes Yes Yes Yes Yes No
Office Online No Yes Yes Yes Yes Yes Yes Yes
Office 365 ProPlus No Yes No No No Yes Yes No
Office 365 Business No Yes No Yes No No No No
Project Online No No No 1 No 1 No 1 No 1 No 1 No 1
Yammer Enterprise No No Yes Yes Yes 2 Yes 2 Yes 2 Yes 2
Azure Rights Management (RMS)4 No No No 3 No 3 No 3 Yes Yes No 3
Office Delve No No Yes 5 Yes 5 Yes Yes Yes No
Office 365 Groups No No Yes Yes Yes Yes Yes No
Office 365 Video No No No No Yes 6 Yes 6 Yes 6 No

Back to menu

Note:
1   Project Online is not included, but can be purchased as a separate add-on service.
2   Yammer Enterprise is not a component of Office 365 Government, but may be acquired at no cost as a standalone offer for each user licensed for Office 365 Government Plan E1, E3 and E4. This offer is currently limited to customers which purchase Office 365 Government under Enterprise Agreement and Enterprise Subscription Agreements.
3   Azure RMS is not included, but can be purchased as a separate add-on service.
4    To learn more about which RMS features are included with Office 365 plans, see Comparison of Rights Management Services (RMS) Offerings
5    Office Delve will become available for the Office 365 Business Essentials and Office 365 Business Premium plans in early 2015.
6    Office 365 Video is not available with the following plans: Office 365 Government E1, Office 365 Government E3, Office 365 Government E4

Changing or mixing plans
As the needs of your organization change, you may need to change your Office 365 plan. You can switch from your current Office 365 subscription to another Office 365 subscription:
– In the same service family: For example, you can move from Office 365 Business Essentials to Office 365 Business Premium, or from Office 365 Enterprise E1 to Office 365 Enterprise E3.
– From a standalone plan: For example, you can move from Exchange Online Plan 1 to Office 365 Enterprise E1.
– To a different service family: For example, you can move from Office 365 Business Essentials to Office 365 Enterprise E3.
For information about how to change subscriptions, including how to move from a trial to a paid subscription, see Switch to a different Office 365 plan or subscription.

You can combine Enterprise, Business and standalone plans (e.g. Exchange Online Plan 1) within a single Office 365 account. However, existing limitations on the number of seats per plan do not change. For example, you can have up to 300 seats per plan on both Office 365 Business Essentials and Office 365 Business Premium, but an unlimited number of users on Exchange Online Plan 1. Education and Government plans cannot be combined with Enterprise, Business or standalone plans.

 

Office 365
Office Applications

Office Application Office Professional Plus 2013 Office 365 ProPlus Office 365 Business Office 365 Business Essentials Office 365 Business Premium Office 365 Enterprise E1
Office 365 Education E1
Office 365 Government E1
Office 365 Enterprise E3
Office 365 Education E3
Office 365 Government E3
Office 365 Enterprise E4
Office 365 Education E4
Office 365 Government E4
Office 365 Enterprise K1Office 365 Government K1
Microsoft Word Yes Yes Yes No Yes No Yes Yes No
Microsoft Excel Yes Yes Yes No Yes No Yes Yes No
Microsoft PowerPoint Yes Yes Yes No Yes No Yes Yes No
Microsoft OneNote Yes Yes Yes No Yes No Yes Yes No
Microsoft Outlook Yes Yes Yes No Yes No Yes Yes No
Microsoft Publisher Yes Yes Yes No Yes No Yes Yes No
Microsoft Access Yes Yes No No No No Yes Yes No
Skype for Business Yes Yes Yes 1 Yes 1 Yes 1 Yes 1 Yes Yes Yes 1
Microsoft InfoPath Yes Yes No No No No Yes Yes No
Windows 8 Apps Yes Yes Yes Yes Yes Yes Yes Yes No
Office for Mac for Office 365 No Yes Yes No Yes No Yes Yes No
Office Mobile for iPad/iPhone No Yes Yes No Yes No Yes Yes No
Office Mobile for Android No Yes Yes No Yes No Yes Yes No
Office Mobile for Windows Phone No Yes Yes No Yes No Yes Yes No

Back to menu

Note:
1   Lync 2013 Basic is available for all customers. The Lync Basic desktop client is a locally installed application that provides presence, instant messaging and conferencing features for Office 365 plans that include Skype for Business Online. Office 365 ProPlus, Office 365 Enterprise E3 and Office 365 Enterprise E4 include the full Lync application, which include additional features including advanced telephony support, archiving & compliance features. A Skype for Business Online license must be assigned for each user. For more information on Lync Basic features, see Clients for Skype for Business Online.

Office 365
Enterprise Value

Enterprise Value Office Professional Plus 2013 Office 365 ProPlus Office 365 Business Office 365 Business Essentials Office 365 Business Premium Office 365 Enterprise E1
Office 365 Education E1
Office 365 Government E1
Office 365 Enterprise E3
Office 365 Education E3
Office 365 Government E3
Office 365 Enterprise E4
Office 365 Education E4
Office 365 Government E4
Office 365 Enterprise K1Office 365 Government K1
5 installs per user on PC or Mac No Yes Yes No Yes No Yes Yes No
Automated user account provisioning N/A Yes Yes Yes Yes Yes Yes Yes Yes
Multilingual user interface Yes Yes Yes No Yes No Yes Yes No
Client push deployment Yes Yes Yes Yes Yes No Yes Yes No
Client support for on-premises Exchange Yes Yes Yes No Yes No Yes Yes No
Client support for on-premises SharePoint Yes Yes Yes No Yes No Yes Yes No
Control of software updates Yes Yes Yes Yes Yes No Yes Yes No
Database Compare Yes Yes No No No No Yes Yes No
Desktop virtualization Yes Yes No No No No Yes Yes No
Excel Spreadsheet Compare Yes Yes No No No No Yes Yes No
Excel Spreadsheet Inquire Yes Yes No No No No Yes Yes No
Exchange Online and SharePoint Online Archiving and Compliance Yes 1 Yes 1 No No No No Yes Yes No
Group Policy support Yes Yes No No No No Yes Yes No
Information Rights Management using Azure RMS No 2 No 2 No 2 No 2 No 2 No 2 Yes Yes No 2
Information Rights Management using Windows Server AD RMS Yes 3 Yes 3 Yes 3 Yes 3 Yes 3 Yes 3 Yes 3 Yes 3 Yes 3
Office Add-in, ActiveX, and BHO support Yes Yes No No No No Yes Yes No
OneNote client access to notebooks on SharePoint Server, SharePoint Online, OneDrive for Business, and Office 365 No Yes Yes No Yes No Yes Yes No
Office Telemetry Yes Yes No No No No Yes Yes No
Offline support for client applications Yes Yes Yes No Yes No Yes Yes No
Optimized side-by-side client installation No Yes Yes Yes Yes No Yes Yes No
Power Map for Excel No 4 Yes Yes No Yes No Yes Yes No
Power Pivot for Excel Yes Yes No No No No Yes Yes No
Power Query for Excel Yes Yes No No No No Yes Yes No
Power View for Excel Yes Yes No No No No Yes Yes No
Roaming settings Yes Yes Yes No Yes Yes Yes Yes Yes
Shared computer activation No Yes No No No No Yes Yes No
Support for blocking cloud-based file storage Yes Yes No No No No Yes Yes No
Version upgrades No Yes Yes No Yes No Yes Yes No
Volume activation (KMS/MAK) Yes No No No No No No No No

Back to menu

Note:
1   Archiving and compliance features are supported with this version of Office, but the Exchange Online and SharePoint Online plans are not included and must be purchased separately or used with supported on-premises server equivalents.
2    Azure Rights Management (RMS) isn’t included but can be purchased as a separate add-on in order to enable the supported IRM features.
3   Windows Server AD RMS is an on-premises server that must be purchased and managed separately in order to enable the supported IRM features.
4   If you have Office Professional Plus 2013 or a standalone version of Excel 2013, you can download and use the Power Map Preview for Excel 2013 as an unsupported add-in.


SharePoint Online
Developer features

SharePoint Online
Developer feature
Office 365 Business Essentials Office 365 Business Premium Office 365 Enterprise E1
Office 365 Education E1
Office 365 Government E1
Office 365 Enterprise E3
Office 365 Education E3
Office 365 Government E3
Office 365 Enterprise E4
Office 365 Education E4
Office 365 Government E4
Office 365 Enterprise K1
Office 365 Government K1
Access Services Yes Yes Yes 2 Yes 2 Yes 2 Yes 2
App Catalog (SharePoint) Yes Yes Yes Yes Yes Yes
App Deployment: Cloud-Hosted Apps Yes Yes Yes Yes Yes Yes
App Deployment: SharePoint-Hosted Apps Yes Yes Yes Yes Yes Yes
App Management Services Yes Yes Yes Yes Yes Yes
BCS: Alerts for External Lists No No No Yes Yes No
BCS: App Scoped External Content Types (ECTs) No No No Yes Yes No
BCS: Business Data Webparts No No No Yes Yes No
BCS: External List No No No Yes Yes No
BCS: OData connector No No No Yes Yes No
BCS: Profile Pages No No No No No No
BCS: Rich Client Integration No No No No No No
BCS: Secure Store Service No No No Yes Yes No
BCS: Tenant-level external data log No No No Yes Yes No
Browser-based customizations Yes Yes Yes Yes Yes Yes
Client Object Model (OM) Yes Yes Yes Yes Yes Yes
Client-side rendering (CSR) Yes Yes Yes Yes Yes Yes
Custom Site Definitions No No No No No No
Custom Site Provisioning No No No No No No
Developer Site Yes Yes Yes Yes Yes Yes
Forms Based Applications Yes Yes Yes Yes Yes Yes
Full-Trust Solutions No No No No No No
InfoPath Forms Services No No No Yes Yes Yes
JavaScript Object Model Yes Yes Yes Yes Yes Yes
List and Library APIs Yes Yes Yes Yes Yes Yes
Remote Event Receiver Yes Yes Yes Yes Yes Yes
REST API Yes Yes Yes Yes Yes Yes
Sandboxed Solutions Yes Yes Yes Yes Yes Yes
SharePoint Design Manager Yes Yes Yes Yes Yes Yes
SharePoint Designer Yes Yes Yes Yes Yes Yes
SharePoint Store Yes Yes Yes Yes Yes Yes
Workflow 2010 (.NET 3.5) Yes Yes Yes Yes Yes Yes
Workflow 2010 (out of the box) Yes Yes Yes Yes Yes Yes
Workflow 2013 Yes Yes Yes 1 Yes 1 Yes 1 Yes
Workload API: ECM APIs Yes Yes Yes Yes Yes Yes
Workload API: Search APIs Yes Yes Yes Yes Yes Yes
Workload API: Social APIs Yes Yes Yes Yes Yes Yes

Back to menu

Note:1   Workflow 2013 is not yet available in Office 365 Government E1, Office 365 Government E3, or Office 365 Government E4 plans.
2   Access Services is currently not available for the following plans: Office 365 Government E1, Office 365 Government E3, Office 365 Government E4, Office 365 Government K1



SharePoint Online
IT Professional features

SharePoint Online
IT Professional features
Office 365 Business Essentials Office 365 Business Premium Office 365 Enterprise E1
Office 365 Education E1
Office 365 Government E1
Office 365 Enterprise E3
Office 365 Education E3
Office 365 Government E3
Office 365 Enterprise E4
Office 365 Education E4
Office 365 Government E4
Office 365 Enterprise K1
Office 365 Government K1
Active Directory Synchronization Yes Yes Yes Yes Yes Yes
Alternate Access Mapping (AAM) No No No No No No
Analytics Platform Yes Yes Yes Yes Yes Yes
Anti-malware protection Yes Yes Yes Yes Yes Yes
Claims-Based Authentication Support No No No No No No
Configuration Wizards No No No No No No
Deferred Site Collection upgrade Yes Yes Yes Yes Yes Yes
Distributed Cache No No No No No No
Data loss prevention No No No Yes Yes No
Encryption at rest Yes Yes Yes Yes Yes Yes
Host Header Site Collections No No No No No No
Improved Permissions Management Yes Yes Yes Yes Yes Yes
Improved Self-Service Site Creation No Yes No No No No
Managed Accounts No No No No No No
Minimal Download Strategy (MDS) Yes Yes Yes Yes Yes Yes
OAuth Yes Yes Yes Yes Yes Yes
Patch Management No No No No No No
Quota Templates No No No No No No
Read-Only Database Support No No No No No No
Remote BLOB Storage No No No No No No
Request Management No No No No No No
Request throttling No No No No No No
Resource throttling No No No No No No
Service Application Platform Yes Yes Yes Yes Yes Yes
SharePoint Health Analyzer No No No No No No
SharePoint admin center Yes Yes Yes Yes Yes No 1
Shredded Storage Yes Yes Yes Yes Yes Yes
Site Collection Compliance Policies Yes Yes Yes Yes Yes Yes
Site Collection Health Checks Yes Yes Yes Yes Yes Yes
State Service No No No No No No
Streamlined Central Administration No No No No No No
System Status Notifications No No No No No No
Unattached Content Database Recovery No No No No No No
Upgrade evaluation site collections Yes Yes Yes Yes Yes Yes
Usage Reporting and Logging No No No No No No
Windows PowerShell Support Yes Yes Yes Yes Yes Yes

Back to menu

Note:1   Because Kiosk users can’t be administrators, tenants with Kiosk users need at least one Enterprise user to access the admin center.



SharePoint Online Content Features

SharePoint Online
Content features
Office 365 Business Essentials Office 365 Business Premium Office 365 Enterprise E1

Office 365 Education E1

Office 365 Government E1

Office 365 Enterprise E3

Office 365 Education E3

Office 365 Government E3

Office 365 Enterprise E4

Office 365 Education E4

Office 365 Government E4

Office 365 Enterprise K1

Office 365 Government K1

Accessibility Standards Support Yes Yes Yes Yes Yes Yes
Asset Library Enhancements/Video Support Yes Yes Yes Yes Yes Yes
Auditing Yes Yes Yes Yes Yes Yes
Auditing & Reporting (e.g. doc edits, policy edits, deletes) Yes Yes Yes Yes Yes Yes
Content Organizer Yes Yes Yes Yes Yes Yes
Design Manager Yes Yes Yes Yes Yes Yes
Document Sets Yes Yes Yes Yes Yes Yes
Document Translation in Word Online Yes Yes Yes Yes Yes Yes
eDiscovery Search Yes 5 Yes 5 Yes 5 Yes 5 Yes 5 Yes 5
eDiscovery Hold No 5 No 5 No 5 Yes 5 Yes 5 No 5
eDiscovery Export No 5 No 5 No 5 Yes 5 Yes 5 No 5
Email enabled lists and libraries No No No No No No
External Sharing: External Access Yes Yes Yes Yes Yes Yes
External Sharing: Guest Link Yes Yes Yes Yes Yes Yes
Folder Sync Yes1 Yes1 Yes1 Yes Yes Yes2
IRM using Azure Rights Management No3 No3 No3 Yes Yes No 3 4
IRM using Windows Server AD RMS No No No No No No
Managed Metadata Service Yes Yes Yes Yes Yes Yes
Metadata-driven Navigation Yes Yes Yes Yes Yes Yes
Multi-stage Disposition Yes Yes Yes Yes Yes Yes
Office Online (create/edit) Yes Yes Yes Yes Yes Yes
Office Online (view) Yes Yes Yes Yes Yes Yes
Office Web Apps Server integration No No No No No No
PowerPoint Automation Services No No No No No No
Preservation hold library No No No Yes Yes No
Quick Edit Yes Yes Yes Yes Yes No
Records management Yes Yes Yes Yes Yes Yes
Recycle Bin (SharePoint admin center) Yes Yes Yes Yes Yes No
Recycle Bin (site collection) Yes Yes Yes Yes Yes No
Related Items Yes Yes Yes Yes Yes Yes
Rich Media Management Yes Yes Yes Yes Yes Yes
Shared Content Types Yes Yes Yes Yes Yes Yes
SharePoint Translation Services Yes Yes Yes Yes Yes Yes
Site mailbox Yes Yes Yes Yes Yes No
Surveys Yes Yes Yes Yes Yes Yes
Unique Document IDs Yes Yes Yes Yes Yes Yes
Video Search No No No Yes Yes No
WCM: Analytics Yes Yes Yes Yes Yes Yes
WCM: Catalog No No No Yes Yes No
WCM: Category page and catalog item page No No No Yes Yes No
WCM: Search web parts No No No Yes Yes No
WCM: Cross-Site Publishing No No No Yes Yes No
WCM: Designer Tools Yes Yes Yes Yes Yes Yes
WCM: Faceted navigation No No No Yes 6 Yes 6 No
WCM: Image Renditions Yes Yes Yes Yes Yes Yes
WCM: Managed navigation Yes Yes Yes Yes Yes Yes
WCM: Mobile and Device Rendering Yes Yes Yes Yes Yes Yes
WCM: Multiple Domains No No No No No No
WCM: Recommendations Yes Yes Yes Yes Yes Yes
WCM: Search Engine Optimizations (SEO) Yes Yes Yes Yes Yes Yes
Word Automation Services No No No No No No

Back to menu

Note:

1   To use folder sync, you must have Office 2013 (Standard or Professional edition) or an Office 365 subscription that includes Office applications. Office 365 Business Essentials, Office 365 Enterprise E1, Office 365 Education E1, and Office 365 Government E1 plans don’t include subscriptions to Office 2013. However, you can use folder sync if you have Office 2013 installed and subscribe to one of these plans.
2   Kiosk accounts have limited OneDrive for Business functionality. Kiosk customers can use the OneDrive for Business folder sync client application to sync team site document libraries with a shared computer and access documents offline. But kiosk accounts do not include a OneDrive for Business Personal Site, so they do not benefit from a OneDrive for Business personal library with 1 TB of online storage.
3    Azure Rights Management (RMS) is not included, but can be purchased as a separate add-in order to enable supported IRM features.
4   Because Kiosk users can’t be administrators, tenants with Kiosk users need at least one Enterprise user to access the admin center.
5   When you use eDiscovery features, the licensing requirement for a plan that permits that feature applies to all end users that are part of the eDiscovery action (Search, Hold, Export).
6   Authenticated SharePoint Online users can access private site collections with faceted navigation.



SharePoint Online Insights Features

SharePoint Online
Insights features
Office 365 Business Essentials Office 365 Business Premium Office 365 Enterprise E1

Office 365 Education E1

Office 365 Government E1

Office 365 Enterprise E3

Office 365 Education E3

Office 365 Government E3

Office 365 Enterprise E4

Office 365 Education E4

Office 365 Government E4

Office 365 Enterprise K1

Office 365 Government K1

Business Intelligence Center No No No Yes Yes No
Calculated Measures and Members No No No Yes Yes No
Data Connection Library No No No Yes Yes No
Decoupled PivotTables and PivotCharts No No No Yes Yes No
Excel Services No No No Yes Yes No
Field list and Field Support No No No Yes Yes No
Filter Enhancements No No No Yes Yes No
Filter Search No No No Yes Yes No
PerformancePoint Services No No No No No No
PerformancePoint Services (PPS) Dashboard Migration No No No No No No
Power View for Excel in SharePoint No No No Yes Yes No
Power Pivot for Excel in SharePoint No No No Yes Yes No
Quick Explore No No No Yes Yes No
Scorecards & Dashboards Yes 1 Yes 1 Yes 1 Yes 1 Yes 1 Yes 1
SQL Server Reporting Services (SSRS) Integrated Mode No No No No No No
Timeline Slicer No No No Yes Yes No
Visio Services No No No Yes Yes No

Back to menu

Note:

1 Scorecards & Dashboards are not available for the following plans: Office 365 Education E1, Office 365 Education E3, Office 365 Education E4, Office 365 Government E1, Office 365 Government E3, Office 365 Government E4, Office 365 Government K1



Credits

Myself, I get all the credit this time! 🙂

References

Office 365 Plan Options
https://technet.microsoft.com/en-us/library/office-365-plan-options.aspx
Office Applications Service Description
https://technet.microsoft.com/en-us/library/office-applications-service-description.aspx
Comparison of Rights Management Services (RMS) Offerings
https://technet.microsoft.com/en-us/dn858608 Office365logo _________________________________________________________

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Office 365 News – First release for select users


 Office365logo

First release can now be offered to a select group of users!

(Including a funny mistake by a Microsoft developer)

ImageLife made even simpler for the admins

First release has until now been something that you do not want to enable in a production tenant for the organization, because the impact can be to big with untested changes and additions made regularly.
The common option for the administrator thirsting for knowledge has been to create an evaluation tenant and enable First Release there.
Cumbersome and difficult…is what that was!
A drawback has also been that you could not test anything with the real users, real data or real life scenarios.

No more so, now, the option to enable First Release for only selected users are available.

This is how you do it:

1. Log into your tenants Admin portal: https://portal.office.com/admin/default.aspx
2. Go to Service Settings, Updates.
3. Under First Release, check Select People, you will get a popup asking if you are sure, click Yes.
4. Locate the users you want to set as first release users.
5. Select the users in the box below and click on save (It does not have to be administrators).
5.5 Bulk update (You can also create a list of UPN’s and sumbit it as a bulk update.)
6. Done!
7. Undo

In Pictures:

1. Log into your tenants Admin portal: https://portal.office.com/admin/default.aspx

FirstRelease1

2. Go to Service Settings, Updates.

FirstRelease2

3. Under First Release, check Select People, you will get a popup asking if you are sure, click Yes.
(Entire organization is the old choice, this affects everyone in the tenant)

FirstRelease3x

Like I said, select Yes in the popup dialog.

FirstRelease4
4. In the dialog to your right, search for the user/users you want to set as First Release users.

FirstRelease35x

a. Start typing aname to search for the user…

FirstRelease5

b. Located users are moved to the userslist.

FirstRelease6

c. Select all users in the list.

FirstRelease7

5. Select the users in the box below and click on save (It does not have to be administrators).
(You can also create a list of UPN’s and sumbit it as a bulk update.)

FirstRelease8

You do not get any conformation that it is changed, but it is.

5.5 Bulk update

For a bulk update, do this:

a. Create a list of the users UPN’s, User Principle Names (i.e. Emailaddresses) and save it as a textfile (.txt)
The file can named anything and can be saved anywhere you like.

FirstReleaseBulk3

b. In the Admin portal, Service Settings, Updates, Click on Bulk add people

FirstReleaseBulk0x

c. Browse to your userlist

FirstReleaseBulk1

d. Select the file and click Open

FirstReleaseBulk4

Note the path…(someone at Microsoft made a mistake…\fakepath\ ??). The path shown does not matter, it will work, trust me!

FirstReleaseBulk5x

e. Now click on Next to finish

FirstReleaseBulk6

f. As you can see, the result is shown in the resultlist, success and fail are listed. You can also get a view of a very simple logfile.
Click on finish when you are ready.

FirstReleaseBulk7

Bulk import Done!
6. All Done!

7. Undo

To reset the tenant and go back to noone having first release, do this:

In the Admin portal, Service Settings, Updates, Click on Standard

undo2

Agree to the popup

Undo

And you’re back to normal!

I’

Credits

Niklas Danell, Microsoft Sweden
Erik Fryksén, Xperta AB

References

Microsoft Support on the First Release options

  Office365logo _________________________________________________________

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Office 365 News – Office 365 Limited Admin Roles are here


 Office365logo

Finally! Office 365 Limited Admin Roles are here!

(2015-05-22: In my tenant, this option has now gone away…)

SharePoint administrator
Exchange Administrator
Lync Administrator
User/AD Administrator
Helpdesk Administrator
Support Administrator

This has been one of the major missing features in Office 365, one that many has asked for, it has been on the roadmap and ‘In Development’ and ‘Rolling Out’ for a very long time as well. Now it is HERE! In a ‘First Release’ tenant. (Coming to all tenants in due time) To use the limited roles, do this:

1. Go to the Office 365 Admin Portal https://portal.office.com/admin/default.aspx

2. Select Users -> Active Users

1

3. Locate a user using search

15

4. On the Righthand side, Click on Edit User Roles

2

5. Next, select Limited Admin Role and then check the roles you want the user to have, one or many.

Meg Ryan gets to be a SharePoint Admin only

3

6. Enter an alternate email, same as you do/did for a Global Administrator account

It cannot be a email address that residen within the tenant

7. Save and you are done!

References and Credits

Myself, I get all the credit this time! 🙂 

  Office365logo _________________________________________________________

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Office 365 News – Move and Copy files and folders in OneDrive for Business


 Office365logo       SP2013logo       SharedLove

Now, finally, we can move and copy files within our OneDrive for Business web GUI

Dokument

Some random document…

Some time, early 2015, Microsoft introduced the ability to move/copy files in OneDrive for Business. This has been one of the major obstacles for using OneDrive for Business as a E1 user without the Office applications installed locally. Or rather, as a Online only user no matter what license. As a long time SHarePoint user and technician, this is a long awaited feature in SHarePoint as well, so now I’m keeping my fingers crossed for this ‘simple’ little feature to appear there as well. (I do not for one second think that this has been easy to implement at all) In addition, the function is quick!

Want to see how it looks and works?

The following table lists the tested and verified behaviour of the Copy/Move functionality in OneDrive for Business:

Action Behavior Notes
Move File(s) Moves the selected file(s) to the designated target container Retains metadata Retains sharing Does not overwrite if filename exists, reports back error
Move Folder(s) Moves the selected folder(s) to the designated target container Recreates a new copy of the folder Retains sharing Does not overwrite if filename exists, reports back error
Copy File(s) Copies the selected file(s) to the designated target container Recreates a new copy of the file(s) with new metadata Does not retain sharing Does not overwrite if filename exists, reports back error
Copy Folder(s) Copies the selected folder(s) to the designated target container Recreates a new copy of the folder with new metadata Does not retain sharing Does not overwrite if filename exists, reports back error
Copy or Move in SharePoint N/A – ‘Send to’ a predetermined location is the closest we get in SharePoint Server or SharePoint Online N/A

How it looks in reality:

Move or Copy a single file

SingleFileMove1

Move or Copy multiple files/folders

MultipleFilesMove1

Select the target, check the ‘Copy’ box if you want to Copy and not Move

MultiMoveDialog

After copying/Moving, you will get a Little reciept in the top right corner

Shared15

Ok

or

SharedCopy

If one or many of the files allready exist at the target, they are not overwritten, not even with a new name or new version. You will instead get a note on this and the result

Error

Now, we all hope for the same in SharePoint! Until it comes, we all to this ‘simple’ feature say: FINALLY!

References and Credits

None at this time…

Credits & many thanks to

Everyone!   SP2013logo

_________________________________________________________

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Office 365 guide series – Function to resolve a users OneDrive for Business URL


 Office365logo       SP2013logo

Hi SharePoint Online PowerShellers!

This time I will give you a Quick but great function to use if you are working with OneDrive for Business:

Function to resolve a users OneDrive for Business URL

Aggklockax

Simple solution, great to have, unbelievably efficient…

Ok, this is perhaps my shortest post ever…I’ll just explain real Quick.
OneDrive for Business gets it URL from the tenantname and the users UserPrincipalName. Creating this every time can be troublesome…
This is what I use, a function I created last summer when I was tired of doing them one at the time…

It works even with users that have a different domain in the UPN than what is the tenant name.
This is it:

Function GetODfBURL($UserPrincipalName, $TenantName)
# Creates a correct ODfB URL from email and TenantName/OrgName, returns URL as a String
{
    # ConStructing OneDrive personal URL from the UPN/Email address
    $StrUser = $UserPrincipalName
    $pos= $StrUser.IndexOf("@")
    $len = $StrUser.Length -1
    $StrUser = $StrUser.SubString(0, $pos)
    $StrUser = $StrUser -replace "\.", "_"
    $Orgpos = $pos + 1
    $Orglen = $len - $pos
    $StrOrg = $UserPrincipalName.SubString($Orgpos, $Orglen)
    $StrOrgNamePos = $StrOrg.IndexOf(".")
    $StrOrgName = $StrOrg.SubString(0, $StrOrgNamePos)
    $StrOrgSuffixPos = $StrOrgNamePos +1
    $StrOrgNameLen = $StrOrg.Length - $StrOrgSuffixPos
    $StrOrgSuffix = $StrOrg.SubString($StrOrgSuffixPos, $StrOrgNameLen)
    $StrOrg = $StrOrg -replace "\.", "_"
    $PersonalOrgURL = "https://" + $TenantName + "-my.sharepoint.com/personal/"
    $SiteUrl= $PersonalOrgURL + $StrUser
    $SiteUrl= $SiteUrl+ "_" + $StrOrg
    return $SiteUrl
}
$ODfBURL = GetODfBURL "thomas.balkestahl@blksthl.se" "blksthl"

This will give the URL: https://blksthl-my.sharepoint.com/personal/thomas_balkestahl_blksthl_se

Thats it. Use it or not 🙂

 

 

References and Credits


Nope, not this time…

Credits & many thanks to

To all of you.

_________________________________________________________

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Office 365 guide series – Manage files and folders with PowerShell and CSOM


 Office365logo       SP2013logo

How to manage files and folders with PowerShell and CSOM

DocLib1

How can we manage these items…?

This is a pure guide to using PowerShell to manage and manipulate files and folders, libraries and all document management related tasks in a SharePoint Online or OneDrive for Business environment.

The sections in this guide are:

– Prerequisites
– Load assemblies
– Load a CSOM Context
– Web
– List/Library
– GetFileByServerRelativeUrl and GetForlderByServerRelativeUrl
– Create a file from a local copy
– Create a folder from a local copy
– Set properties on a file
– Set properties on a folder
– ResolveUser (Function)
– GetItemProperties (Function)

Prerequisites

Before beeing able to do much in SharePoint Online or OneDrive for Business, you have to start using CSOM, or Client Side Object Model, this allows us to do pretty much everything we could do before using regular PowerShell and the SharePoint CMD’lets from the SharePoint PowerShell add-on.
Install assemblies:
Download and install ther latest version of the SharePoint Server 2013 Client Components SDK, this can be downloaded from here: http://www.microsoft.com/en-us/download/details.aspx?id=35585
After the SDK and the CSOM assembly DLL’s are in place, make sure you load the assemblies before calling them.

Load assemblies

 Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.dll"
 Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"

This will open up for usage of CSOM in PowerShell.

Load a context

$SPOUser = "administrator@blksthl.onmicrosoft.com"
# Uses a hardcoded password, use only during test/lab:
$SPOPassword = convertto-securestring "Password01" -asplaintext -force
# Better: $SPOPassword = Read-Host -Prompt "Please enter your password" -AsSecureString
$SPOODfBUrl = "https://blksthl.sharepoint.com/personal/jeffrey_lebowski_blksthl_com"
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($SPOODfBUrl)
$Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($SPOUser,$SPOPassword)
$Context.RequestTimeout = 16384000
$Context.Credentials = $Credentials
$Context.ExecuteQuery()

Returns: $Context

Web

(Using $Context from the section on Context above)

$Web = $Context.Web
$Context.Load($Web)
$Context.ExecuteQuery()

Returns: $Web

List/Library

$SPODocLibName = "Documents"
$SPOList = $Web.Lists.GetByTitle($SPODocLibName)
$Context.Load($SPOList.RootFolder)
$Context.ExecuteQuery()

Returns: $SPOList

GetFileByServerRelativeUrl and GetForlderByServerRelativeUrl

In order to use the ‘Get…ByServerRelativeUrl’ methods you have to supply a relative path to the file or folder, this means a path starting from the FQDN.

Example 1
https://company.sharepoint.com/get/fileorfolder/by/relative/url
FQDN: https://company.sharepoint.com
ServerRelativeUrl: /get/fileorfolder/by/relative/url

Example 2
https://company-my.sharepoint.com/personal/firstname_lastname_company_com
FQDN: https://company-my.sharepoint.com
ServerRelativeUrl: /personal/firstname_lastname_company_com

Example file:

"/personal/jeffrey_lebowski_blksthl_com/documents/report1.xlsx"

Example folder:

 "/personal/jeffrey_lebowski_blksthl_com/documents/subfolder"

Create a file from a local copy

This can be accomplished in several ways, this is one:

1.
$LocalFile = Get-ChildItem -path "C:\Homedirs\jeff\report1.xlsx"
$FolderRelativeUrl = $SPOList.RootFolder.ServerRelativeUrl
$FileName = $LocalFile.Name
$FileUrl = $FolderRelativeUrl + "/" + $FileName
[Microsoft.SharePoint.Client.File]::SaveBinaryDirect($Web.Context, $fileUrl, $LocalFile.OpenRead(), $true)

Returns: New file created in SPO/ODfB

Create a folder from a local copy

$SPOFolder = $SPOList.RootFolder
$LocalFolder = Get-ChildItem -path "C:\Homedirs\jeff\" -Recurse -Include "folder1" 
$FolderName = $LocalFolder.Name
$NewFolder = $SPOFolder.Folders.Add($FolderName)
$Web.Context.Load($NewFolder)
$Web.Context.ExecuteQuery()

Returns: New folder created in SPO/ODfB

Set properties on a file

Input: $FileRelativeUrl, $SPOItemModifier, $SPOItemOwner, $ItemCreated, $ItemModified

$CurrentFile = $Context.web.GetFileByServerRelativeUrl($FileRelativeUrl)
$Context.Load($CurrentFile)
$Context.ExecuteQuery()
$ListItem = $CurrentFile.ListItemAllFields;
$ListItem["Editor"] = $SPOItemModifier; # Get object from ResolveUser
$Listitem["Author"] = $SPOItemOwner; # Get object from ResolveUser
$Listitem["Created"] = $ItemCreated;
$Listitem["Modified"] = $ItemModified;
$ListItem.Update()
$Context.Load($CurrentFile)
$Context.ExecuteQuery()

Returns: Folder stamped with new properties in SPO/ODfB

Set properties on a folder

Input: $FolderRelativeUrl, , $SPOItemModifier, $SPOItemOwner, $ItemCreated, $ItemModified

$CurrentFolder = $Context.web.GetFolderByServerRelativeUrl($FolderRelativeURL)
$Context.Load($CurrentFolder)
$Context.ExecuteQuery()
$SPOFolderItem = $CurrentFolder.ListItemAllFields;
$SPOItemOwner = ResolveUser $UserEmail # For ResolveUser see separate function described later in this post
$SPOFolderItem["Editor"] = $SPOItemModifier # Must be a userobject, see 'ResolveUser'
$SPOFolderItem["Author"] = $SPOItemOwner # Must be a userobject, see 'ResolveUser'
$SPOFolderItem["Created"] = $ItemCreated # In the format: "8/10/2013 7:04 PM", see 'GetItemProperties'
$SPOFolderItem["Modified"] = $ItemModified # In the format: "8/10/2013 7:04 PM", see 'GetItemProperties'
$SPOFolderItem.Update()
$Context.Load($CurrentFolder)
$Context.ExecuteQuery()

Returns: Folder stamped with new properties in SPO/ODfB

ResolveUser (Function)

Function ResolveUser ($InputUPN)
# Resolves a user to a userobject
{
    $OutputUserObject = $Web.Context.web.EnsureUser($InputUPN)
    $Web.Context.Load($OutputUserObject)
    $Web.Context.ExecuteQuery()
    Return $OutputUserObject
}

Returns: UserObject for $InputUPN (UserPrincipalName/Email)

GetItemProperties (Function)

Function GetItemProperties ($InFileObject)
# Gets basic properties to set on files and folders
{
    $Global:ItemCreated = $InFile.CreationTime
    $Global:ItemModified = $InFile.LastWriteTime
}

Returns: Global: Variables for ItemCreated and LastWriteTime of $InFileObject (File or Folder)

Thats all for now, I hope that you let me know if there is anything that seems to be wrong or does not work. The problem with describing all this in a complete way, is that it is easy to leave something out and it is also difficult to test every aspect while writing. Time is limited for all of us…
Anyway, my goal was to write a post that covered what I was myself missing…I hope that this is it. And again, please let me know if there are any mistakes in here.

References and Credits

None at this time…

Credits & many thanks to

LabCenter – you guys always publish my articles!

My family, my parents, Ia and the kids!

SP2013logo

_________________________________________________________

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Office 365 News – New document now supports Content types in SharePoint Online


 Office365logo       SP2013logo

‘new document’ now supports Content types in SharePoint Online

Thank you Microsoft, Content types just got user friendly and easy to use and promote!

ContentTypes1x

The new- new document dialog

Before yesterday, I knew that the ‘new document’ button in a document library became useless when you enabled Content types in a document library. This has for me and many of my customers been a huge drawback since the ‘new document’ button was still there, in plain view and for the regular user, what they were meant to use.

This old behavious was that when you pressed on ‘new document’ in a document library with multiple content types, you got the upload document dialog.

Upload dialog2

Old behaviour

What I was so glad to discover yesterday, during a live demo at a customer, that this has been fixed now in SPO! Instead of the upload dialog, I could now get this:

ContentTypes1

Fixed!

One down!
Next step, make content types available to Office Online…(They still seem to require the Office Applications installed on the client, nothing for E1 users or less in other words…)
I would also like the new folder option back with the content types 🙂

References and Credits

None at this time…

Credits & many thanks to

Cramo, this is where I did the demo when this change presented itself to me! A pleasure to work with you guys!

 

SP2013logo

_________________________________________________________

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Office 365 News – Unannounced Microsoft change to SharePoint Online access


 Office365logo       SP2013logo

Microsoft recently made a change to the way users can access SharePoint Online, this may affect many thousands of customers without them knowing…

Licensex

It has been disclosed to me that Microsoft has implemented a change on all Office 365 tenants to the way an unlicensed user can access SharePoint Online services…in a bad way…

Previously, the behaviour was that if you did not give a user a the SharePoint license in Office 365, the user could not access SharePoint.
This is the expected behaviour and this is how most companies restricted access to SharePoint Before they were ready to offer the service to their organizations.
This is no more, or at least not the current behaviour…Microsft has ‘temporarily’ made a change that allows ALL users, with a license or not to have access to all SharePoint Services.
The imidiate affect may be that your organization sleeps safely in the belief that SHarePoint may not be accessed, except by you in IT or by a limited number of individuals, meanwhile, the users go crazy and start using SharePoint in ways you never intended…

Well, this is something I don’t like, I would like this change to be limited to the ones who specifically asked for it, and if you needed it, you could request it, not the other way around.

Note 1: If you find that you do not want this behaviour, you want access only to your licensed users. Open a Service Request with Microsoft and ask them to change it back, they will help you then.

Note 2: The change does not affect OneDrive for Business, unprovisioned users do not get access to their ODfB without the SharePoint license.

The reason given by Microsoft representatives is this: Microsoft recognizes assigning licenses to users that are synced to the O365 services is cumbersome for larger tenants, to alleviate this pain point; a temporary change has been released to SharePoint Online that will allow users to access SharePoint Online even without license.’

 

References and Credits

None at this time…

Credits & many thanks to

Pihlen!

 

SP2013logo

_________________________________________________________

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Office 365 News – Newly Introduced security feature in SPO hides the Web Designer Galleries


 Office365logo       SP2013logo

Newly introduced security feature in SharePoint Online hides the Web Designer Galleries, Save site as template and a lot more too…

AdminSPO Admin setting (with a dead link)

During the end of 2014, beginning of 2015, a new security feature in SharePoint Online has been rolled out. The feature in itself is great, it has been introduced to (From the SharePoint admin interface):

Control whether users can run custom script on personal sites and self-service created sites.  Note: changes to this setting might take up to 24 hours to take effect.

What is good to know without Reading too much on this feature, is that these things for example will be missing:

Site feature Behavior Notes
Save Site as Template No longer available in Site Settings. You can still build sites from templates created before scripting was disabled.
Save document library as template No longer available in Library Settings. You can still build document libraries from templates created before scripting was disabled.
Solution Gallery No longer available in Site Settings. You can still use solutions created before scripting was disabled.
Theme Gallery No longer available in Site Settings. You can still use themes created before scripting was disabled.
Help Settings No longer available in Site Settings. You can still access help file collections available before scripting was disabled.
Sandbox solutions Solution Gallery will not appear in the Site Settings so you can’t add, manage, or upgrade sandbox solutions. You can still run sandbox solutions that were deployed before scripting was disabled.
SharePoint Designer Site Pages: No longer able to update web pages that are not HTML.Handling List: Create Form and Custom Action will no longer work.Subsites: New Subsite and Delete Site redirect to the Site Settings page in the browser. Data Sources: Properties button is no longer available. You can still open data sources.

For a good detailed description of what the feature does, have a look here. It affects mostly Everything and since it is activated by default, a lot of settings and functionality is suddenly missing. The feature has two ‘levels’, for personal sites and for self service created sites. (for me, it affects all site Collections)

Turn scripting capabilities on and off (Microsoft support article)
https://support.office.com/en-us/article/Turn-scripting-capabilities-on-and-off-1f2c515f-5d7e-448a-9fd7-835da935584f?ui=en-US&amp

The feature in itself is great, but perhaps, since it removes so much of the default functionality, it should have been left off be default? Or, would cause some kind of popup to all affected users?

Well, it is here now anyway…lets consider the feature a great idea, it increases the built in security of SharePoint Online and OneDrive for Business!

The complete list of settings affected and webparts missing: Save Site as Template, Save document library as template, Solution Gallery, Web Designer Galleries, Theme Gallery, Help Settings, Sandbox solutions, the Blog Archives, Blog Notifications, Blog tools Blog Webparts, the Business Data Actions, Business Data Item, Business Data Item Builder, Business Data List, Business Data Related List, Excel Web Access, Indicator Details, Status List, Visio Web Access Business Data Webparts, the About This Community, Join, My Membership, Tools, What’s Happening Community Webarts, the Categories, Project Summary, Relevant Documents, RSS Viewer, Site Aggregator, Sites in Category, Term Property, Timeline, WSRP Viewer, XML Viewer Content Rollup Webparts, the Document Set Contents, Document Set Properties Document Sets Webparts, the HTML Form Webpart, the Content Editor, Script Editor, Silverlight Webpart Media and Content Webparts, the Refinement, Search Box, Search Navigation, Search Results Search Webparts, the Catalog-Item Reuse Search-Driven Content Webparts and the Contact Details, Note Board, Organization Browser, Site Feed, Tag Cloud, User Tasks Social Collaboration Webparts.

References and Credits

None at this time…

Credits & many thanks to

Everyone!   SP2013logo _________________________________________________________ Enjoy!

Regards

Twitter | Technet Profile | LinkedIn