Bulk Delete Enterprise Projects
We can Bulk Delete Enterprise Projects using “Delete Enterprise Objects” option when it is no longer needed. However if you want to delete many projects then its difficult task of selecting each projects and there are chances that you may miss out on selection. Recently we wanted to delete around 250 Projects and used below script which bulk delete Projects. This script queries the Project Server database to list of projects to be deleted and then delete the projects using QueueDeleteProjects PSI method.
You can find the script at https://gallery.technet.microsoft.com/projectserver/Server-20102013-Delete-e1e416bc/view/Reviews
The Script accepts the below parameters.
1. ProjectServerURL
URL of the Project Server instance to be connected to.
2. DatabaseServer
Name of the SQL Server
3. ProjectDB
Name of the ProjectServer Database.
4. WhereClause
WHERE CLAUSE to specify the list of projects to be deleted (optional Parameter). (example: “WHERE
[PROJECT STATUS] = ‘active’ or [ProjectPercentCompleted] = 100″ (double quotes needed)
Let us know if you have any additional questions.
PPM Works is a full service Microsoft Project and Portfolio Management consultancy, focused on Microsoft Project Server and Microsoft SharePoint platforms. We believe in partnering with our clients to exceed expectations and build long lasting rewarding partnerships. We are continuously building a knowledge base of multiple tips, tricks and solutions to make your use of Microsoft Project Pro as quick and easy as possible. Contact us for more information.
Stay updated with the latest of Project Online/Server 2013 with us: Subscribe. Check our future events!
Subscribe to our webcast email list for updates on our upcoming webinars!
Visit our FAQ Page for access to our tool box.