Forecast Content Database Growth

One of client requested PowerShell script to forecast content database growth with following requirements: Need to run on SharePoint 2007 Output to a CSV file Highlight when a content DB has reached 80GB storage limits Highlight when a content DB has reached 90GB storage limits In order to complete this script following information was required:…

0

Office 365 – Create Permissions Level and Groups using CSOM

I was recently helping a customer to deploy the OneNote Class Notebook App (which is really cool) to 200 of their SharePoint Online sites, the deployment part is super-easy however the assignment of permissions to users (teachers) to use the app isn't so straightforward when you have this number of sites as a new Permission Level and Group need to be…

5

Office 365 – Identify External Users

Here is a quick script that can be used to identify external users that have access to each Site Collection within an Office 365 tenant (excluding OneDrive for Business Sites). This script requires the SharePoint Online Management Shell which can be downloaded from – http://www.microsoft.com/en-us/download/details.aspx?id=35588. Output will be written to the console and a CSV file…

0

Office 365 – Create a List and Add Custom Fields using CSOM

I previously Blogged about creating a List and adding Site Columns using CSOM and PowerShell – http://blogs.technet.com/b/fromthefield/archive/2014/02/18/office365-script-to-create-a-list-add-fields-and-change-the-default-view-using-csom.aspx I was recently asked to create a List and add some Custom Fields using PowerShell, in this specific case Site Columns weren't being used so I need to create the fields from scratch. The example below does the following: Creates…

1

Office 365 – Upload and Set a Master Page

We all know that Custom Master Pages for SharePoint Online are not recommended, right? I had a customer that decided they needed to use a custom Master Page and asked for my assistance to automate the process of uploading and configuring their custom Master Page, never one to shy away from writing a script I put the…

3

Office 365 – Deleting a Web Part using CSOM

I was recently assisting a customer to automate the creation and customization of their SharePoint Online sites using PowerShell, one of their requirements was to remove the "Get started with your site" Web Part from the landing page of each newly created Team Site. The script below can be used to do this, please update…

2

Office 365 – Identify how much storage a OneDrive site is consuming with PowerShell

UPDATE: It now appears to be possible to use Get-SPOSite to bind to a OneDrive site (I'm sure that this didn't work before!). I recently helped a colleague to write a script that reports how much storage a OneDrive site is consuming, for standard SharePoint Online sites the Get-SPOSite PowerShell Cmdlet can be used which returns the property StorageUsageCurrent…

3

Office 365 – Creating a Subsite (Web) using CSOM in SharePoint Online

SharePoint Online has a number of PowerShell Cmdlets – https://technet.microsoft.com/en-us/library/fp161374(v=office.15).aspx, these Cmdlets include New-SPOSite which provides the ability to create a Site Collection, unfortunately it's not possible to create a SubSite (web) using these Cmdlets – it is however possible to use CSOM to do this and the script below demonstrates how to create a SubSite and…

8

Flush the SharePoint Configuration Cache

From time to time you may need to flush the SharePoint configuration cache on servers within your farm, my colleague Joe Rodgers blogged about this many moons ago – http://blogs.msdn.com/b/josrod/archive/2007/12/12/clear-the-sharepoint-configuration-cache-for-timer-job-and-psconfig-errors.aspx. If you run into a scenario that you need to flush the configuration cache on all servers within a farm this can become a very…

0