Running multiple cmd commands from powershell script as if I was running it in cmd shell

Question

I am trying to create a powershell script which will create a session in a remote machine and run a series of commands. These commands in question are to drop a Mongodb database before deployment of code.

I have the session side working but when I try to run the cmd I get X is not recognized as the name of a cmdlet.

The process I take when I am logged into the remote machine and using cmd is:

'C:\Program Files\MongoDB\Server\4.0\bin\mongo.exe'
use <database>
db.dropDatabase()

This works correctly and I am trying to run those in powershell. They need to be run line by line in order to work.

ps1:

$session = New-PSSession -ComputerName "remoteMachine" -Credential $cred

Enter-PSSession -Session $session

Invoke-Command -ComputerName "remoteMachine" -ScriptBlock {
    & 'C:\Program Files\MongoDB\Server\4.0\bin\mongo.exe' 
    & 'use <database>'
    & 'db.dropDatabase()'
}

Exit-PSSession
Get-PSSession | Remove-PSSession

When this is run I am getting the following errors:

The term 'use Assessment' is not recognized as the name of a cmdlet,

The term 'db.dropDatabase()' is not recognized as the name of a cmdlet,

Ross · Accepted Answer · 2019-03-13 10:38:57Z

1

I managed to figure it out by looking through & 'C:\Program Files\MongoDB\Server\4.0\bin\mongo.exe' --help.

Rather than using multiple lines, I put the command on one line like:

Invoke-Command -ComputerName "remoteMachine" -ScriptBlock {
    & 'C:\Program Files\MongoDB\Server\4.0\bin\mongo.exe' <database> --eval '<action>'
}

For example:

Invoke-Command -ComputerName "remoteMachine" -ScriptBlock {
    & 'C:\Program Files\MongoDB\Server\4.0\bin\mongo.exe' testDatabase --eval 'db.dropDatabase()'
}

answered Mar 13, 2019 at 10:38

Ross

2,4777 gold badges50 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Running multiple cmd commands from powershell script as if I was running it in cmd shell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related