Operations for the Stsadm command-line tool in Microsoft Office Project Server 2007
This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.
Topic Last Modified: 2016-11-14
This chapter describes the operations that you can perform in Microsoft Office Project Server 2007 by using the Stsadm command-line tool.
Note
To use the Stsadm command-line tool, you must be a member of the Administrators group on the local computer that is running Office Project Server 2007.
In this article:
Operation name: Projcatgroupbackup
Operation name: Projcatgrouprestore
Operation name: Projcreatecategory
Operation name: Projcreateentity
Operation name: Projcreategroup
Operation name: Projcreatepwainstance
Operation name: Projcustfieldsbackup
Operation name: Projcustfieldsrestore
Operation name: Projdeactivateentity
Operation name: Projdeletecategory
Operation name: Projdeletegroup
Operation name: Projdeletepwainstance
Operation name: Projeglobalbackup
Operation name: Projeglobalrestore
Operation name: Projenumcategories
Operation name: Projenumgroups
Operation name: Projenumpermissions
Operation name: Projenumprojects
Operation name: Projenumpwainstances
Operation name: Projenumsecuritytemplates
Operation name: Projenumusers
Operation name: Projerpbackup
Operation name: Projerprestore
Operation name: Projguidfromcategoryname
Operation name: Projguidfromentitydisplayname
Operation name: Projguidfromentityemail
Operation name: Projguidfromentitylogonname
Operation name: Projguidfromgroupname
Operation name: Projguidfrompermissionname
Operation name: Projguidfromprojectname
Operation name: Projguidfromsecuritytemplatename
Operation name: Projguidfromviewname
Operation name: Projmodifyentitysettings
Operation name: Projmodifyprojectsettingsincategory
Operation name: Projmodifyprojectsincategory
Operation name: Projmodifyresourcesettingsincategory
Operation name: Projmodifyresourcesincategory
Operation name: Projmodifyusergroupcategorypermissions
Operation name: Projmodifyusergroupcategorypermissionsbytemplate
Operation name: Projmodifyusergroupglobalpermissions
Operation name: Projmodifyusergroupincategory
Operation name: Projmodifyuseringroup
Operation name: Projmodifyviewsincategory
Operation name: Projonlinebackup
Operation name: Projonlinerestore
Operation name: Projreadbackupschedule
Operation name: Projsyssettingsbackup
Operation name: Projsyssettingsrestore
Operation name: Projupdatebackupschedule
Operation name: Projupdateentity
Operation name: Projupdatepwainstance
Operation name: Projviewcategorydetails
Operation name: Projviewentitydetails
Operation name: Projviewgroupdetails
Operation name: Projviewpwainstance
Operation name: Projviewsbackup
Operation name: Projviewsrestore
Operation name: Projcatgroupbackup
Description
Backs up the category and group settings.
Syntax
stsadm –o projcatgroupbackup –url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projcatgrouprestore
Description
Restores the categories and groups from backup.
Syntax
stsadm -o projcatgrouprestore -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projcreatecategory
Description
Creates a security category in Project Web Access.
Syntax
stsadm -o projcreatecategory -url <URL name>
** -categoryname <category name>**
** [-description] <description>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
String, such as "Test" |
Yes |
Name of the category |
description |
String, such as "This category is used for" |
No |
Description of the category |
Operation name: Projcreateentity
Description
Creates a new Project Server user.
Syntax
stsadm -o projcreateentity -url <URL name>
** -entitytype <entity type>**
** [-restype] <resource type>**
** -displayname <display name>**
** [-authtype] <authentication type>**
** [-logonname] <logon name>**
** [-email] <e-mail address>**
** [-rbs] <Rbs>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
entitytype |
Any one of the following:
|
Yes |
Entity type |
restype |
Any one of the following:
|
No |
Resource type |
authtype |
Any one of the following:
|
No |
Authentication type to use |
logonname |
A valid username in the form: Domain\username |
No |
Logon name |
A valid e-mail address in the form: someone@example.com |
No |
E-mail address |
|
rbs |
A valid Resource Breakdown Structure (RBS) in the form: RBSNode1.RBSNode2 |
No |
Resource Breakdown Structure |
Operation name: Projcreategroup
Description
Creates a specific group from Project Web Access.
Syntax
stsadm -o projcreategroup -url <URL name>
** -groupname <display name>**
** [-description] <description>**
** [-adgroup] <group name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
groupname |
String, such as "Marketing" |
Yes |
Display name of the group |
description |
String, such as "This is a test group" |
No |
Description of the group |
adgroup |
A valid Active Directory group, such as "ADGroup1" |
No |
Active Directory group to be synchronized |
Operation name: Projcreatepwainstance
Description
Creates a new instance of Project Web Access and the relevant Project Server databases.
Syntax
stsadm -o projcreatepwainstance -url <URL name>
** [-sspname] <SSP name>**
** -adminaccount <account name>**
** -primarydbserver <primary database server name>**
** -publisheddbname <published database name>**
** -draftdbname <draft database name>**
** -archivedbname <archive database name>**
** -reportingdbserver <reporting database server name>**
** -reportingdbname <reporting database name>**
** [-hostheaderwebapplicationurl] <host header name>**
** [-lcid] <locale ID>**
** [-wait] <wait for provisioning to complete>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
sspname |
A valid Shared Services Provider (SSP) name, such as "SharedServices1" |
Yes |
SSP name (If not supplied, the default SSP is used.) |
adminaccount |
A valid account in the form: Domain\username |
Yes |
The domain account of an administrator for the instance |
primarydbserver |
A valid database name, such as "PrimaryDB" |
No |
The primary database server |
publisheddbname |
A valid database name, such as "PublishedDB" |
Yes |
The published database name |
draftdbname |
A valid database name, such as "DraftDB" |
Yes |
The working database name |
archivedbname |
A valid database name, such as "ArchiveDB" |
Yes |
The archive database name |
reportingdbserver |
A valid database name, such as "Reporting" |
Yes |
The reporting database server |
reportingdbname |
A valid database name, such as "ReportingDB" |
Yes |
The reporting database name |
hostheaderwebapplicationurl |
A valid host header name, such as "http://www.contoso.com" |
No |
The host header name |
lcid |
A valid locale ID, such as "1033" for English |
No |
The locale ID. If this is not set, the locale of the user executing the command is used. If that does not exist, the default server is used. |
wait |
Any one of the following:
|
No |
Wait for provisioning to complete |
Operation name: Projcustfieldsbackup
Description
Backs up Enterprise custom fields and lookup tables.
Syntax
stsadm -o projcustfieldsbackup -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projcustfieldsrestore
Description
Restores Enterprise custom fields and lookup tables from backup.
Syntax
stsadm -o projcustfieldsrestore -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projdeactivateentity
Description
Deactivate a user or resource. Either entityname or entityid must be specified.
Syntax
stsadm -o projdeactivateentity
** -url <URL name>**
** [-entityname] <user display name>**
** [-entityid] <user GUID>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
entityname |
Text string, such as "Fred" |
Yes |
Display name of the user |
entityid |
ID number, such as "1DFA3537-766A-41D8-94AC-7F6BEA8E112U" |
Yes |
GUID of the user |
Operation name: Projdeletecategory
Description
Deletes a specific category from Project Web Access.
Syntax
stsadm -o projdeletecategory
** -url <URL name>**
** [-categoryname] <category name>**
** [-categoryid] <category GUID>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
Text string, such as "test category" |
No, but either categoryname or categoryid is required. |
Name of the category that you want to delete |
categoryid |
ID number, such as "1DFA3537-766A-41D8-94AC-7F6BEA8E112E" |
No, but either categoryname or categoryid is required. |
GUID of the category that you want to delete |
Operation name: Projdeletegroup
Description
Deletes a specific group from Project Web Access.
Syntax
stsadm -o projdeletegroup
** -url <URL name>**
** [-groupname] <group name>**
** [-groupid] <group GUID>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
groupname |
String, such as "Sales" |
No, but either groupname or groupid is required. |
Name of the group that you want to delete |
groupid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112G" |
No, but either groupname or groupid is required. |
GUID of the group that you want to delete |
Operation name: Projdeletepwainstance
Description
Removes the relevant data for an existing instance of Project Web Access from the configuration database.
Note
This operation does not delete the Project Web Access site or Project Server databases.
Syntax
stsadm -o projdeletepwainstance
** -url <URL name>**
** [-sspname] <SSP name>**
** [-wait] <wait for provisioning to complete>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
sspname |
A valid Shared Services Provider (SSP) name, such as "SharedServices1" |
No |
SSP name (If not supplied, the default SSP is used.) |
wait |
Any one of the following:
|
No |
Wait for provisioning to complete. |
Operation name: Projeglobalbackup
Description
Backs up the Enterprise global project.
Syntax
stsadm -o projeglobalbackup -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projeglobalrestore
Description
Restores a global project from a backup.
Syntax
stsadm -o projeglobalrestore -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projenumcategories
Description
Enumerates all security categories within one Project Web Access instance.
Syntax
stsadm -o projenumcategories -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projenumgroups
Description
Enumerates all security groups within one Project Web Access instance.
This operation is equalivent to the User Interface setting that is located in Server Settings, Manage Groups.
Syntax
stsadm -o projenumgroups -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projenumpermissions
Description
Enumerates all global permissions within one Project Web Access instance.
The result of this command is determined by the value given to the catorglobal parameter.
Syntax
stsadm -o projenumpermissions -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
catorglobal |
Any one of the following:
|
Yes |
Category or global permissions |
Operation name: Projenumprojects
Description
Enumerates all projects within one Project Web Access instance.
Syntax
stsadm -o projenumprojects -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projenumpwainstances
Description
Returns information about all Project Web Access instances associated with either the default Shared Services Provider (SSP) or a specified SSP.
Syntax
stsadm -o projenumpwainstances -sspname <SSP name>
Parameters
Parameter |
Value |
Required? |
Description |
sspname |
A valid SSP name, such as "SharedServices1" |
Yes |
SSP name (If not supplied, the default SSP is used.) |
Operation name: Projenumsecuritytemplates
Description
Enumerates all security templates within one Project Web Access instance.
Syntax
stsadm -o projenumsecuritytemplates -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projenumusers
Description
Enumerates all users within one Project Web Access instance.
Syntax
stsadm -o projenumusers -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projerpbackup
Description
Backs up the Enterprise Resource Pool and Calendar data.
Note
This data is not versioned; only the most recent copy is stored.
Syntax
stsadm -o projerpbackup -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projerprestore
Description
Restores the Enterprise Resource Pool and Calendar data from the archive store.
Syntax
stsadm -o projerprestore -url <URL name>
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projguidfromcategoryname
Description
Returns the globally unique identifier (GUID) for a particular category name.
Syntax
stsadm -o projguidfromcategoryname
** -url <URL name>**
** -categoryname <category name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
A valid category name, such as "test category" |
Yes |
Category name |
Operation name: Projguidfromentitydisplayname
Description
Returns a globally unique identifier (GUID) for a particular user resource name.
Syntax
stsadm -o projguidfromentitydisplayname
** -url <URL name>**
** -displayname <display name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
displayname |
String, such as "Fred" |
Yes |
Display name of the user |
Operation name: Projguidfromentityemail
Description
Returns a globally unique identifier (GUID) for a particular user or resource based on an e-mail address.
Syntax
stsadm -o projguidfromentityemail
** -url <URL name>**
** -email <e-mail address>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
displayname |
A valid e-mail address in the form: someone@example.com |
Yes |
E-mail address of the user |
Operation name: Projguidfromentitylogonname
Description
Returns a globally unique identifier (GUID) for a particular logon account name.
Syntax
stsadm -o projguidfromentitylogonname
** -url <URL name>**
** -logonname <logon name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
logonname |
A valid logon name in the form: Domain\username |
Yes |
Logon name |
Operation name: Projguidfromgroupname
Description
Returns a globally unique identifier (GUID) for a particular group's display name.
Syntax
stsadm -o projguidfromgroupname
** -url <URL name>**
** -groupname <group name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
groupname |
String, such as "Marketing" |
Yes |
Name of the group |
Operation name: Projguidfrompermissionname
Description
Returns a globally unique identifier (GUID) for a particular permission name.
Syntax
stsadm -o projguidfrompermissionname
** -url <URL name>**
** -permname <permission name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
permname |
A valid permission name, such as ViewTeamBuilder |
Yes |
Name of a global or category permission |
Operation name: Projguidfromprojectname
Description
Returns a globally unique identifier (GUID) for a particular project name.
Syntax
stsadm -o projguidfromprojectname
** -url <URL name>**
** -projectname <project name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
projectname |
A valid project name, such as "Proj1" |
Yes |
Name of the project |
Operation name: Projguidfromsecuritytemplatename
Description
Returns a globally unique identifier (GUID) for a particular security template name.
Syntax
stsadm -o projguidfromsecuritytemplatename
** -url <URL name>**
** -templatename <template name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
templatename |
A valid template name, such as "test template" |
Yes |
Name of the template |
Operation name: Projguidfromviewname
Description
Returns a globally unique identifier (GUID) for a particular view's name.
Syntax
stsadm -o projguidfromviewname
** -url <URL name>**
** -viewname <view name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
viewname |
A valid view name, such as "View1" |
Yes |
Name of the view |
Operation name: Projmodifyentitysettings
Description
Updates a user's resource settings.
Syntax
stsadm -o projmodifyentitysettings -url <URL name>
** -entityid <user GUID>**
** [-entitytype] <entity type>**
** [-restype] <resource type>**
** [-authtype] <authentication type>**
** [-logonname] <logon name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
entityid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112E" |
Yes |
GUID of the user |
entitytype |
Any one of the following:
|
No |
Entity type |
restype |
Any one of the following:
|
No |
Resource type |
authtype |
Any one of the following:
|
No |
Authentication type |
logonname |
A valid logon name in the form: Domain\username |
No |
Logon name |
Operation name: Projmodifyprojectsettingsincategory
Description
Modifies the project settings for a category. Choose either all current and future projects, or specific projects. You can also use dynamic category rules. In the case where -allcurrentandfuture is chosen and -onlyselected and dynamic category rules are chosen, -allcurrentandfuture will have no effect.
Syntax
stsadm -o projmodifyprojectsettingsincategory
** -url <URL name>**
** [-categoryname] <category name>**
** [-categoryid] <category GUID>**
** [-allcurrentandfuture] <current and future projects in Project Server database>**
** [-onlyselected] <only added projects>**
** [-ruleprojecttheymanage] <managed projects>**
** [-ruleassignedasteammember] <team member>**
** [-rulemanagedbyresourcestheymanage] <managed resources>**
** [-ruleresourcestheymanageassigned] <assigned resources>**
** [-ruleowneratsamerbsnodeasuser] <resources in the same node>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
A valid category name, such as "test category" |
No |
Name of the category that you want to modify |
categoryid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112E" |
No |
GUID of the category that you want to modify |
allcurrentandfuture |
<none> |
No |
No value is specified. The presence of this parameter will apply the specified rule to all current and future projects in the database. |
onlyselected |
<none> |
No |
No value is specified. The presence of this parameter will apply the specified rule to only the selected projects. |
ruleprojecttheymanage |
Any one of the following:
|
No |
Projects that the user manages |
ruleassignedasteammember |
Any one of the following:
|
No |
Projects in which they are a team member |
rulemanagedbyresourcestheymanage |
Any one of the following:
|
No |
Projects in which they manage resources that are managed by a user |
ruleresourcestheymanageassigned |
Any one of the following:
|
No |
Projects assigned to resources that they manage |
ruleowneratsamerbsnodeasuser |
Any one of the following:
|
No |
Project resources that are in the same node as self |
Operation name: Projmodifyprojectsincategory
Description
Adds or removes individual projects from a specified category.
Syntax
stsadm -o projmodifyprojectsincategory
** -url <URL name>**
** [-categoryname] <category name>**
** [-categoryid] <category GUID>**
** [-projectname] <project name>**
** [-projectid] <project GUID>**
** -addorremove <add or remove project>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
A valid category name, such as "test category" |
No, but a categoryname or categoryid should be specified. |
Name of the category that you want to modify |
categoryid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112E" |
No, but a categoryname or categoryid should be specified. |
GUID of the category that you want to modify |
projectname |
A valid project name, such as "Proj1" |
No |
Name of the project that you want to modify |
projectid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112F" |
No |
GUID of the project that you want to modify |
addorremove |
Any one of the following:
|
Yes |
Add or remove a project |
Operation name: Projmodifyresourcesettingsincategory
Description
Adds or removes individual resources settings in a specific category. In the case where the -allcurrentandfuture and –onlyselected parameters are chosen, the -allcurrentandfuture parameter will have no effect.
Syntax
stsadm -o projmodifyresourcesettingsincategory
** -url <URL name>**
** [-categoryname] <category name>**
** [-categoryid] <category GUID>**
** [-allcurrentandfuture] <current and future projects>**
** [-onlyselected] <resources added>**
** [-ruleself] <rules they manage>**
** [-ruleresourcesinprojectstheymanage] <team member resources>**
** [-ruleresourcestheymanage] <managed resource name>**
** [-rulemanagedirectly] <assigned resource name>**
** [-ruleresourceatsamerbsnodeasself] <same level as owner>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
A valid category name, such as "test category" |
No |
Name of the category that you want to modify |
categoryid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112E" |
No |
GUID of the category that you want to modify |
allcurrentandfuture |
<none> |
No |
No value is specified. The presence of this parameter will apply the specified rule to all current and future projects in the database |
onlyselected |
<none> |
No |
No value is specified. The presence of this parameter will apply the specified rule to only the selected projects. |
ruleself |
Any one of the following:
|
No |
Their own information |
ruleresourcestheymanage |
Any one of the following:
|
No |
Information for all resources to projects that they manage |
ruleresourcesinprojectstheymanage |
Any one of the following:
|
No |
Projects in which they are a team member |
rulemanagedirectly |
Any one of the following:
|
No |
Assigned to all resources that they manage directly |
ruleresourceatsamerbsnodeasself |
Any one of the following:
|
No |
At the same level as owner |
Operation name: Projmodifyresourcesincategory
Description
Adds or removes individual resources from a specific category.
Syntax
stsadm -o projmodifyresourcesincategory
** -url <URL name>**
** [-categoryname] <category name>**
** [-categoryid] <category GUID>**
** [-resname] <resource name>**
** [-resid] <resource GUID>**
** -addorremove <add or remove resource>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
A valid category name, such as "test category" |
No |
Name of the category that you want to modify |
categoryid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112E" |
No |
GUID of the category that you want to modify |
resname |
A valid resource name, such as "Res1" |
No |
Name of the resource that you want to modify |
resid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112F" |
No |
GUID of the resource that you want to modify |
addorremove |
Any one of the following:
|
Yes |
Add or remove a project |
Operation name: Projmodifyusergroupcategorypermissions
Description
Changes a user's or group's category permissions for a specified category. The permissions can be: Allowed, Denied, or None.
Syntax
stsadm -o projmodifyusergroupcategorypermissions
** -url <URL name>**
** [-categoryname] <category name>**
** [-categoryid] <category GUID>**
** [-username] <user display name>**
** [-userid] <user GUID>**
** [-groupname] <group display name>**
** [-groupid] <group GUID>**
** -permid <permission GUID>**
** -settings <permission settings>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
A valid category name, such as "test category" |
No |
Name of the category on which to set the permission |
categoryid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112E" |
No |
GUID of the category |
username |
String, such as "Joe" |
No |
Display name of the user |
userid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112U" |
No |
GUID of the user |
groupname |
String, such as "Sales" |
No |
Display name of the group |
groupid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112G" |
No |
GUID of the group |
permid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112P" |
Yes |
GUID of the permissions |
settings |
Any one of the following:
|
Yes |
Permission settings |
Operation name: Projmodifyusergroupcategorypermissionsbytemplate
Description
Modifies a user's or group's category permissions by a specified security template.
Syntax
stsadm -o projmodifyusergroupcategorypermissionsbytemplate
** -url <URL name>**
** [-categoryid] <category GUID>**
** [-categoryname] <category name>**
** [-userid] <user GUID>**
** [-username] <user display name>**
** [-groupid] <group GUID>**
** [-groupname] <group display name>**
** [-templateid] <template GUID>**
** [-templatename] <template display name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
A valid category name, such as "test category" |
No |
Name of the category on which to set the permission |
categoryid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112E" |
No |
GUID of the category |
username |
String, such as "Joe" |
No |
Display name of the user |
userid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112U" |
No |
GUID of the user |
groupname |
String, such as "Sales" |
No |
Display name of the group |
groupid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112G" |
No |
GUID of the group |
templateid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112T" |
No |
GUID of the template |
templatename |
String, such as "Template1" |
No |
Display name of the template |
Operation name: Projmodifyusergroupglobalpermissions
Description
Modifies a user's or group's global permissions.
Syntax
stsadm -o projmodifyusergroupglobalpermissions
** -url <URL name>**
** [-username] <user display name>**
** [-userid] <user GUID>**
** [-groupname] <group display name>**
** [-groupid] <group GUID>**
** -permid <permission GUID>**
** -settings <permission settings>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
username |
String, such as "Joe" |
No |
Display name of the user |
userid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112U" |
No |
GUID of the user |
groupname |
String, such as "Sales" |
No |
Display name of the group |
groupid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112G" |
No |
GUID of the group |
permid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112P" |
Yes |
GUID of the permissions |
settings |
Any one of the following:
|
Yes |
Permission settings |
Operation name: Projmodifyusergroupincategory
Description
Allows administrators to add or remove users and groups from a category.
Syntax
stsadm -o projmodifyusergroupincategory
** -url <URL name>**
** [-addorremove] <add or remove user>**
** [-username] <user display name>**
** [-userid] <user GUID>**
** [-groupname] <group display name>**
** [-groupid] <group GUID>**
** [-categoryname] <category name>**
** [-categoryid] <category GUID>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
addorremove |
Any one of the following:
|
No |
Add or remove a user |
username |
String, such as "Joe" |
No |
Display name of the user |
userid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112U" |
No |
GUID of the user |
groupname |
String, such as "Sales" |
No |
Display name of the group |
groupid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112G" |
No |
GUID of the group |
categoryname |
String, such as "test category" |
No |
Name of the category on which to set the permission |
categoryid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112C" |
No |
GUID of the category |
Operation name: Projmodifyuseringroup
Description
Adds or removes individual users from a specified Group. Either the name or the ID of the group is required as is either the name or the ID of the user that you want to add or remove from the group.
Syntax
stsadm -o projmodifyuseringroup
** -url <URL name>**
** [-groupname] <group name>**
** [-groupid] <group GUID>**
** [-username] <user name>**
** [-userid] <user GUID>**
** -addorremove <add or remove user>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
groupname |
String, such as "TestGroup" |
No, but either groupname or groupid is required. |
Name of the group that you want to modify |
groupid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112G" |
No, but either groupname or groupid is required. |
GUID of the group that you want to modify |
username |
String, such as "Joe" |
No, but either username or userid is required. |
Name of the user that you want to modify |
userid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112U" |
No, but either username or userid is required. |
GUID of the user that you want to modify |
addorremove |
Any one of the following:
|
Yes |
Add or remove a user |
Operation name: Projmodifyviewsincategory
Description
Adds or removes individual views from a specific category.
Syntax
stsadm -o projmodifyviewsincategory
** -url <URL name>**
** [-categoryname] <category name>**
** [-categoryid] <category GUID>**
** [-viewname] <view name>**
** [-viewid] <view GUID>**
** -addorremove <add or remove view>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
String, such as "test category" |
No |
Name of the category that you want to modify |
categoryid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112C" |
No |
GUID of the category that you want to modify |
viewname |
String, such as "View1" |
No |
Name of the view that you want to modify |
viewid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112V" |
No |
GUID of the view that you want to modify |
addorremove |
Any one of the following:
|
Yes |
Add or remove a user |
Operation name: Projonlinebackup
Description
Backs up a project.
Syntax
stsadm -o projonlinebackup
** -url <URL name>**
** -projectguid <project GUID>**
** [-archivedprojectguid] <archive GUID>**
** [-versiondescription] <description>**
** [-retentionpolicy] <number of projects to be retained>**
** [-overwritearchive] <archive setting>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
projectguid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112P" |
Yes |
GUID of the project in the draft store |
archivedprojectguid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112A" |
No |
GUID to identify the project |
versiondescription |
String, such as "Viewname1" |
No |
Name of the view that you want to modify |
retentionpolicy |
Integer, such as "5" |
No |
Number of projects to be retained in the archived store at one time |
overwritearchive |
Any one of the following:
|
No |
Default value is false. If true, and archivedprojectguid is already being used, it will overwrite the existing project. |
Operation name: Projonlinerestore
Description
Restores a project from backup.
Syntax
stsadm -o projonlinerestore
** -url <URL name>**
** -projectguid <project GUID>**
** -versionguid <version GUID>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
projectguid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112P" |
Yes |
GUID of the project |
versionguid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112V" |
Yes |
GUID of the version |
Operation name: Projreadbackupschedule
Description
Displays the daily backup schedule.
This setting corresponds to the User Interface setting located in Daily Backup Schedule in Server Settings, Database Administration, Schedule Backup.
Syntax
stsadm -o projreadbackupschedule
** -url <URL name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projsyssettingsbackup
Description
Backs up system settings.
Syntax
stsadm -o projsyssettingsbackup
** -url <URL name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projsyssettingsrestore
Description
Restores system settings from backup.
Syntax
stsadm -o projsyssettingsrestore
** -url <URL name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projupdatebackupschedule
Description
Updates the backup schedule. Times in the schedule use the 24-hour time format hour:minute, such as 10:15 and 16:45.
Syntax
stsadm -o projupdatebackupschedule
** -url <URL name>**
** [-project] <project schedule>**
** [-erp] <Enterprise Resource Pool schedule>**
** [-customfields] <CustomFields schedule>**
** [-eglobal] <schedule>**
** [-syssettings] <system setting schedule>**
** [-catgroup] <category schedule>**
** [-views] <view schedule>**
** [-archiveretention] <number of versions>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
project |
A valid 24-hour time format in the form: Hour:minute, such as 10:15 and 16:45 |
No |
Schedule of when project backup should occur |
erp |
A valid 24-hour time format in the form: Hour:minute, such as 10:15 and 16:45 |
No |
Schedule of when Enterprise Resource Pool (ERP) backup should occur |
customfields |
A valid 24-hour time format in the form: Hour:minute, such as 10:15 and 16:45 |
No |
Schedule of when custom fields backup should occur |
eglobal |
A valid 24-hour time format in the form: Hour:minute, such as 10:15 and 16:45 |
No |
Schedule of when a Enterprise global backup should occur |
syssettings |
A valid 24-hour time format in the form: Hour:minute, such as 10:15 and 16:45 |
No |
Schedule of when system settings backup should occur |
catgroup |
A valid 24-hour time format in the form: Hour:minute, such as 10:15 and 16:45 |
No |
Schedule of when category and group settings backup should occur |
views |
A valid 24-hour time format in the form: Hour:minute, such as 10:15 and 16:45 |
No |
Schedule of when views backup should occur |
archiveretention |
Integer, such as "5" |
No |
Default number of versions of a project to preserve |
Operation name: Projupdateentity
Description
Updates a project resources and users. The Resource Breakdown Structure (RBS) value must be specified in the format RBSNode1.RBSNode2.
Syntax
stsadm -o projupdateentity
** -url <URL name>**
** -entityid <user GUID>**
** [-entitytype] <entity type>**
** [-restype] <resource type>**
** [-displayname] <display name>**
** [-rbs] <Rbs>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
entityid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112E" |
Yes |
GUID of the user |
entitytype |
Any one of the following:
|
No |
Entity type |
restype |
Any one of the following:
|
No |
Resource type |
displayname |
String, such as "Joe" |
No |
Display name |
rbs |
A valid Resource Breakdown Structure (RBS) in the form: RBSNode1.RBSNode2 |
No |
Resource Breakdown Structure |
Operation name: Projupdatepwainstance
Description
Updates an existing instance of Project Web Access and the relevant Project Server databases.
Syntax
stsadm -o projupdatepwainstance
** -url <URL name>**
** [-sspname] <SSP name>**
** -primarydbserver <primary database server name>**
** -publisheddbname <published database name>**
** -draftdbname <draft database name>**
** -archivedbname <archive database name>**
** -reportingdbserver <reporting database server name>**
** -reportingdbname <reporting database name>**
** [-wait] <wait for provisioning to complete>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
sspname |
A valid Shared Services Provider (SSP) name, such as "SharedServices1" |
No |
SSP name (If not supplied, the default SSP is used.) |
primarydbserver |
A valid database name, such as "PrimaryDB" |
Yes |
The primary database server name |
publisheddbname |
A valid database name, such as "PublishedDB" |
Yes |
The published database name |
draftdbname |
A valid database name, such as "DraftDB" |
Yes |
The draft database name |
archivedbname |
A valid database name, such as "ArchiveDB" |
Yes |
The archive database name |
reportingdbserver |
A valid database name, such as "Reporting" |
Yes |
The reporting database server name |
reportingdbname |
A valid database name, such as "ReportingDB" |
Yes |
The reporting database name |
wait |
Any one of the following:
|
No |
Wait for provisioning to complete. |
Operation name: Projviewcategorydetails
Description
Returns details of a category based on either the category name or globally unique identifier (GUID) for that category.
Syntax
stsadm -o projviewcategorydetails
** -url <URL name>**
** [-categoryname] <category name>**
** [-categoryid] <category GUID>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
categoryname |
String, such as "test category" |
No |
Name of the category |
categoryid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112C" |
No |
GUID of the category |
Operation name: Projviewentitydetails
Description
Returns details of a user or resource based on either the display name or globally unique identifier (GUID) for that user or resource. Either displayname or userid must be specified.
Syntax
stsadm -o projviewentitydetails
** -url <URL name>**
** [-displayname] <display name>**
** [-userid] <user GUID>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
displayname |
String, such as "Joe" |
No, but either displayname or userid is required. |
Display name of the user |
userid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112U" |
No, but either displayname or userid is required. |
GUID of the user |
Operation name: Projviewgroupdetails
Description
Returns security group details.
Syntax
stsadm -o projviewgroupdetails
** -url <URL name>**
** [-groupname] <display name>**
** [-groupid] <group GUID>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
groupname |
String, such as "Sales" |
No, but either groupname or groupid is required. |
Display name of the group |
groupid |
A valid GUID in the form: "1DFA3537-766A-41D8-94AC-7F6BEA8E112G" |
No, but either groupname or groupid is required. |
GUID of the group |
Operation name: Projviewpwainstance
Description
Returns information about a specific Project Web Access instance, including the site host header information.
Syntax
stsadm -o projviewpwainstance
** -url <URL name>**
** [-sspname] <SSP name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
sspname |
A valid Shared Services Provider (SSP) name, such as "SharedServices1" |
No |
SSP name (If not supplied, the default SSP is used.) |
Operation name: Projviewsbackup
Description
Backs up all view definitions.
This setting corresponds to the User Interface setting located in Server Settings, Look and Feel, Manage Views.
Syntax
stsadm -o projviewsbackup
** -url <URL name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Operation name: Projviewsrestore
Description
Restores view definitions from backup.
Syntax
stsadm -o projviewsrestore
** -url <URL name>**
Parameters
Parameter |
Value |
Required? |
Description |
url |
A valid URL, such as "http://server_name/pwa" |
Yes |
URL of the Project Web Access site |
Download this book
This topic is included in the following downloadable book for easier reading and printing:
See the full list of available books at Downloadable content for Project Server 2007.