Project Server - resources for IT professionals

Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.

Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
Sort by: rss
74 results
Amit Khare - Project Management Consultant
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).
(1)
Updated 10/22/2012
Released 10/22/2012
699 Downloads
SQL
PWMather
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.
(8)
Updated 5/22/2014
Released 5/31/2012
1,486 Downloads
PWMather
This PowerShell script will update the Author (Created By) and Editor (Modified By) fields for all SharePoint list items in the chosen list.
(2)
Updated 5/1/2013
Released 5/1/2013
683 Downloads
Amit Khare - Project Management Consultant
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.
(3)
Updated 8/17/2012
Released 7/9/2012
743 Downloads
Christoph Muelder
Cleaning up unnecessary versions manually is not much fun.

You can use the attached script to specify the list of versions from the system
(2)
Updated 1/16/2014
Released 1/16/2014
429 Downloads
Amit Khare - Project Management Consultant
This SQL query returns the Timesheet data from Project server reporting database.
(4)
Updated 9/10/2012
Released 9/10/2012
1,095 Downloads
SQL
Amit Khare - Project Management Consultant
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.
(3)
Updated 8/17/2012
Released 7/6/2012
1,086 Downloads
Amit Khare - Project Management Consultant
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.
(2)
Updated 8/17/2012
Released 7/10/2012
1,177 Downloads
Christoph Muelder
The attached script reads all checkedout projects from the draft database and sends checkin requests to the specified Project Server instance.
(4)
Updated 3/7/2013
Released 11/25/2012
734 Downloads
Amit Khare - Project Management Consultant
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.
(6)
Updated 10/19/2012
Released 10/19/2012
853 Downloads
SQL
PWMather
This script will move a SharePoint 2010 sub site to a new location on the same farm using the export and import commands
(5)
Updated 6/28/2012
Released 6/28/2012
1,187 Downloads
Amit Khare - Project Management Consultant
This SQL query returns the Milestone counts for a given Project from Project server reporting database. This query might be useful for PMO/ Project Managers to have a quick look on the project milestone count by month & year.
(1)
Updated 11/19/2012
Released 11/19/2012
525 Downloads
SQL
PWMather
This PowerShell script accesses the Project Server queue data and exports this into a text file in the specified location. Execute the script on a daily schedule using the Windows Task Scheduler to capture high-level audit details for Project Server.
(4)
Updated 8/29/2013
Released 4/27/2012
850 Downloads
PWMather
This PowerShell script will create a project from the specified project template then update that project to associate it with the correct EPT.
(1)
Updated 8/30/2013
Released 8/30/2013
575 Downloads
Amit Khare - Project Management Consultant
This SQL query returns the Issues & Project 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 issues. This can be used in Excel/ SSRS reports.
(1)
Updated 10/10/2012
Released 10/10/2012
607 Downloads
SQL
1 - 15 of 74 Items