Download Windows Server 2012TechNet Gallery - 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:
|
This SQL query returns the Timesheet data from Project server reporting database.
|
(4)
Updated 9/10/2012
Released 9/10/2012
657
Downloads
|
|
|
The internal regular backup of project plans is configured in the Project Server server settings and executed using a SharePoint Timer Job. Sometimes this stops working. The script helps finding out before you need a backup that does not exist.
|
(1)
Updated 12/1/2013
Released 12/1/2013
26
Downloads
|
|
|
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
379
Downloads
|
|
|
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
400
Downloads
|
|
|
This gallary script gets the audit data Timesheet Actual Work/Planned Work AssignmentPerce
|
(2)
Updated 12/24/2012
Released 12/24/2012
294
Downloads
|
|
|
Use this script to retrive the permissions granted or denied to Project Server groups. Exchange 1033 in the script if you prefer the permission names in your favourite language.
|
(3)
Updated 9/16/2013
Released 2/2/2013
44
Downloads
|
|
|
For audit purposes it might be interesting to see if and which users have global permissions set on individual level (directly without group membership).Thi
|
(0)
Updated 9/16/2013
Released 9/16/2013
58
Downloads
|
|
|
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
323
Downloads
|
|
|
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
222
Downloads
|
|
|
Use this script to retrieve the group memberships from the published database
For Project Server 2013 the statement has to be slightly modified. |
(3)
Updated 7/9/2013
Released 2/2/2013
|
|
|
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
314
Downloads
|
|
|
This SQL query returns the Risks & 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 Risks. This can be used in Excel/ SSRS reports.
|
(1)
Updated 10/12/2012
Released 10/12/2012
256
Downloads
|
|
|
This SQL statement can be used to retrieve group object permissions (permissions on group/category relations) from the Published databaseUseful to create a report with SQL Server Reporting Services or Excel.
|
(1)
Updated 2/2/2013
Released 2/2/2013
|
|