Office 365 Advent Calendar – 02 Retrieving SharePoint Online Site Collection Sizes

Scenario You want to get an overview of the storage usage of all site collections in your tenant, similar to what you can see in the “SharePoint Administration” section in Office 365. But as you may have hundreds of site collections, or as you want to pass on that information to someone else, you want to extract this information into a spreadsheet Code $cred = Get-Credential Connect-PnPOnline -Url "https://mytenant-admin.sharepoint.com" -Credentials Details

Getting your Office 365 tenant’s SharePoint site structure with PowerShell

Update 12 June 2018: Updated cmdlets to follow the newer PnP naming standards (e.g. Connect-PnPOnline instead of Connect-SPOnline). Introduction From time to time you may want to get an overview of the structure of your SharePoint Online environment. That is, you want to know the number of site collections and subsites, and know how they are organised. While you could review the existing site collections either in the UI (not Details

Setting Administrators on all SharePoint Online Site Collections

Introduction Imagine the following scenario: A user or a group of people need full access to all site collections in your Office 365 tenant. It could be a service account that gathers some statistics regularly, or a group of users who provide regular detailed support to your organization. How can you ensure that these users have access to all site collections, even newly created ones? What is the best of all Details

Script to download the SharePoint Online DLLs

Over at the SharePoint Community, Balamurugan Kailasam posted that he was able to download the DLLs from SharePoint Online. While it is unclear at the moment why this is possible (maybe required by some tools?), or if this might be deactivated at some point, I decided nevertheless to write a small PowerShell script to download all DLLs that I’m aware of. The code below create a subfolder with the current time Details

New options in the SharePoint Online Management Shell PowerShell cmdlets

A few days ago, Microsoft released a new version of their SharePoint Online Management Shell (the PowerShell cmdlets that can be used to manage SharePoint Online). In this blog post, I will briefly explain what was changed and what you can do now with the new options. Note: The new internal version number for the cmdlets is : 15.0.4569.1506 Sites The first new attribute that is available is for Site Collections Details

Creating OneNote notebooks in SharePoint via JSOM

This article has been published originally in German on the 1stQuad company blog. With server-side code, it is fairly easy to create OneNote notebooks in SharePoint. In this article, I want to explain briefly how to achieve this with the  JavaScript Object Model (JSOM). In a current project, one of the requirements was to create OneNote notebooks automatically in Office 365. This had to happen either with out-of-the-box functionality or Details

I’m speaking at the European SharePoint Conference 2014

In case you missed it, the European SharePoint Conference 2014 programme is now available and I’m delighted to announce that I am speaking at Europe’s largest SharePoint event in Barcelona, Spain from the 5-8th May 2014. I will be conducting two sessions on “Implementing a Hybrid SharePoint 2013 and Office 365 environment” and “SharePoint Online vs On-Premises vs Hosted – Making the Right Choice”. “Implementing a Hybrid SharePoint 2013 and Details

Presenting at SharePoint Connections and European Office 365 connect

As an Office 365 MVP, I’m an active member of the SharePoint and Office 365 community. I blog, I write articles and books, I hold webinars, and sometimes I also present at conferences. I’m happy to announce that I’ll be speaking twice in the Netherlands, once in November at SharePoint Connections 2013, and in January at the first European Office 365 connect. SharePoint Connections Amsterdam 2013 – 19.-21.November 2013 I’ll Details

Webinar: Hybrid SharePoint 2013 and Office 365 Environments

This coming Wednesday, I’ll be doing a webinar hosted by MetaVis Technologies on Hybrid SharePoint 2013 and Office 365 Environments: More and more companies are interested in moving some or all of their operations to Office 365 / SharePoint Online. However, many of them have existing SharePoint environments, which they still want to continue using. In this Webinar, Office 365 MVP Rene Modery will look at how a hybrid environment Details