  Welcome...We hope you enjoy your visit to Project Server Tips.com. Watch for new Project Server content updated daily. |
Project Server ToolsProject Server 2003 provides useful utilities to ease administration of Project Server and to monitor performance. These tools will be described here. Follow the links for a more detailed description and screen shots.
You can use the EditSite tool (EditSite.exe) to create a Project Server hosted deployment and to edit the properties for existing hosted sites. A hosted deployment is a large installation of Project Server 2003 that hosts Project Server site collections for departments or divisions within the organization. The host can also be an application service provider that hosts Project Server site collections for other companies, similar to the way that an Internet service provider hosts websites. For further information on the EditSite tool, please visit the MPA Blog at: Notes on Using the EditSite Utility. The Project Server Cleaner tool (PSCleaner.exe) enables project managers, resource managers, and administrators to bulk delete unwanted enterprise projects and enterprise resources from the Microsoft Office Project Server 2003 database. Project managers can use this tool to delete any projects they manage, resource managers can use it to delete any resources they manage, and administrators can use the tool to delete any enterprise project or enterprise resource in the Project Server database. The Project Server Data Population (PSDP.exe) tool enables you to load large amounts of custom outline codes, resources, projects and tasks, assignments, and tracking data into the Microsoft® Office Project Server 2003 database. You can then use this data to test data loads and help your organization plan for your Project Server 2003 deployment.
The Delete Duplicate Projects tool (DupeProj.exe) is a command-line tool that you can use to remove duplicate projects from the Project Server database. This tool can help project managers and database administrators in your organization determine the correct duplicate project to delete. This tool works with Microsoft Project Server 2002 and Project Server 2003 databases. The PSCOMPlus tool is used to specify the accounts you want Microsoft Office Project Server 2003 to use when it accesses Microsoft SQL Server 2000 Analysis Services and Microsoft Windows SharePoint Services. The Project Server 2003 PSCOMPlus tool is for Project Server 2003 only and is also Included on the CD on the Prjsvr1.cab file. You can find the Prjsvr1.cab file in the Prjsvr folder.
PSCOMPlus.exe can also be found in the \Microsoft Office Project Server 2003\BIN\1033\PSComPlus.exe folder of your Project Server installation. Microsoft Office Project Server 2003 stores information in the registry about the location of the Project Server database and which accounts are associated with Project Server roles.
If you change your configuration by moving all or part of the database to a new computer, you must to update the information in the registry. Also, if you change which users are members of the MSProjectRole or MSProjectServerRole roles, you must update this information in the registry. Use the ConnInfo tool to update this information. The Project Server Health Monitor tool (psHealthMon.exe) is designed to provide detection and notification of specific system components that are responding slowly or not at all in a Microsoft Project Server 2002 or Project Server 2003 deployment. This tool monitors the number of files in the ViewDrop folder and the response time for Project Data Service (PDS) calls. You can configure thresholds for the number of files in the ViewDrop folder, the length of time a file spends in the ViewDrop folder, and time allowed for basic PDS calls. If any of these thresholds are exceeded, psHealthMon.exe can record this information in a log file or notify you by e-mail.
The Project Server Health Monitor tool can be configured to monitor up to three ViewDrop folders and up to four Project Servers for PDS response time.
Microsoft Office Project Server 2003 uses the Project Server Tracing Service to log application errors to the Event Viewer. You can use the Project Server SetTracing tool (SetTracing.exe) to redirect the tracing output to a log file, or to the Event Viewer and a log file. Directing application errors to a log file produces an output format for the errors that you can send to Microsoft Product Support Services. This makes it easier for product support specialists to determine the cause of any errors that your organization might experience.
The Rename Project tool (ProjRenamer.exe) enables Project Server administrators to rename a project, or multiple projects, that are stored in the same SQL Server database. This tool combines a PDS extension with an application.
The SmokeTest tool (SmokeTest.exe) runs a series of tests to verify the basic functionality of a Microsoft Office Project Server 2003 installation and reports the results and performance timings for each test. The View Backup and Restore tool (ViewBackup.exe) is a command-line tool that you can use to back up and restore the views that you create in Project Web Access. Use this tool to move views to a different computer running Project Server 2003.
You can back up and restore the following types of views: Project views, Project Center views, Assignment views, Resource Center views, Timesheet views, and Portfolio Analyzer views.
The View Effective Rights tool enables Microsoft Office Project Server 2003 administrators to more easily troubleshoot issues with security settings and access control by combining a PDS extension with a Project Web Access ASP page. This tool enables administrators to identify the projects or resources to which users have access.
You can use the View Populator tool (ViewPopulator.exe) to publish projects without using Project Professional. ViewPopulator.exe places XML files in your Project Server ViewDrop folder for each project you publish. The Views Notification Service then publishes the information in the XML files to the view tables in the database. |
|