Home > Paul Mather, Work > #Office365: quickly see which #SharePoint sites are #ProjectOnline sites #PowerShell

#Office365: quickly see which #SharePoint sites are #ProjectOnline sites #PowerShell

Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

In Office 365 from the SharePoint admin center it is not possible to quickly see which site collections are PWA site collections. The only way currently to check in the UI is the select a site collection then click the Project Web App button on the Site Collections ribbon and see if the Remove and Settings options are enabled:

image

If you select a normal SharePoint site collection these two options are disabled:

image

As you can imagine, if you have many site collections this could be quite a slow process. There is a simple and quick answer to this, PowerShell. Using the SharePoint Online Management Shell you can access the properties of the site collections, details on the SharePoint Online Management Shell can be seen below:

http://bit.ly/1XexDKw

I have used the PowerShell ISE to create and run the script, to use the ISE you will need to firstly install the SharePoint Online Management Shell on your machine then import the module using the command below:

Import-Module Microsoft.Online.SharePoint.PowerShell -DisableNameChecking

Once loaded, a simple PowerShell script can easily identify the PWA site collections:

image

There is a –Filter parameter for the Get-SPOSite command but it doesn’t allow you to filter on the Template property so I created a simple foreach loop and did the filter there.

Or if you want to see all of the site collections and the templates used to create the sites see the script below:

image

In both examples just update the site collection admin site URL and the global administrator username for the Connect-SPOService command.

If would be good to get this information visible in the view from the SharePoint Admin Center, someone has already suggested this on the Office 365 uservoice, see the link below if you want to vote:

http://bit.ly/1Tz1azD

Advertisements
Categories: Paul Mather, Work Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: