TechNet Gallery Feed - Sorted By: Popularity, Sort Order: Descending

Project Server 2010 - Publish all projects

PWMather — Thu, 31 May 2012 04:46:59 -0700

This PowerShell script will publish all projects in Project Server when run with an account that is a Project Server administrator. This can either be run on demand or set to run on a schedule using the Windows Task Scheduler.

Created by: PWMather
Published Date: 5/31/2012

Project Server 2007/2010 - SQL- Get Timesheet data

Amit Khare - Project Management Consultant — Mon, 10 Sep 2012 04:31:39 -0700

This SQL query returns the Timesheet data from Project server reporting database.

Created by: Amit Khare - Project Management Consultant
Published Date: 9/10/2012

Project Server 2010 - Powershell- Publish a project based on project name

Amit Khare - Project Management Consultant — Fri, 06 Jul 2012 03:28:39 -0700

This PowerShell script will publish the specific project in Project Server when run with an account who is in administrator group in Project Server 2010.

Created by: Amit Khare - Project Management Consultant
Published Date: 7/6/2012

Project Server 2010 - Powershell- Get the Custom List Columns details

Amit Khare - Project Management Consultant — Tue, 10 Jul 2012 04:08:19 -0700

This scripts returns the custom list columns information like ID, Name & Internal Name of the column in SharePoint 2010/ Project Server 2010 project sites.Below code gets the Actions list columns information like ID, Title & Internal Name.

Created by: Amit Khare - Project Management Consultant
Published Date: 7/10/2012

Update Project Server Lookup table with values from a text file

PWMather — Wed, 29 Aug 2012 03:31:09 -0700

This PowerShell script will add lookup table values from a text file into the specified lookup table. The values to add will need to be in a list in a text file

Created by: PWMather
Published Date: 8/29/2012

Project Server 2010- SQL- Get Resource Capacity Vs Allocation by Month/Year

Amit Khare - Project Management Consultant — Fri, 19 Oct 2012 02:44:56 -0700

This SQL query returns the Resource capacity in hours , Allocated hours across all projects from Project server reporting database. It gets the data for next six months & past two months from the current month.

Created by: Amit Khare - Project Management Consultant
Published Date: 10/19/2012

Move a SharePoint 2010 sub site to new location on the same farm

PWMather — Thu, 28 Jun 2012 09:42:47 -0700

This script will move a SharePoint 2010 sub site to a new location on the same farm using the export and import commands

Created by: PWMather
Published Date: 6/28/2012

Project Server 2010 - Powershell Script - Create a project

Amit Khare - Project Management Consultant — Mon, 09 Jul 2012 03:34:55 -0700

This PowerShell script will create a project in Project Server when run with an account who is in administrator group in Project Server 2010 or having permission to create project.

Created by: Amit Khare - Project Management Consultant
Published Date: 7/9/2012

Project Server 2007/2010 - SQL- Get Project Tasks & Resources

Amit Khare - Project Management Consultant — Tue, 20 Nov 2012 01:59:13 -0700

This SQL query returns the Project Tasks data by all resources assigned to Task for Projects from Project server reporting database. This query might be useful for PMO/ Project Managers to have a quick look on the project/Tasks & Resources assigned to Tasks. This can be used in

Created by: Amit Khare - Project Management Consultant
Published Date: 11/20/2012

Update SharePoint list item Author and Editor

PWMather — Wed, 01 May 2013 00:54:43 -0700

This PowerShell script will update the Author (Created By) and Editor (Modified By) fields for all SharePoint list items in the chosen list.

Created by: PWMather
Published Date: 5/1/2013

SuperFlow for Microsoft Project Server 2010 Upgrade

Microsoft Office Developer Documentation Team — Mon, 04 Jun 2012 11:29:27 -0700

The Microsoft Project Server 2010 Upgrade SuperFlow is a special kind of help file that provides you with information that you need to upgrade to Microsoft Project Server 2010.

Created by: Microsoft Office Developer Documentation Team
Published Date: 6/4/2012

Check server time for all servers in SharePoint 2010 farm

PWMather — Thu, 26 Apr 2012 04:19:40 -0700

A PowerShell script that will check all of the server times for all servers in the SharePoint 2010 farm. This will enable system administrators to quickly check that all server times in the farm are in sync, for Project Server this is very important to avoid sleeping jobs.

Created by: PWMather
Published Date: 4/26/2012

SQL Query to find out Resource belongs to which Project Server Security Group.

Raushan_kumar — Mon, 25 Mar 2013 06:44:43 -0700

This MS SQL query will help you to find out Resource/User belongs to which Microsoft Project Server 2007/2010 Security Group. Query can be use to find out administrative users. SELECT MSP_RES.RES_NAME, MSP_SG.WSEC_GRP_NAME,FROM MSP_RESOURCES MSP_RESINNER JOIN MSP_WEB_SECURITY

Created by: Raushan_kumar
Published Date: 3/25/2013

Deploy multiple wsp solutions to the farm using SharePoint.PowerShell

Avinash kr — Fri, 11 Jan 2013 13:48:44 -0700

CodeToTransfer.rarWe always develop functions and feature in development server, and need to deploy in QA and Production server.This is very sure that we always having multiple wsp to deploy.This codeToTransfer tool will help you to deploy multiple wsp file in one shot.Instructio

Created by: Avinash kr
Published Date: 1/11/2013

Project Server 2007/2010/2013 - SQL- Get Project Deliverables

Amit Khare - Project Management Consultant — Mon, 22 Oct 2012 05:16:36 -0700

This SQL query returns the deliberables & Project task related data from Project server reporting database. This query might be useful for PMO & Project Managers to have a quick look on the project related Deliverable(s).

Created by: Amit Khare - Project Management Consultant
Published Date: 10/22/2012

Project Server 2010- Powershell- Check User's group association

Amit Khare - Project Management Consultant — Tue, 25 Sep 2012 04:17:53 -0700

This PowerShell script might be useful for administarors/Developers to find out for a given resource's group. This script checks if the given RES_UID is associated with Administrators group of project server.

Created by: Amit Khare - Project Management Consultant
Published Date: 9/25/2012

Project Server 2010- Powershell- Create a project with required custom fields

Amit Khare - Project Management Consultant — Mon, 09 Jul 2012 04:31:16 -0700

This PowerShell script will create a project with required Custom fields having lookup value in Project Server when run with an account who is in administrator group in Project Server 2010 or having permission to create project.This can be useful in load testing with EPM.

Created by: Amit Khare - Project Management Consultant
Published Date: 7/9/2012

Update specified SharePoint abolute URLs with relative URLs

PWMather — Sun, 17 Jun 2012 12:36:35 -0700

This PowerShell script will find all sites with the specified quick launch link URL in the site collection specified and replace the absolute URL with the relative URL.

Created by: PWMather
Published Date: 6/17/2012

Project Server 2010 - Publish specified projects

PWMather — Mon, 22 Oct 2012 05:58:19 -0700

This PowerShell script will publish the projects specified in a text file. The projects will be published to Project Server when run with an account that has access to the specified projects in Project Server.

Created by: PWMather
Published Date: 10/22/2012

Project Server 2010 - Powershell- Update Task Properties for a specific project

Amit Khare - Project Management Consultant — Sun, 08 Jul 2012 22:24:54 -0700

This PowerShell script will update the Task Name for specific project in Project Server when run with an account who is in administrator group in Project Server 2010.

Created by: Amit Khare - Project Management Consultant
Published Date: 7/9/2012