Access #ProjectOnline #Project sites using #PowerShell and #SharePoint CSOM #Office365

This PowerShell script will use the Project Reporting OData API to get a list of all the Project Sites in the PWA Site Collection linked to a project. It will then access each of those project sites to enable you to easily update / review the site if needed. This example just lists all of...

Extract #ProjectOnline or #ProjectServer 2013 / 2016 Timesheet data #PowerShell #Office365

This PowerShell script will use the Project Reporting OData API to extract the timesheet data between the given start and end dates. The user running the script specifies the source PWA instance URL, Username and password. They then enter the start and finish dates in yyyy-mm-dd format and run. The data will then be displayed...

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

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...

Check entities from multiple #ProjectOnline PWA instances using #PowerShell and CSOM #Office365

This PowerShell script enables admins to read entities from from multiple Project Online Project Web App instances using CSOM. The particular example reads the list of Enterprise Custom fields but can easily be updated to display other entities such as projects. The script example can be downloaded here: https://gallery.technet.microsoft.com/Check-entities-from-a1cb87e4 To get the script to work...

#ProjectServer #PS2010 / #PS2013 delete #Project site using #PowerShell #SP2013 #SP2010

Following on from a post / script I created a year or so ago to bulk create project sites, there have been requests to be able to bulk delete projects sites. I have been reluctant to do that as i am always cautious when “bulk” deleting! The script i have created reads the list of...

#ProjectServer #PS2010 / #PS2013 bulk #Project site creation using #PowerShell 3.0 or later #SP2013 #SP2010

I recently had to bulk delete and then bulk create project sites for a client. Rather than engaging one of our devs I wrote a PowerShell script to do this. This does need PowerShell 3.0 or later to work. This post covers the bulk create script as this is generic, the bulk delete was specific...

#ProjectServer 2013 Build OLAP Cube via #PowerShell #SP2013 #PPM #PS2013

One potential issue for many organisations with Project Server 2013 is that users need access to Central Admin if they want to build the OLAP Cube. Usually the PMO / PWA Admins would not have access to Central Admin, they only have access to Project Web App. If they want to build the OLAP Cube...

Create a #ProjectServer #PS2010 #PS2013 project from a template and update the EPT #SP2013 #SP2010 #PowerShell

I have been meaning to publish this PowerShell script for a few months but finally got around to it today. The PowerShell script creates a project from a template then updates the Enterprise Project Type (EPT). I did write a post over a year ago on how to create a project using PowerShell but this...

#PowerShell scripts for #ProjectServer #PS2013 #SP2013 #PPM

I haven’t posted for a while due to work commitments and just generally being too busy – I am hoping this will change after the summer! Anyway, just a quick post today to let you know that I have tested some of the key PowerShell scripts I wrote for Project Server 2010 on Project Server...