Update-MicrosoftProject Cmdlet
Updates Microsoft Project data.
Syntax
Update-MicrosoftProject [parameters]
Remarks
The Update-MicrosoftProject cmdlet allows you to use a syntax similar to SQL UPDATE statements to update Microsoft Project data.
$conn = Connect-MicrosoftProject -User 'myuseraccount' -Password 'mypassword' -URL 'http://myserver/myOrgRoot'
Update-MicrosoftProject -Connection $conn -Table "Projects" -Columns @("Name") -Values @("Jon Doe") -Id "11111111-c6be-e111-1f1e-00155d055681"
The Where parameter can also be used to specify the primary key of the table:
Update-MicrosoftProject -Connection $conn -Table "Projects" -Columns @("Name") -Values @("Jon Doe") -Where "Id = '11111111-c6be-e111-1f1e-00155d055681'"
The primary key can also be passed to the cmdlet along the pipeline:
Select-MicrosoftProject -Connection $conn -Table Projects -Where "Name = 'Tax Checker'" | Update-MicrosoftProject -Columns @("Name") -Values @("Tax Checker 2")