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
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,135 Downloads
Christoph Muelder
The attached script reads all checkedout projects from the draft database and sends checkin requests to the specified Project Server instance.
(3)
Updated 3/7/2013
Released 11/25/2012
674 Downloads
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,418 Downloads
Christoph Muelder
The attached PowerShell script allows to publish a collection of projects.The collection of projects to be published can be specified by a parameter that builds a WHERE clause against the Reporting database.
(4)
Updated 3/7/2013
Released 11/25/2012
712 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
796 Downloads
SQL
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,112 Downloads
PWMather
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.
(4)
Updated 6/17/2012
Released 6/17/2012
744 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
526 Downloads
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,014 Downloads
Amit Khare - Project Management Consultant
This powershell script adds the Exception in Resource calendar using the Resource Web service. Based on the Resource Guid, scripts checksput the resource & creates an exception row.
(2)
Updated 11/26/2012
Released 11/23/2012
597 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
627 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,035 Downloads
SQL
Amit Khare - Project Management Consultant
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
(1)
Updated 11/20/2012
Released 11/20/2012
768 Downloads
SQL
Amit Khare - Project Management Consultant
This gallary script gets the audit data Timesheet Actual Work/Planned Work AssignmentPercentWorkCompleted across all projects by timesheet periods for all Enterprise Resources. This might be useful for PMO/Project Managers & Developers to create SSRS report.
(2)
Updated 12/24/2012
Released 12/24/2012
590 Downloads
SQL
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
556 Downloads
SQL
1 - 15 of 74 Items